Its almost 700 Gigs

YES ITS HAPPENING FROM THIS TIME.

Here the user is SYSADMIN,i guess preveliges may not be issue.

But here the query when run on Server B for other linked servers with...

Thank you,

But i dont find MSDASQL provider to check LeveZeroOnly option from serverobject-->linkedservers-->providers

here is my issue

Am Produciton DBA and supporting 150+ servers(prod,DEv,UAT).i want to know about the users and database details who will create new databases on DEV machines.i require this for...

Hi,

DDL admin doesnt work for execution of stored procedures.Please help me further on this.

regards,

praveen

Thank you for the reponse,

Here i need to grant the user to DEBUG the stored procedure,but that permission should not be SYSADMIN on sqlserver side.

regards,

praveen