Viewing 15 posts - 16 through 30 (of 33 total)
Got it right as I knew that you could not truncate a table with FK Reference. However, the explanation for why it was the error is that the table does...
October 21, 2010 at 1:57 am
Please explain why the answer is False,
You can save the Visual Cue against the Registered server so when you connect it will be in the color you have defined.
I would...
October 15, 2010 at 12:24 am
The answer to this question is based on what the requirements are for your server.
Is it a server that needs to be able to cope with lots of concurrent users...
October 13, 2010 at 1:54 am
You not able to get tail tran log backup?
No access to the DB?
October 11, 2010 at 1:40 am
Like the many others I have select the 3 options and not selected Column references can pull data from multiple rows. From what I can tell I was right like...
September 30, 2010 at 2:55 am
Silly point but have you got plenty of space to restore the DB? Appears it is processing so far and then stopping. Don't forget the size of DB from 2000...
September 17, 2010 at 1:52 am
It should automatically detect the increased size.
SQL Server main concern is when there is no space so increasing space based on your set up should be easy enough and...
September 17, 2010 at 1:46 am
As per previous post what I would suggest is that you have a staging DB on Prod and then import your data to the relevant tables on your Production DB....
September 17, 2010 at 1:38 am
Is it SAN Storage you are using or actual physical drives?
What I have found is that when it is SAN Storage you need to make sure that the drives are...
September 17, 2010 at 1:35 am
Just be careful wih the point in time recovery the fact that you dropped the table may not have stopped people entering data into other tables in the DB so...
September 16, 2010 at 2:59 am
As with the suggestions before not sure why you want the ID to be provided to user beforehand. You could be checking over and over again. Better way would too...
September 15, 2010 at 2:03 am
Are you upgrading the underlying OS?
eg Are you going to Windows Server 2008.
July 26, 2010 at 4:48 am
Got a job that rebuilds the indexes on a daily basis and auto stats run throughout the day.
We have been provide with Disk using SAN storage so do not really...
July 23, 2010 at 1:54 am
Indexes are getting fragmented due to the data constantly being inserted and removed.
July 22, 2010 at 4:08 am
As per the numerous people that have quoted you can set the DB to READ ONLY for model.
The others are not allowed as it is a system DB.
So in short...
July 15, 2010 at 4:54 am
Viewing 15 posts - 16 through 30 (of 33 total)