Viewing 15 posts - 421 through 435 (of 2,904 total)
Do you backup the MSDB on a regular basis? Which recovery mode does it use - if it is FULL, are you also doing transaction log backups?
-SQLBill
June 4, 2007 at 4:26 pm
SP1 had many problems....you really should install SP2.
Also, you might want to consider this:
Configure SSIS to allow remote user access
1.If the user is not a member of the local...
June 4, 2007 at 1:20 pm
On the DTS issue. SQL Server 2005 does not support DTS, it's only there for Legacy purposes. You either need to convert them to SSIS packages or download/install...
June 4, 2007 at 1:17 pm
There is only one Evaluation Edition and that gives all the functionality of Enterprise Edition.
-SQLBill
June 4, 2007 at 1:15 pm
It could. However, if the connection is killed, it could also be killing the transaction which would also cause a rollback.
-SQLBill
June 4, 2007 at 1:11 pm
You've made them 'owners' of the data. That means it is their data also as far as SQL Server is concerned.
-SQLBill
June 4, 2007 at 1:08 pm
You could, but how do you know what space will be needed by the new database(s)? Let's say you set Model for 100 MB. Then you create five databases...
June 1, 2007 at 4:47 pm
I leave model as it is, I've never seen it grow. Remember, it is just a template to be used to create other databases.
MSDB...one of my servers with the most...
June 1, 2007 at 1:32 pm
And in 2005 there was/is an issue with SP2. If you have your expire set for DAYS, you need to recreate it after applying SP2 (I'm not sure they fixed...
May 31, 2007 at 3:32 pm
We aren't going to help you cheat and I really wouldn't trust any dumps that were sent.
You can get some of the practice stuff from Transcender and other companies. ...
May 31, 2007 at 3:26 pm
I've never seen that happen, but since you are just installing SQL Server 2000, why not install SP4?
-SQLBill
May 31, 2007 at 9:58 am
David,
And minor league baseball is SO much more fun to watch than the major leagues. Back in Maryland, my wife and I went to Bowie Baysox games and really...
May 30, 2007 at 5:03 pm
Look up GROUP BY and HAVING in the Books OnLine.
GROUP BY Customers
HAVING Sales > 5000
-SQLBill
May 30, 2007 at 3:37 pm
I golf, so I go to driving range and put my frustration into hitting golf balls. When I get in a rut, I try to learn something new that...
May 30, 2007 at 1:19 pm
Reindexing causes a large growth in the data/log files. If you have to shrink the files, do so AFTER the reindexing is done.
-SQLBill
May 30, 2007 at 10:28 am
Viewing 15 posts - 421 through 435 (of 2,904 total)