i'm trying to run this query, and i'm getting the following error Server: Msg 170, Level 15, State 1, Line 28 Line 28: Incorrect syntax near '+'....
i have both SQL 2000 Enterprise and SQL 2005 Enterprise running on a 2 node Active/Passive Cluster servers have 8 GB each, quad core CPu's etc,etc,...
i'm currently performing some memory measurements in one of our SQL 2000 box to make sure the server is not suffering from memory performance issues....
i already stopped the sql services, and copied the ldf file to another hard drive on the sql server. i need to see the details inside this file,...
i'm shrinking 2 databases at the same time to their minimum value. i used enterprise manager to schedule the job. there won't be nobody using the...
how can i create an alert in sql, that would notify me, i would be running out of space on my database drives very soon???.... Thanks
hello guys i'm trying to figure it out a way to do this i have a table with the following data plan_ID---trans_id --- Price --- 1 -------- 10m...
i'm trying to run a query like this select * from openquery(sqlserver1,' select field1, field2 from table1 where field2 between '01/01/2004...
i have a problem and i would try to do my best to explain the issue i'm having <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />i...
hello guys i have a question. every day i'm running a process to update about 3,000,000 records on table that has like 15,000,000 records. i'm using...
Separate names with a comma.
