Viewing 15 posts - 2,266 through 2,280 (of 2,387 total)
SELECT OBJECTPROPERTY(OBJECT_ID('YourTableName'),'TableHasIdentity') to check whether the table has identity column.
SELECT COLUMNPROPERTY( OBJECT_ID('YourTableName'),'YourColName','IsIdentity') to check column 'YourColName' is a identity column.
January 21, 2003 at 11:55 am
You have to restore it with norecovery again.
January 16, 2003 at 7:16 am
Check maintenance plan history to see any errors reported?
January 15, 2003 at 2:33 pm
You need permission to run sp_grantdbaccess to grant the login you created to access database.
Only members of the sysadmin fixed server role, the db_accessadmin and db_owner fixed database roles can...
January 15, 2003 at 1:53 pm
Target server memory is the total amount of dynamic memory the server is willing to consume and total server memory is the total amount of dynamic memory the server is...
January 15, 2003 at 1:34 pm
It is very generic error message id. You have to refer to the article to try to resolve it.
In terms SQL linked server setup, you can refer to BOL.
...
January 15, 2003 at 1:28 pm
select a.database_name, b.physical_device_name from backupset a, backupmediafamily b
where a.media_set_id = b.media_set_id
January 15, 2003 at 10:13 am
sp_change_user_login 'report' is used to lists the users, and their corresponding security identifiers (SID), that are in the current database, not linked to any login.
If your help desk create...
January 15, 2003 at 9:44 am
Use performance monitor to monitor following counters.
memory : pages/sec
processor : %processor time
physical disk : ave disk queue length
sql server : memory manager : total server memory
The issue may be related...
January 15, 2003 at 9:11 am
Read KB article 280106 if you are trying to setup and query linked Oracle database. It may help.
http://support.microsoft.com/default.aspx?scid=kb;en-us;280106
January 15, 2003 at 8:44 am
Can you post the select statement?
January 15, 2003 at 8:26 am
How much free space do you have in DEV server? How large the transaction log file and How many data files in Production server.
You may shrink the tracsation log file...
January 15, 2003 at 8:17 am
What do you mean too much work on the network?
January 14, 2003 at 1:37 pm
I experenced same issue before so I wnet to the server task manager to see whether sqlmaint.exe is running and killed from there.
Check your maintenance history to see any...
January 14, 2003 at 9:39 am
Viewing 15 posts - 2,266 through 2,280 (of 2,387 total)