ok that sounds easy but how. When I go to add a network service how do I find it? Since we are looking at a domain there is...

i did not explain myself well. Sorry. I am just going to store the cookie crumb in a temp table. I can not use sp's and also...

Not sure if this will help but have you tried to wrap the directory in Char(39) or Char(34). You can also test out your command to make sure it...

It is just a one time script. I am surprised there is no way to un declare it and declare it again. Thanks

Are you using Excel 2008? If so there is a table function. Where you can make your xlsx into a table. Then you can in bed the...

Now I am tossed up. I agree on the biggest point of the enforced FK. I hate un-enforcing FK's. I will do it the right way.....Thanks

It is a notes table so I am not sure unrelated is valid. So for your example If you called the table Customer notes and had contacts, customers, and...

So if I define a table with a guid and a nvarchar(max) there is no space difference between one table and 3? That does not make sense to me....

Hmmm...

I think I am going to do a separate table. I do not feel this field is going to be selected often and I just got further in the...

Thanks for the post. We tried most of those techniques. I think it is an issue with the registry. Those are better threads then the ones I...

We are currently using TFS also for source control. When I look at the SQL2K5 templates I see all the stuff I am used to seeing for check in's...

I thought the same thing. I can use SQL compare and have a bit. That still does not take care of the real issue. What is the...

if you are using .xls and under destination for your dataflow "Excel Destination" it should work. If you are trying to open the excel file on the server yes...

That would be a great feature if I could turn something like that on. Strict_Check. I hope that SPXX will have something like that.

Thanks for the help. I am not sure how the cursor would work since I am dealing with stored procedures. There can be many calls to different tables...