How to connect sql server with instance name, if we don't know the port number. E.G:- If on one NT box we have 3 instance and i want to connect to...
SQL Server 2000 provides the ability to stripe backups across multiple tapes or disk devices. Does any one know the syntax for the same? Rajeev...
How to restart replication from SQL analyzer. Rajeev Kumar Srivastava --ALWAYS BE POSITIVE!--
I have SQL server 7.0 transaction replication . Following error i was getting on distribution agent log:- The agent is suspect. No response within...
I got below error in sql server 7.0 error log:- Automatic checkpointing is disabled in database 'master' because the log is out of space. It will...
I am using SQL Server 7.0 with sp3. One strange thing is happening when I see one of the job which is showing as enable as "Yes", But when I right...
Few days back my Maintenance plan was getting hang when it take#%92s backup for one database, so we removed that database from maintenance plan and...
Error: 17832, Severity: 18, State: 8 "ods Connection opened but invalid login packet(s) sent. Connection closed." Microsoft KB Link :-...
I have created normal user without sysadmin role.Previously this user were using xp_cmdshell to check for file existence with sysadmin role.So how...
In maintenance plan history for "Delete old text report" it show status as failed. Where as in properties it shows as 1 file deleted.Then why it show...
I have a database backup from live server and I want to restore to development server. In Live DBName:ABC Logical Name=ABC_Data1...
I am using SQL Server 7.0 on NT Cluster . Is there anything that needs to be done to the cluster before the master database is restored or is it...
How to find accurate database used size This is the output of "sp_spaceused" Db Name |Db_size |unallocated space ABC|34700.00 MB |-47572.81...
I am using sql server 7.0 sp3. i got this error in maintenance plan. [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 913: [Microsoft][ODBC SQL...
I have a Maintenance plan in sql 7.0 which take backup.I found strange thing there ,In job it show error But it is not showing an error in...
Hi I got this error in my log, can anyone tell me what is that. net_readdata: Process 2824 generated fatal exception c0000005...
Hi i have created one Maintainence plan which do backup. here is the Error ...... [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202:...
what is the use of "xstatus" column in sysxlogin system table. can we lock sql login through any sp.i know that we can do it by xstatus column but i...
Can we use TABLERESULTS with all the DBCC Command? If not why is it so. Rajeev Kumar Srivastava --ALWAYS BE POSITIVE!--
i have a sp which have many insert statement,how to handle FOREIGN KEY conflict Here is Code ******************************************* Begin Tran...
Separate names with a comma.
