is there any script or best way to find the tables and check if there are any deny permissions if not i want the script to run that database which...

I am using litespeed generated script from a sql job and file is located on a different server for which i am using a network path to read the file...

I tried all the ways above but could not start sql server. I just want to start sql server and point tempdb to an existing drive.

i could not start sql server from cmd line without having tempdb.

a user has created so many temp tables in 22 sessions which causing disk outage on the drive where tempdb is located, how do i find size of each temp...

how can i comapre group memeberships, is there any script?

both are done.

yes i tried from ssms using the service account, it gives me only master and temp db.

yes all of the database are partioned on date which means each month will have one file. Could you help me more on how i can backup just partiion and...

we have about 20 databases to load which are of identical structure and takes for more than a week to finish.

Like you said if i am loading only 1 months...

what do you mean by restore the dev database with just new data.

Dev dataabse is never restored unless there is a problem, which means we keep appending data to...

Here is the real scenario, Let me know the best possible ways to do.

I do insert data into a dev database (which is a exact copy of production) every month...

How can i script out database names to check if deny permission ofr id's X and Y on tables A,B,c are existing if not run the script i have on...

In my case tables are not created when the database is created so i have to check if there is any database created every day and ru nthe script.

how can i find the temp tables created by a user and drop the one i need?