Viewing 15 posts - 136 through 150 (of 219 total)
I guess there is no direct way to drop the identity. You have to remove the PK/FK relation and create a dummy table with the same definition as your identity...
July 2, 2003 at 2:22 pm
Check your optimizer changes the FILLFACTOR of the indexes, if yes uncheck it. I can't think any of other possibilities. Why don’t you launch a trace flag and see is...
July 2, 2003 at 12:06 pm
I would suggest going 2K straight ahead. You have very good futures that are lacking in SQL 7.0. For Example if your user do bulk inserts he must be DBO....
July 2, 2003 at 11:55 am
What kind of problem you mean? Are you talking about the Data corruption? Then no. For that matter it won't cause any problem. Take a backup and move your objects...
July 2, 2003 at 8:31 am
Missing one step between
-- Put the DB in Offline mode
-- Detach the database using sp_detach_db
-- Move the OS files to the new location
-- Attach the db...
July 1, 2003 at 3:57 pm
I guess, If your default file group is full, it try to expand the files depends on your auto grow property rather using other file group because its not the...
July 1, 2003 at 2:15 pm
Yes that should work fine. There is a bug with this, if you are using multi protocol you must remove them and add it back.
July 1, 2003 at 2:02 pm
July 1, 2003 at 1:39 pm
Change your client network protocol to TCP/IP to Names pipes or vice versa. Also if you are connecting with a standard id make sure your server security is configured as...
July 1, 2003 at 1:35 pm
I would just restore the user databases and will fix the logins and depends on scheduled tasks i will restore the msdb
July 1, 2003 at 1:30 pm
SPID from 1 to 6 are system process. Handler, Lock monitor, Log writer, Lazy writer and Check point
July 1, 2003 at 11:27 am
Is there any bulk inserts before/After your maintenance? Bulk inserts cause log and datafile growth
July 1, 2003 at 10:36 am
July 1, 2003 at 10:05 am
Chances are less likely to figure it out what exactly the users running against the tables, if you don't have the Profiler turned on. What you can do is to...
July 1, 2003 at 10:01 am
If you want to move the table to new file group use the following one
Go to the Design mode of the table in the Enterprise manager and change the table...
July 1, 2003 at 9:51 am
Viewing 15 posts - 136 through 150 (of 219 total)