Viewing 15 posts - 20,281 through 20,295 (of 26,484 total)
You may be having network latency issues when attempting to restore a large database over the network. You may need to copy the file to a local directory on...
June 24, 2009 at 10:15 pm
mehmel (6/24/2009)
hey hianybody knows how do i insert the current DateTime into a SP?
it seemed SYSDATETIME is not recognise built-in function name.
DECLARE @livedate DATETIME;Insert into tb1 (ErrorDate)
values(@livedate);
select CONVERT (date,SYSDATETIME());
First, what...
June 24, 2009 at 10:07 pm
Any questions after that, ask right back here or in the discussion threads of the articles above.
June 24, 2009 at 9:55 pm
The problem is that these queries may not be equivalent. What is the relationship between table1 and table2, is it a one to many relationship?
Some sample data for the...
June 24, 2009 at 9:32 pm
I really don't think restoring a database over a linked server is a supported option. Pretty sure you need to be on the server where you are attempting the...
June 24, 2009 at 9:11 pm
Sometimes that isn't possible. A few that I have helped went private because they could not provide the actual code on an open forum due to company restrictions. ...
June 24, 2009 at 9:07 pm
IMHO, that reqiuires the participants to keep everything in the public threads. It is possible that some things may best be handled privately, but I would have to say...
June 24, 2009 at 4:13 pm
karthik_sql (6/24/2009)
Database backed up. Database: OperationsManager, creation date(time): 2008/12/17(13:46:51), pages dumped: 637164, first LSN: 476:1227796:1, last LSN: 477:10953:1, number of dump devices: 1,...
June 24, 2009 at 12:43 pm
Where did you get these error messages/alerts? If from a log, could you provide the actual message? Perhaps even a portion of the log before and after the...
June 24, 2009 at 11:17 am
One, by changing your recovery model to full, you may soon find you transaction log file taking all your disk space. You now also need to start running transaction...
June 24, 2009 at 11:00 am
Welcome to the SSC Community. We frequently go off on tangents from the original question, but usually those tangents are related in some way with the topic (unless it...
June 24, 2009 at 10:54 am
Looks like he'd have deleted his posts if he could have. Doesn't help, however, where those posts had been quoted.
June 24, 2009 at 10:46 am
As it appears you were provided several approaches to solve your problem, which one did you select?
June 23, 2009 at 10:42 pm
You may want to spend some time reading BOL (Books Online, the SQL Server Help System).
Change SP_RENAMEDB to EXEC SP_RENAMEDB
June 23, 2009 at 9:55 pm
Well, its your code. What was else for? If you don't need it, drop it.
June 23, 2009 at 8:42 pm
Viewing 15 posts - 20,281 through 20,295 (of 26,484 total)