chrisph (9/25/2012)

---

I've tried several different ways to run the script example you showed and I constantly get a syntax error of "invalid object name" in regards to the database. schema.table....

I showed you the basics, but it's up to you...

the definition i created was based on sys.tables for SQL 2005;

create your model yourself, and script out the table, then use that for your global table definition:

select db_name()as db,*

into...

the definition of everything available inside the DDL events are here; the vary based ont he event itself.

http://schemas.microsoft.com/sqlserver/2006/11/eventdata/

looking it over, i think you want the field TargetObjectName from the eventdata:

<xs:complexType...

you need to create a global temp table, and instead of selecting , insert into the global temp table.

CREATE TABLE ##TMP (

[DB] ...

well, bcp is actually a command line...

well, building the command is just a join of sys.tables and sys.columns...so the question is how do you know which "certain columns" are to be exported?

if you know the names,...

unless you consider dbmail creating an attachment as a file for an email, SQL server itself, doesn't have any native ways to write files to disk that I can think...

are procedures banned from this, ie you can only use a select?

you could do it in a single characet then:

CREATE PROC z

AS

SELECT cos('')

GO

z

also, I believe deleted data does not release space until the clustered index is rebuilt...so if you had a 100 meg table, and deleted half of it, it will still...

this is a great reference that gets mentioned in a lot of posts here;

you can download the PDF for free.

http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

another one that i like a lot is Brent Ozar's 60...

for domain users, that's all true, but for SQLLogins, unless you use the options, or set up a policy to enforce the options, you can still create users with weak...

it means the default database the user you are trying to connect with doesn't exist any more...renamed, dropped, whatever.

you need to log in as an administrator and change the default...

ok if you are running a command like the one below, what error are you getting?

Or is it you expect the SSMS object explorer to auto-refresh and not show...

ok, I have my own my knee jerk reactions for the things to review.

Grant wanted to avoid putting the answers on the forum, but i'd kind of like to see...