In the future pleas write your question. In this case you had an error in your code that is very easy to spot, so I think that I can...

There are 2 main reasons that it is not recommended. The first reason that each time that you modify data, the server has to write the modification on...

How are you trying to shrink the file? Can you try to issue direct dbcc shrinkfile command from SSMS or QA and see what happened?

Adi

Since Cherie asked about sysperfinfo table, my guess is that Cherie is using SQL Server 2000. You can grant view...

If you want a user to be able to use sysperfinfo table, you can do one of the fallowing:

1) Add the login as a user to master database and grant...

There are 2 ways that I can think about:

The first way is simply to use profiler and catch only the login and logout events. Then you can insert...

I don’t know what causes this behavior, but I don’t think that it has something to do with the QUOTED IDENTIFIER set option. The reason I don’t think...

You can use a table and insert the date into the table. The job can query your table in order to get the correct date. I realize that...