u can use sp_readerrorlog to read any of ur error log files. just google this and u will find a plenty of details abut this procedure.

to change any configuration with the log shipping all the servers installed in the processes must be registered. thats why u get the error saying that the server must be...

you can find the info in sysjobhistroy table itself it has a column called status which either has a value of 0 for failed and a value of 1 for successfull...

its surely a permission issue. i hope after rebuilding the server u have not added the windows user to the sql server logins. r u getting this error only with...

This was taken from Books Online in SQL Server 2005. Just have a read on this hope this mite help u.

A transaction is a sequence of operations performed as a...

i have seen this error when a  windows user account is locked out and the user is trying to connect to the sql server. once the account is unlocked he/she will...

I have found a way out for this but it looks little complicated to do it. this is as follows.

1. create a table that has all columns for your need

2....

do u want to track only those 2 users or u want to track all the user connections. if so u can enable audit to track all user connections. if...

yes u can't detach and attach ur system databases. i dint read that the user wants to move the system databases too.

u can do the following

1. stop the sql...

what is the account that your sql server runs. i hope it should be some permission issue for that user using winodws account instead of sql account as sql account...

try using the date in this format YYYYMMDD there is already a thread going in this forum with the same issue and lot of users are answering the same.

is it mandatory for you to use the @trackingcode variable. just remove that from ur code and use this it will surely work.

  update tblserial set ctime = getdate()...

sql server does not have something like package in oracle. but u can nest your stored procedures upto a limit if 32 procedures called within a single procedure. u have...

detach your database and then move ur files to ur new loaction and then again attach ur database.

detach ur database copy the file to ur new loaction and then attach ur database to the sql server. this would do for u.