I had a similar issue (not with sp3) but it was because someone had changed the actual directory to the default dir eg (\mssql\backup\) as opposed to a drive that was made specifically for backups, which in this case had not enough space. My first suggestion would be to try and backup the databases to […]
2003-06-23
Hello. I unfortunately don't have any experience with the DUMP command beyond BOL which suggests it shouldn't be used (GURUS: IS THIS TRUE FOR A ONE TIME SHOT?). I ran the following script using the BACKUP command, it could probably be modified to use the DUMP command declare @BackUp varchar(500), @DatabaseName varchar(500) Set @DatabaseName = […]
2003-06-17
I admit it, I speak german as well. But does that mean a erman speaking forum would be a good idea ??? Personally I don't think sobecause you'll loose the input of everyone else not speaking german (or Spanish, French, Dutch whatever). They had special forums in other languages at the PASS site, but none […]
2003-06-17
DBCC SHOWCONTIG It Will show you page density, extent switches and so on. refer it on BOL MW
2003-06-13
2003-06-11
1 reads
There have been some threads about multi-processor machines behaving strangely. Maybe something to check out ...
2003-06-11
Also, instead of the Administration forum, scroll down and check out the Certification forum. -SQLBill
2003-06-02
1 reads
quote: where do you adjust all the major settings in sql? is it done in enterprise manager? To change the "major" settings for a DATABASE in SQL Server, use ALTER DATABASE or sp_dboption. BOL has info for these procedures. HTH, Jay ps. Is there a specific setting you are trying to modify?
2003-05-29
Use the following one to get the exact SQL Statement running on the server, if you cant use Profiler Exec xp_sqltrace Trace, @EventFilter = 115, @Fulltext = 1 Edited by - shastryv on 05/19/2003 1:08:03 PM
2003-05-19
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
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