Viewing 15 posts - 106 through 120 (of 134 total)
You might ned to check the script if it has create FK statement before you run the script. It might just have the drop statement only.
April 25, 2003 at 3:47 pm
Correct me if i am wrong. To do attach dettach the database should not be operational i mean should not be used.
April 25, 2003 at 3:43 pm
try to backup the file i.e database or log and then run shrinkfile. Try it couple of time as it might not succeed the very 1st time.
April 25, 2003 at 3:36 pm
I got the answer for thsi issue and it been resolved :
http://support.microsoft.com/default.aspx?scid=kb;en-us;q196657
We tested the workaround of unloading and loading the sqlctr.ini file on the test cluster and in...
April 25, 2003 at 3:27 pm
We had a similar problem and as said by Antares, reindexing and update stats worked.
April 24, 2003 at 1:25 pm
You can use microsoft provided blocker script within a .bat file. Create a job with the .bat file and schedule it to run every min. This proc gives quite some...
April 24, 2003 at 1:22 pm
Most of the valid causes have been penciled down. Donno if the queries written use this OPTION (MAXDOP 1), which forces the query to use one cpu only.
April 24, 2003 at 12:39 pm
Its pretty messy when you have large db's that span over quite a few filegroups. Like said biggest tables in seperate filegroups, but to what you said they are categorized...
April 24, 2003 at 12:21 pm
Both the options have their own pros and cons. It all depends on what you recovery plan is and how much of hard drive space you have.
1. Append to media:
-...
April 24, 2003 at 12:15 pm
What did you select when connecting to both source and destination servers. If you used NT authentication, that might be an issue, else with sql login it should work fine.
...
April 24, 2003 at 10:03 am
Was the table on which the trigger is modified or table name changed. Though it might sound stupid, but check the column names within the trigger code it refres to...
April 24, 2003 at 10:00 am
EXCEPTION_ACCESS_VIOLATION may occur due to various reasons. Its on a case to case basis. As said by Allen, its a good idea, but it would be better if you could...
April 21, 2003 at 2:37 pm
It happens sometimes. I dno't know why, but i know a trun around for this. Right click and select View> details. Then again right click and select View>taskpad...tjis time it...
April 21, 2003 at 2:08 pm
you can assign DDL admin is sql 7.o as well. Thats good practice to avoid future problems.
April 17, 2003 at 12:44 pm
Though it might sound silly..but what i did once on such a situation was :
Asked the client to to connect through Access database and provide him with the login informatiom...
April 17, 2003 at 12:35 pm
Viewing 15 posts - 106 through 120 (of 134 total)