jarid you could streamline the use even further if you put that in a stored procedure.

for example, I created a proc sp_GetDDL which returns the table structure of a table,...

if you've got the linked server up and running, that's 99% of it;

the rest is just syntax.

something like this is how you update from another table...and it doesn't matter if...

that documentation here is a little inferred ("the log" means sql error log), but "you mean like this one:

http://msdn.microsoft.com/en-us/library/ms175850(v=sql.90).aspx

How to: Configure Login Auditing (SQL Server Management Studio)

SQL Server 2005 Other...

looks like poorly worded documentation to me.

the way i read that is that they mean this instead:

ATTACH the database connect the application to that database and it the application will...

ok this seems to have everything for creating a linked server to an Azure Cloud; what kind of cloud server are you using?

http://blogs.msdn.com/b/sqlcat/archive/2011/03/08/linked-servers-to-sql-azure.aspx

DDL structure and the data both, or just the DDL?

hierarchy of the tables due to FK's need to be in the mix there somewhere as well, if we are Creating...

looks important:

http://www.fileinfo.com/extension/rml

i think those files are used by autocad and are drawings of something;

the server might not have autocad installed, so there's no application to open them by default, but...

no, like the code below..you don't use identity_insert unless you have to.

you didn't answer my questions:

why do you have to enter an almost identical row into the same table WHERE...

yes. don't reference the identity column,and let the pk automatically...

nowhere in the trigger example you posted is the IDENTITY_INSERT command being used.

can you show us the code you are using?

i would have expected it to look like this:

ALTER TRIGGER...

Suresh Arumugam (12/6/2012)

I was trying to tune a particular SQL query which use to take more than 10 seconds to return data. Added much needed Non-Clustered Index for one...

samalex (12/5/2012)

I found this earlier too, but it appears to be an outdated article since the Download URI goes to http://www.microsoft.com/en-us/download/default.aspx which isn't valid. ...

i've got this script i posted here on SSC multiple times that seems to do a nice job for me;

for Invalid Objects, it's not like oracle, where there is a...

well so far, i haven't been able to get a duplicate in my limited testing;

i was thinking that maybe a developer had a transaction open, went to lunch, and then...

you can use a technique using SUM(CASE... to get subtotasl;

you'll have to construct the multiple case statements to match your descriptions, i think.

here's a prototype based on the query you...