Can't have two variables with the same name in the same scope.

A clustered index on a GUID is generally a bad idea, because it forces table fragmentation. Clustered indexes on tables with lots of inserts should generally be something sequential,...

The difference is what is displayed when you look at the database properties. As far as who has what access to the database, there's no difference.

The simplest thing to do with something like that is provide a simple interface, just a few fields and a place for notes, and log it into a simple database....

Not entirely sure what you mean by "other networks". Most likely, what you need to do is use the IP address of the computer with the database on it....

Jason Shadonix (1/14/2009)

---

Yeah apparently a different person. Which is why I pointed out the user name. Guys like that need to be slapped, but I really want to...

Ellis RemoteDBA (1/14/2009)

---

Don't know what its like in the US but in the UK its not just 'bad' businesses suffering. In fact if you business is managing to keep its...

I'm used to seeing that particular error when the file is already open, usually on my own screen, right behind Management Studio. I'm assuming that's not the case here.

Does...

Jeff Moden (1/13/2009)

---

GSquared (1/13/2009)

---

So, two mistakes, neither of which would have mattered all that much by itself, but together made a problem that mattered, which could have been prevented...

I tend to agree with you. Too many companies that never produced anything of any value to anyone except their stockholders, and owners of stock options.

Forgetting to highlight the Where clause is just one example.

Carelessness can take a large number of forms. After all, there are an infinite number of ways to do something...

And I'm so used to 2005 these days that it didn't occur to me to mention that was what I was talking about. Glad you figured it out.

Michael Earl (1/13/2009)

---

I particularly like his comment:

[font="Comic Sans MS"]Multi datasets is one of the powerful tools in Reporting Services. The answer is in knowing the product, not 'don't...

You can't schema-bind a remote table. Schema binding doesn't work that way, since the local server can't force the remote server to hold onto the schema definition. Not...

My reply is a bit less polite.