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...
satya - 1105,9002 & 90004 these are the space related errors/aslrts.. before reaching them we can have a job in place which can be scheduled, purpose...
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...
did that but the outputfile is full of jumble characters... <br /><br /><br />eg - <br />Last transaction timestamp: xxxxxxxx<br />Transaction seqno:...
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've already tried couple of times since it didn't work (notsure why)did put in forum...by changing the table schema did it work for you...?
the reason i m capturing the errorlog in to a table is from errorlog i capture the error information -> filter it out as per my need the one i...
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...
satya , thats good about login transfer part, what about script for jobs transfer ie 2nd part. Any link / script that will take care of generating...
hey satya thanks for the reply - i did go through couple of articles wrt migration etc but they are quite lengthy... ie kind of not precise.. is...
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.....
Separate names with a comma.
