Well. Remember that the sql security model is deny by default;

Its easy to forget that as a developer since you test as sa/sysadmin.

That means you can create a view and...

i think in addition to a DDL trigger, you want to change the default paths as well;

a simple CREATE DATABASE SANDBOX' command doesn't specify the path, so unless you changed...

a case can't due logic...it must return a single value; you are trying to use it more like an If statement to get NextReviewDate < getDate() for example.

i think it's...

chrisph (9/25/2012)

---

I changed the names for the example but I tried the command with exactly the same database and table name that reside on the server. The user I...

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...