Viewing 15 posts - 7,336 through 7,350 (of 7,428 total)
I understand now. But you could still get away with 1 instance but 4 databases. Like this, MyDBDev, MyDBTest, MyDBStage, MyDBTrain and just apply your changes to all, or backup...
February 7, 2002 at 1:24 pm
Right click the server and choose properties. I believe it is the tab is something like Login or authentication but I haven't looked at 6.5 in a while.
February 7, 2002 at 1:18 pm
And if you are a business looking you can get most of them to send someone out to demo it, explain it and give you and overview of what they...
February 7, 2002 at 1:16 pm
No, but I noticed looking at the site the only terms and conditions I could find do not mention backup and responsibility. I would be sure they cover what concerns...
February 7, 2002 at 1:13 pm
My biggest improvements:
1:) Got rid of the majority of all queries using cursors and found the best way to do them.
2:) Got rid of all but important indexes.
3:) Got most...
February 7, 2002 at 1:06 pm
Have you tried doing PRINT @sql and a PRINT @tmpName instead of EXEC to make sure the text is being handle. If @tmpName is getting set to NULL then...
February 7, 2002 at 12:59 pm
Thanks, I have had troubles in the past and this helps.
February 7, 2002 at 12:51 pm
Actually look close cause Microsoft is pushing for user on Visio, they even have a version built .NET architech. But EM is good for building and tweaking tables especially in...
February 7, 2002 at 12:50 pm
The exam cram books are very helpfull in preparing and are not all too pricy. Also testout which has a real good system but they are up there. Also the...
February 7, 2002 at 12:45 pm
But isn't so much simpler to remember the password when it is NULL.
February 7, 2002 at 11:23 am
Make sure the database properties on the options under recovery section does not have truncate log on checkpoint marked on. If it does and a checkpoint occurrs it will upset...
February 7, 2002 at 10:14 am
Oh almost forgot, make sure the database properties on the options under recovery section does not have truncate log on checkpoint marked on. If it does and a checkpoint occurrs...
February 7, 2002 at 10:08 am
It will generate the same number of NULL rows as the number of rows in the table. Since this will return a count of records higher than 0 it will...
February 7, 2002 at 6:52 am
Ah yes but if he looks in scripts for Forcibly Shrink the Transaction Log which someone graciously posted he will find a method that works quite well in shrinking the...
February 7, 2002 at 4:52 am
Ok let me know if I got this right, when you say jobs that run automatically you are referring to the backup itself, not a job to restore. If so...
February 7, 2002 at 4:46 am
Viewing 15 posts - 7,336 through 7,350 (of 7,428 total)