Check if you passed NULL to the procedure.

Adi

As you already wrote the mirrored database can not be accessed at all (not for read and not for write). A snapshot database can be used for read operations...

You have to put your parameter in side parentheses (e.g. SELECT TOP (@ReturnNumber ) feProduct.ProductID, etc etc etc)

Adi

As far as I know with triggers you can not rollback part of the trigger. You have rollback the whole trigger or commit the whole of the trigger. ...

Does the user has a login defined in the SQL Server? If he doesn't your have to create one using create login statement.

Adi

I think that the answer “You cannot set IDENTITY_INSERT on for more than one table in a database” should be changed to You cannot set IDENTITY_INSERT on for more...

If you need it for a job, then you can also use a regular select query and output the results to a file. Check out the advance tab in...

First I have to admit that I’m shooting in the dark because I haven’t seen SQL Server 6.5 for many years. After you upgrade the server to SQL Server...

You have 2 messages. The first message is a warning which means that you have some aggregation function, but the server encountered null value. Since null is an...

do (1/22/2009)

---

Thanks. I'll give that a go. Also, is there any way that another step could be added into the job to delete any of the log file backups that...

Not that I think that turrasque’s way is wrong, but it is an opportunity to write about a little known feature that is called agent tokens. This feature can...

One way of getting your results is by running the fallowing query:

select name from table1

Union all

select name from table2

I have to admit that I there is a good...

I’m sorry but something here seems strange. In your first post you wrote about a table that when you run an insert statement into it and you use getdate(),...

There is no need to do a backup because this is the TempDB. Unlike the rest of the databases, each time that the server is started, it creates the...

Are there any triggers on the table?

Adi