a perfect example of why you should not use the old ansi syntax, and only the new ones with the JOIN keyword.

your query never connects the table FWXProductClassification to anything...

just checking the basics...SYSUTCDATETIME() is SQL 2008 only...could it be the server you ran the script on is 2005 and the trigger is failing with invalid column name?

Paarth no, you can't assign a column value as a default...it has to be a constant or results of a function.

i think you want to either use a calculated column(MyCol...

I'd also suggest looking at parameter sniffing and whether statistics are updated on the production servers as well...both of those things can lead to bad performance.

river i don't think you need to check it before hand , just change it...

if xp_cmdshell is already enabled you just get this message anyway:

Configuration option 'xp_cmdshell' changed from 1...

that requirement reads like the person who wrote it already knows the answer/how to do it...this isn't a homework question or anything, is it?

http://en.wikipedia.org/wiki/AutoRun

autorun is an option to call a specific executable on a CDROM, if the user has permitted it(registry settings are checked)

so you could create an executable that is called...

not sure on the space saving thing....is it that important to try and downsize the db?

for the second part, if adding a column affects the application, i think you'd...

ok forget the do it yourself thing: download this free program:

SQLRecon[/url]

it will scan your entire network in a LOT of differnet ways, and find all installations, including multiple instances ont...

I would do this outside of SQL with either a sqlcmd , cmd script or an application. personally doing it in vb.NET is easiest for me, your milage...

niter can you show us the current query you are using? we can probably infer a lot from that, but the CREATE VIEW definition would help as well;

the requrement looks...

Twinsoft is right...if you import the diagrams into a database that does not have the exact same object_id's, it fails with the same error...

not sending externally is definitely a relaying issue, that was my point....it's not really a SQL issue anymore if you know you've already added everything for basic authentication. get with...

Terry this is a pretty common situation, and the issue has to do with relaying and your exchange server / mail server.

mail servers are set up to avoid spam. as...

lets cover the basics, Andre, since this is your first post:

a VIEW is a saved SQL statement...so if you have other views in the test database, you will need to...