A lot of the time, the bulk insert scripts that people post are missing chunks of info because of certain string combo's get filtered automatically. It is easier for...

I've sent you a pm on this one.

Sorry, what I meant was you aren't defining your rowterminator. Use a \ n (remove space between slash and n)

Two things.

1. Your table create is referencing a different table from your insert.

2. You don't define a row terminator. I created a file and defined the row...

I'm not really asking for perf help...but more of an opinion on sacrificing read/writes versus execution time. I have worked in various shops where one will focus mainly on...

My apologies...when I say move...I mean they moved the cabinet from one room to another.

Figure it out. Linked server authentication. It should have been obvious to me...but it's those little things that tend to bite you in the rear. Thanks for...

Lynn:

I have an experiment for you. I want you to create two databases on your dev server. Create the first one through your local EM to your dev...

Lynn Pettis (3/2/2009)

---

Looking at BOL, NULL is returned on error or if a caller does not have permission to view the object.

That makes permissions another area to consider, depending on...

Now that I think about it, I wonder if it has something to do with the way we create our prod db's. We use a central db that has...

Usually there is a ReportServer db listed in your available db's on your sql server. But, you can also check your IIS for the ReportServer site listing. You...

My apologies for the dual posting. I had been reading a post in the 2005 area and thought I had clicked back into the 2000 area. When I...

The tools I find I use everyday are the Red Gate Suite of tools as well a few Idera tools.  The combonation of these two suites really help to keep...