Viewing 15 posts - 1,261 through 1,275 (of 1,335 total)
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.
February 1, 2007 at 6:14 am
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...
February 1, 2007 at 6:11 am
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...
February 1, 2007 at 6:06 am
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...
February 1, 2007 at 6:02 am
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...
February 1, 2007 at 5:15 am
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...
January 31, 2007 at 5:48 am
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....
January 31, 2007 at 5:37 am
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...
January 30, 2007 at 8:10 am
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...
January 30, 2007 at 7:59 am
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...
January 30, 2007 at 7:42 am
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.
January 30, 2007 at 7:26 am
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()...
January 30, 2007 at 7:22 am
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...
January 30, 2007 at 7:13 am
detach your database and then move ur files to ur new loaction and then again attach ur database.
January 30, 2007 at 7:06 am
detach ur database copy the file to ur new loaction and then attach ur database to the sql server. this would do for u.
January 29, 2007 at 8:13 am
Viewing 15 posts - 1,261 through 1,275 (of 1,335 total)