Charandeep, but why is it running fine when i run it in query analyzer manually, it fails only when run in SQL Job.
Sorry guys, I was on vacation for a week.
Shehap, I tried that but no use, same error and the same code works fine when run in query analyzer. there...
The job failed again with the same error.
Thank you for the prompt reply. I made the changes but the job is still failing with the same error -
Executed as user: sss\sssss....
I need help with my index rebuild job and update_stats job. they are behavings trangely on a particular server.
The update_stats job...
I have an index rebuilding job (stored proc) that always fails in 2 instances but works fine on all other servers. That too it fails only...
There are many methods available, backup-restore, attach-detach,copy db etc.. go through BOL or msdn sites..
Hi, why don't you use SSIS, it will give you the flexibility of writing a script to map data to columns in different tables...
can anyone please help me to write the query to find the
1)size of a table.
2)no.of users logged in a database at a time.
3)the memory being...
I need to have a multivalued column in my table,
for example more than one fone. no in a single column,
i dont want more than one column for...
the work is done..!!!
I need to delete the logins who do not have any permission(database and server roles),
while doing this I found that a few logins own 'jobs'.
i m sorry that table is having 1,045976 rows,
and none of the four rows is a primary key,
they are of same datatype..there are no triggers
I have a table with four columns say a,b,c,d
with thousands of rows. I have to move the data in column 'a' to 'b'
'b' to 'c', c to d and d to a.
I need to take all the rights away from user accounts from all the servers,except those which are most used by the services.
now how to know...
i have a server with database "dts_transaction_somename",
i had to revoke users of that database, when using sp_revokedbaccess'username' it is...
how to clear transaction log in a database .
I have a server with several databases,
I need to look for users that are there in the login tables for each database but dont exist in the...
quote:Originally posted by LuisMartin
Is homework or real problem?
All in Love is Fair
Separate names with a comma.