Hi Chris

Are you inserting the result on any table, if so then check the table structure, one more thing to...

Hi

Hope this link below helps

http://www.mssqltips.com/tip.asp?tip=1112

http://msdn.microsoft.com/en-us/library/ms179316.aspx

Cheers

🙂

Hi

Woudn't it be more easy when you speak to you administrator to ask you to provide some rights as linked server 🙂

try DDL Triggers

lets know how long does your backup take, just interested in timings

I am not sure about the problem, but can this be done by searching all folders using windows search if you know the filename 🙂

ops forget to look on Forum 😀

I am having a 164 GB Database which is been copied across network to a storage location, it takes 6 hours for me to complete the backup, i dint even...

Hi Paul

It depends, are u backing to a network folder? is the machine been used by any other process??

check what transcations are going on, Log size grows when there is a huge transcation going on, you can use profiler to check what is happening on background

Hi Naveen

bluntly, dataset is the connection to SQL server that holds ur SP, once that is been created, you can see the...

you can use msdb.dbo.sp_send_DBMail ro send mail from your SP, what exactly is that you want to do, if you can explain a bit more then we can give more...

if this a adhoc Query ones then cast as said above will do , if you want to change the structure of the table, yes you can

Conceal this extended SP into a SP, the call that SP from a linked server, this can be used with the machine where we have SQL installed 🙂

This view cant do update :D, it is read only 🙂