Or, Just drag the Columns node from the object browser into the Query editor.

Hello,

My foray into extended properties at the database-level (SQL2005) was stopped short when I found that only users with elevated rights, such as Control or View Definition, could read...

When I was an Operations...

My story sounds like Trey Staker's: early in my career I work a lot, both because the project 'needed' it, and because I felt I was in a learning curve...

Thanks for the article, Peter. And thanks for the technique.

It's unfortunate that these kinds of work-arounds are needed: it just shows how out-of-touch microsoft is becoming. For years they've...

Hello Forum Member,

Please excuse...

Hey Steve;

Thanks for the code. I tweaked it a little for my situation, added parameter markers, and stuck in my templates...

Pretty handy!

USE <databasename, sysname, >;

SET NOCOUNT ON

DECLARE

@table_name...

I'm sorry i cannot test (my crappy Vista machine isn't allowing OPENROWSET today...) but, don't you need...

Hello Phil,

Interesting article, especially because I, too, had cracked open my ODBC 2 book (QUE 1995) a few weeks ago: been having an intermittant problem connecting an SQL2005 Query...

Hi WayneS,

Thanks for posting your wrapper: I'll keep it on file.

I've got a couple too, but mostly I just need to correct a Recipient address and resend, so...

WayneS (3/11/2009)

---

I have an email that sql server says was sent okay, but the recipient (me) never received.

How do you have db mail resend an email it thinks was sent...

Hi Ghanta,

If you want to continue on after the error, you'll need to do your error handling inside the cursor.

Here's your code, rewritten a little (it's just an example,...

Hi ekonagu,

Acknowledged. The point was that in trying to get ACE 12.0 to work, my...

There is an interesting post at :

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926&whichpage=11

by Peso:

If you have some error and you don't understand why, try using MSDASQL provider temporarily.

SELECT * FROM OPENROWSET('MSDASQL', 'Driver={Microsoft Excel Driver (*.xls)};DBQ=\\seludt2135\c$\documents and...

We've been backing up to the 'cloud' for a few years now, but the size of our databases are not so large as to cause a problem, I guess.

Or,...