Viewing 15 posts - 2,176 through 2,190 (of 2,387 total)
Run sp_helpconstraint to find out primary key constraint name and alter table to drop the constraint. You don't have to drop and recreate the table.
February 28, 2003 at 10:09 am
Can you post your restore statements for both full and differential restoration?
February 28, 2003 at 9:57 am
Generate scripts for those indexes from development server and run them in your production server.
February 28, 2003 at 9:54 am
You really don't have to restart server and the reason Agent service can't be stoped and started is because the process sqlmain.exe hung. Go to the task manager to kill...
February 28, 2003 at 9:51 am
I have seen this issue myself and from someone else few times and really don't have ideas why process sqlmain.exe hangs.
Try to recreate separtate maintenance plans.
February 28, 2003 at 8:34 am
It appears there are problems in processes sqlmaint.exe. Go to server task manager --> Processes to locate sqlmain.exe and kill them. And rerun your jobs.
Which version of SQL Server and...
February 28, 2003 at 8:03 am
Check this article. It is quite useful.
http://www.sqlservercentral.com/columnists/cmiller/cannotgeneratesspicontext.asp
February 27, 2003 at 8:58 am
select object_name(1060198827) will tell you which table is corrupt. Index ID 0 means this table itself corrupts not its indexes.
You can use DBCC Checktable ('yourtablename',REPAIR_ALLOW_DATA_LOSS) to try to repair...
February 26, 2003 at 9:20 am
Maximum Amount of Physical Memory Supported by the Standard Editions is 2GB.
February 25, 2003 at 6:16 pm
Run sp_helpsort to get the sort order from your old server and reinstall SQL Server with customization option.
February 25, 2003 at 1:30 pm
What type service account does your SQL Server run? Are you using Windows 2000 Active directory?
February 25, 2003 at 1:21 pm
'sa' can create tables under any user's name provided the user's name is exist in the database.
February 25, 2003 at 1:02 pm
Can you check whether connections over named pipes is succeed and see if there are name resolution issues?
February 25, 2003 at 12:52 pm
Accessing OSS.table_name means you have already created a table that is owned by owner 'OSS'. You must have a user named 'OSS' in database OSS. If you don't have it,...
February 25, 2003 at 12:15 pm
Each instance depends on its own resources and one instance fails doesn't affect the rest instances. If two or more instances share same physical resources such as same disks, the...
February 25, 2003 at 9:45 am
Viewing 15 posts - 2,176 through 2,190 (of 2,387 total)