almost identical, only some fucntion names are different:

--SUBSTR(TARGET_ID,6,INSTR(SUBSTR(TARGET_ID,6,LENGTH(TARGET_ID)),'.',(-1))-1

SELECT SUBSTRING(TARGET_ID,6,CHARINDEX(SUBSTRING(TARGET_ID,6,LEN(TARGET_ID)),'.',(-1))-1)

look in the scripts section; there's lots of examples where somone has wrapped sp_spacedused in a cursor,

For an example of using sys.dm_db_partition_stats that gail mentioned, if you pick...

sp_spacedused 'Tablename' is pretty good for at a glance info.

sp_spaceused 'MyTable'

/*

name rows reserved data index_size ...

itvfs are applied once to the set, and not against each row.

an inline TVF will always out perform a multi line TVF;

ITVF's are really just a special JOIN type in...

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