Luis Cazares (10/31/2014)

---

I understand that...

For your own sanity, make sure you understand the difference between logins and users. And to echo what Gianluca said, always use scripts. They help you understand what...

After that, you drop the user with the DROP USER command. This won't drop the SQL login, just the database user. If the default database of the login...

I see several things here that are causing you grief. Let's look at them one by one.

You...

Wander

Eric M Russell (10/31/2014)

---

dbishop (10/30/2014)

---

Yes they are, or are browsing as part of their job. Like when I go into a Best Buy and tell them I can buy product...

Creeping

By all means, be sure to test the SP installation on a test system before installing it on production. I had SQL 2005 SP4 break my SQL Server when...

Smell

A COUNT function and a WHERE clause are the obvious choices to start with, but your need to give us something more to go on.

I'm with Phil and Chris. ...

I would start by creating a staging table to receive the data from the file. In SQL 2005, using BULK INSERT to load the table has amazing throughput, but...

alchemy_nator (10/30/2014)

---

hi, i'm new here.. i just want to ask you how to specify primary key?? for example :

T code is for 'table'

C code is for 'chair'

2014 is year of...

jonharding2204 (10/31/2014)

---

I think you should look into normalizing (splitting the strings so that each value has it's own row) the BID and BWG columns in the #MD table so that...

While I'm not really one much for Halloween, if I did dress up for a party, I think my favorite costume would have to be something like a Jedi or...

Be wary if you have any scalar functions in the procedure. I've seen it give misleading times on occasion. A way of determining the run time for the...