Viewing 15 posts - 1,141 through 1,155 (of 1,479 total)
Could it be that you are connected to a different server in the management studio?
Adi
February 17, 2009 at 1:17 am
Records don’t have specific order in the table, so you can’t use merge and specify operations according to the order of the records in the table. With merge you...
February 16, 2009 at 10:11 pm
J (2/16/2009)
By the way, the Original poster still has not provided the table script, data entry script and sql statement. I wonder if he is really interested in an answer...
He...
February 16, 2009 at 9:39 pm
I didn’t say that you shouldn’t rebuild the index. I said that you should be sure that you can. If there is an article at MSDN that says...
February 16, 2009 at 3:20 pm
If this is a table that SQL Server uses in order to manage the replication, I’d check first if I can rebuild the index. I once had a problem...
February 16, 2009 at 2:37 pm
I don’t think that it has to do with the NULL values. When you work with from clause and you use an outer join, the server will use the...
February 16, 2009 at 10:04 am
You need to use an insert statement and not an update statement. You didn’t specify how to decide which records will be inserted into zz table. I think...
February 15, 2009 at 1:40 pm
Your question is very vage and unclear. It looks like you need an insert statement and not an update statement. If I’m wrong pleas take few minutes to read...
February 15, 2009 at 5:49 am
I don’t think that he can use the log after he did the restore operation.
Adi
February 14, 2009 at 12:42 pm
Jeff please don’t get this question the wrong way, but just out of curiosity – Is there anyone in this world that didn’t get your flying pork chops? ...
February 14, 2009 at 12:11 pm
Ninja's_RGR'us (2/13/2009)
... and in the "you're screwed category", the award goes to : http://www.sqlservercentral.com/Forums/Topic656268-357-1.aspx
When I saw his question, I couldn’t believe that he didn’t do any backup of his production...
February 13, 2009 at 10:27 pm
Most chances that there is nothing that you can do. The main question is if you really didn’t do any backup for 5 months or if there are backups...
February 13, 2009 at 2:10 am
You have to specify how to join the derived tables ALIAS1 and ALIAS2. Currently you are using both in the from clause without specifying how to join them. ...
February 13, 2009 at 1:47 am
If you stop and cancel the job when it is in the middle of an operation, this operation will be rolled back. If the step already finished running some...
February 13, 2009 at 12:54 am
SQL Server doesn’t store this information. If you need to know who updated a table and when it was updated, you need to implement your own mechanism for that....
February 13, 2009 at 12:48 am
Viewing 15 posts - 1,141 through 1,155 (of 1,479 total)