Lynn Pettis (12/29/2009)

---

Congrats Gus. How about sending some of that good luck my way. Can't seem to catch a break at all.

Kassondra was in a car accident Sunday...

GSquared (12/29/2009)

---

For anyone here a month or so ago, I have good news on the employment front. Starting a new job with a much better company in mid-Jan. ...

Yes. Above code returns:

(wish there was an IFCode for doing tables...)

And in the sql logs when...

GilaMonster (12/29/2009)

---

So it's not a login failure. The connection request is never reaching SQL. If it was, there would be a 'login failure' in the error log.

Is there a firewall...

GilaMonster (12/28/2009)

---

WayneS (12/28/2009)

---

GilaMonster (12/28/2009)

---

With what message? Check the error log for the reason that the login failed. Should a...

GilaMonster (12/28/2009)

---

With what message? Check the error log for the reason that the login failed. Should a non-zero state...

Glenn Dorling (12/23/2009)

---

You can do this using an ALTER TABLE command and specifying a different filegroup for the BLOB data. ALTER TABLE can also be used to move data...

sturner (12/23/2009)

---

I am not aware of a way to do this other than creating a new table having the same structure as the old one. Specify the desired file groups...

You might want to check out this article on Cross Tabs and Pivots[/url].

Alvin Ramard (12/14/2009)

---

GSquared (12/14/2009)

---

CirquedeSQLeil (12/11/2009)

---

By the time the thread hits 10,000 y'all will be flatlined, passed out drunk from all the bear being passed around - bwahahaha 10,000 shall be...

You can also utilize the sp_OA procedures with "Scripting.FileSystemObject" to create a file with whatever text in it you want.

before the with: ";with Publisher"

Update:

I used the script that drops / creates the linked server and synonyms, and pointed it to another server.

The web site worked just fine connecting to this server.

I used the...

SuperDBA-207096 (12/4/2009)

---

Barry,

Pretty good article - it could launch someone down the path of becoming a DBA. Lots more to becoming a DBA, but it's a start.

I like the idea...

Fair enough. NP.

Best of luck with your situation Gus. Definitely something not needed, especially at holiday...