Stefan Krzywicki (7/27/2011)

---

Gianluca Sartori (7/27/2011)

---

My dear friends, I finally have the definitive answer to the question that originated this thread.

NO!

They're not getting worse! This is what they kept getting until...

Sqlsavy (7/27/2011)

---

Thank you all.

Well I ran the upgrade adviser on SQL 2000 server and books online says

In earlier versions of SQL Server, system object and system type names are matched...

Tom.Thomson (7/27/2011)

---

I'm glad the MS...

Michael Poppers (7/27/2011)

---

Judging from some of the sarcastic back&forth in the, so far, four pages...

Bill Beadenkopf (7/27/2011)

---

I already was a local admin, but that thought got me to trying an osql command using the windows login.

OSQL -E -S "Servername" -d master -Q "EXEC sp_defaultdb...

Here's how I've setup my jobs to get the full output and how you can see the output once it's captured.

From the GUI

Read the output from a query :

SELECT *...

Don't do anything (especially do NOT do checkdb with allow dataloss. I'm calling in our best expert on the subject.

In the mean time, do you have a valid backup...

HTH. Come back if you have specific issues not covered by the white paper or google.

I don't mind helping, but doing your...

cengland0 (7/27/2011)

---

bitbucket-25253 (7/27/2011)

---

[Rant]

Now for your assertion that I was being tricky/sneaky based on

You know the author of the question is being tricky/sneaky if the majority of the people...

Please start a new thread. This one has been revived 4 times already and I don't think there's much more to add to it at this point.

bitbucket-25253 (7/27/2011)

---

cengland0 (7/27/2011)

---

There's a difference between a hard question and a tricky one that is attempting to have as many...

BCP IN.

When do you plan to read the article I sent you which contains all the info and exemples you can ever need?

Go to the server's machine. Add yourself to the local admins. Login with windows authentication and then change the default db to the other logins. I've read...

CELKO (7/27/2011)

---

Get a copy of SQL PROGRAMMING STYLE. I did research on this topic for two years at AIRMICS and used to write a column of software engineering in the...

Here's a sample of what I have in production :

exec master..xp_cmdshell 'bcp "SELECT CHAR(34) + GL + CHAR(34), CHAR(34) + dtMatrix.Departement + CHAR(34), CHAR(34) + dtMatrix.Etablissement + CHAR(34), CASE...