What you might want to do is build a table that includes this logic somehow, header before sub, etc. and then use that to join with this and order things...

If you have an exact match query, you use a nonclustered index that includes that column. If it makes sense, which is dependent on percentage of queries, space, etc., you...

Do you know how to write a trigger?

If you do, then an audit trigger just inserts changed data into some table. There are articles here on the site (search audit)...

Is this a named instance? If so, you connect to the browser service on 1433 and it lets you know which port the named instance is on. You need to...

That's strange. You should have had issues with this in 2000 as well.

I haven't specifically seen this, but I suspect that loopholes that might not have been well enforced...

Why not schedule the package and then take that command line?

Does this help?

http://msdn.microsoft.com/en-us/library/ms345282.aspx

It sounds like memory to me as well.

84k lines? How useful a report can that be. It would seem to me that it's been designed inappropriately in the first place....

Actually you roll on your shoulder, no neck involved. You learn early to tuck and I've never had neck issues, and I HAVE neck issues.

What typically happens is when someone...

ORDER BY gets you ordering.

SUM() gets you a sum.

the WHERE clause can filter things for you.

We'd be happy to help, but we'd like to see more info, as mentioned above,...

you should be able to use a trigger to log this information and the data should be available in there.

However, be sure you log the encrypted text or you...

I think the nomenclature here is confusing people.

The database is the schema+data+physical files. You wouldn't put this into VCS. You would put in the scripts to recreate the schema and...

Right click the folder.

The T-SQL is still there.

Mia,

I like that folder. Had a manager years ago freak out when I swept a large pile of papers out of my desk inbox into the circular file. Told him...

I've not used AS much either.

I tend to go

SELECT MA.MachineID

, MN.MachineName

, MA.machinename 'MachineName2'

, L.LeaseNumber

FROM MachineAudit MA

...

We don't allow deletions because it would start to cause issues.

If you figure it out, it's best to post the answer yourself so others can see it.