Yes for the service account it has the...

I have been looking at the memory usage at the time it goes wrong and sql is using 13600mb with 13600mb allocated. This is standard and the memory usage...

The blocking only occures after the procedure cache drops. Fixing the blocking issue...

Nicholas Cain (12/31/2008)

---

Andrew Barton (12/31/2008)

---

Hi, thanks for the swift response, the min server memory is 0 and the max is 2147483647 so should be using dynamic memory management. ...

Hi Jason,

No other apps are running on this node just SQL.

Hi, thanks for the swift response, the min server memory is 0 and the max is 2147483647 so should be using dynamic memory management. This box is a...

It was the registration key.  Our ops team hadn't registered winzip on the server.  It is now working correctly and  I now need...

There are companies that specialize in restoring data from damaged disk drives but it isn't cheap.  If all else fails this might be an option for them.

Another option is to have an output parameter in you stored procedure that is data type cursor and then pass this to a second cursor in the calling stored procedure...

I think that by default  Builtin\Administrators can see the directory.  If the user you wish to view the report is not an administrator, you will need to add either the...

I already looked at the dates and tried them as datetime also tried them as varchar.  Added times to the dates but it always gives the same execution plan.  I...

You can audit logins in SQL server.  You have the option of auditing None, Failure, Success or ALL.  Have a look in BOL as it gives details.  The next level...

When you want to restore the master database you have to set sql server in single user mode using a command line and the following switches.

sqlservr.exe -c -m

Look...

I have spoken to our network guys and they can't shed any light on it either.  The workgroup is a windows 2000 advanced server and the SQL server is on...

Check out the following site. This has some nice code examples for doing loops in DTS packages for importing files.

http://www.sqldts.com

Andrew