If your statements run fine taken one at a time, the problem is in the UNION. You have to ensure that the data type is the same for each column...

The VB project makes much more than simply adding the audit call in the procedures, but it implements some business logic tied to an application we wrote that relies on...

I had to face the same problem some time ago. I tried many solutions, but I couldn't find anything better than insert some logging statements in every procedure. Of course...

Coyote Blue (8/7/2008)

---

Mike Menser (4/4/2008)

---

I was reading a database magazine this morning and it had an interesting question. They were going to take a poll to see which group of...

Really strange behavior!

You could write a DDL trigger to track the procedure drop.

Well, theorically speaking it's a violation of normal form, but practically speaking I don't see anything nasty. The main question you have to ask yourself is: "will these two verification...

Definitely SEQUEL!!!

Here in Italy you would have to say "Esse Qu Elle"!!!!! Toooooo Long!

You could also try to set the IP address and the port on which SQLServer listens manually, so that SQLBrowser is not involded. This worked for me in some cases.

Regards

Gianluca

It looks like a network error on the web server rather than a problem in SQLServer itself.

It could be useful to sniff the network packets between the web server and...

Thanks Italy! 😀

I'm sorry, but I don't understand what you have to do.

Which data you have to retrieve from Table1?

The join condition is

Data1 = 1 OR Data2 = 1 OR...

I found another one from Microsoft:

http://support.microsoft.com/default.aspx?scid=kb;en-us;194975

The best design to accomplish tasks always depends on what you have to do: I had to face situations when storing the file directly in the database was the only...

Detach/attach worked for me when I had to do the same.

Regards

Gianluca

Basically you need two things to do that:

1. A table to store your data. The table must have a column of the appropriate type (varbinary(n) or varbinary(MAX))

2. A piece of...