Thank you so much for your replies. As of now, we are just discussing the possibilities and availability of the tools/costs etc so I'm not able to look out in...

Thanks. I have asked to check the code again but I'm pretty sure it will come back that its not the code. If the select statement is only called once...

I see several temp db locks request-mode SCH-M.. Can the locks in temp db affect other databases?

Thanks

Thanks... I get this

Msg 3241, Level 16, State 1, Line 1

The media family on device 'C:\Backup\db1_bkup.bak' is incorrectly formed. SQL Server cannot process this media family.

Msg 3013, Level 16, State...

Hi Friends,

I''m not able to figure out what the problem is.. ODBC/OSQL doesn't work either.. I checked sql server does allow remote connections.. Not really sure what is missing.. I'm...

I get this:

Cannot connect to server.

A network related or instance-specific error occurred while establishing a connection to SQL Server.The server was not found or accessible....

I'm able to...

I'm still not able to connect from SSMS 2008 to 2012 database. Not sure where/what to check?

Please help..thanks a lot

thanks I got it fixed now

OH really? I thought its in MB?

Thanks. I'm confused with this one.. I set the maximum server memory(in MB): 2147483647 on the database server. But i the task manager sqlservr.exe is using 3349316K memory. So logically...

Thanks. Will this run every 4 seconds from the time the stored procedure is called in the program? Also the results from the select should go into xls file,...

Hi friends,

We have a scheduled job set to run every 4 seconds from the time the job is enabled. The below sql in the job runs...

Hi Friends,

Thanks for all the help so far.. Is there a way to schedule the job every 20 seconds? I see the default starts from 1 minute and up.....

Thanks a lot. Using tokens worked

Hi Jeremy,

I do not want to append it the existing file either.. We would want a new seperate file created when the job runs every 5 minutes... not sure...