wanted to set up a logshipping between MS-SQL-Server 2005 to a box running under MS-SQL-Server 2000. any special inputs for this...? may be any link...
when ever i tried to shrink my tempdb data(live production server) file which is 8.5 gb size ,i'm getting following error: File ID 1 of database ID...
any script / link where i can get info for writting a stored procedure to alert when db is 85% full. requirement is the sp should take the % full...
I m getting a below error in my replication its a transacional replication ... "Error at parameter 34 during datastream processing of parameterized...
wanted a sql job to be scheduled which will alert me when my file groups in any of my database are 85% full (% full should be as a parameter),...
when i'm trying to use sp_helpdb 'mydatabase' its throwing the below error... any input why this error is and what can be done to getrid off this....
I'm trying to put the SQL-ErrorLog in to a table.the same code is working fine in SQLServer2000 where as in 2005 its throwing error. any body can...
i'm in the process of migrating my sqlbox from 2000 to 2005, to make it easier and down time less i've set up a new 2005 box. Can any one tell me / I...
I'm new to sql server 2000.I need a help for a report I have a table in below format InvoiceID Item Name Total Year Month...
How can i found who enabled the job in sql server 2000? Pls help me in this issue...
when i execute below query i got the error message like "syntax error on "queryout"..." query:bcp "select * from msdb..sysjobs" queryout...
how to findout executing jobs and duration in sql server 2000
Wanted to set us a clustering enviornment..Any Link i can refer as a step by step method to to make such enviornemnt... ? ie from the scratch.....
i want to know the subscriptions status in a server i.e.if some one deleted the subscription then i want to know the deleted subscription details,is...
Is there any example by which i can see dead lock situation? with proper/exact steps? Example - Blocking situation can be reproduced by opening 2...
I have some vb script code ex: strcomputer="." set OFSO=createobject("scripting.filesystemobject") outputfile="D:foldersize.txt" set...
could u pls any one tell me how to reproduce a dead lock in sql server 2000
i want to know replication status through query analyser could u pls any one help me on this issue?
i have one question i created two procedure create procedure test2 as select name from sysobjects create procedure test1(@select text) as set...
My requirement is to know the recent changes of tables,sp's,views so on.. in a database with time and date. is there any way to know this.pls help me...
Separate names with a comma.
