Hi Chami, You can restore from another server by using the UNC path like:RESTORE DATABASE TestDB FROM DISK = '\\OldServer\backups\TestDB.bak' Derrik already pointed out the WITH MOVE option for placing the files in another location. Now you did say the MASTER database, which is another story. In order to restore the MASTER database, you need […]
2004-06-14
Oops. I found the problem myself - persistence is the key. I omitted the "New" keyword when I declared the DataSet variable.
2004-06-11
Error message:Server: Msg 169, Level 15, State 2, Line 2 A column has been specified more than once in the order by list. Columns in the order by list must be unique.Situation:The table in question is part of a maintenance plan, the log has revealed the above error.Solutions tried:Rebuilding indexes manually - causes same problem, however, […]
2004-06-09
7 reads
Sometimes it's more important to get the job done that to find the snazziest way to do it. Brute force works... most of the time... and in a lot of cases it's faster than learning something new. Then again we all know if we don't continually learn new things we'll be out of jobs in […]
2004-06-08
Okay, Thank you so much. I'm going to download it now. Also, would you happen to know if the error at the end of my sqlsp.log is the REBOOT MESSAGE? i'm still trying to figure that one out.juanita
2004-05-26
2004-05-21
3 reads
As you may or may not read in another thread I created...I am having trouble implementing the drill down..I actually have it implemented and it works great in the ReportDesigner preview pane...but when I deploy to the ReportServer and page just reloads itself when I click on the (-) for drill into.Any ideas?
2004-05-20
Hi, Is there is any other way to open a connection to an Excel application using ActiveX script in DTS other than set App=CreateObject("Excel.Application") Can we use the Jet Connection which the DTS package uses?. Thanks
2004-05-20
1 reads
Same as Sleeping, except Dormant also indicates that the SPID has been reset after completing an RPC event. The reset cleans up resources used during the RPC event. This is a normal state and the SPID is available and waiting to execute further commands. bye
2004-05-14
I do not have a SQL-server installation on the server at all and trying to install one fails and then cleans up after itself and doesn't leave anything to delete, clean up, or uninstall etc!
2004-05-13
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers