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...
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...
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 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...
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...
if u have been given an employee table with empid, name and salary , the salary varies from $1000 to $ 20000, what should be the query to find...
If u have been given a table with fields 'empID(primary key)' ,'emp_name' ,'emp_state' ,'emp_salary', and u have to find the the employee...
Separate names with a comma.