Am I the only one bothered by the lack of unique constraint/index on the natural keys in in the new tables.

The new design allows the insertion of duplicate entries for...

I have been able to deduce from seeing other activity by logins with sa privileges around the time of a given event.

E.g. tempdb object creation or worse yet sort warnings.

All...

Sean,

Very clever use of parsename.

You do not want to restore msdb from one version to another.

Select the jobs folder in SSMS and select F7 or select View/Object Explorer Detail.

This will list all the...

Kind of accidental.

I started as an economic consultant.

I was pulled into working on a crude oil transaction database, Sybase 4.X on NextStep.

After few years of T-SQL coding and very...

Sounds like this is between the OS and EMC

Permissions on tables (select, insert, update, delete) are separate from permissions on stored procs (execute).

Execute on a proc allows a user to do anything the proc does in the same...

It might tell you what else is using memory on the server.

Also in my experience Task manager may show that you are using less memory than you really are, but...

Have you looked in task manager?

Btw

Max Memory for INS1 = 8 GB

Min Memory for INS1 = 1 GB

Max Memory for INS2...

You'll find if you are dbo in SSMS under Database/properties/Files/Owner

Is your login the explicit dbo of the database.

If that is the case you cannot add yourself because your already are a user as dbo.

You can either do this via TSQL, using the linked servers and database mail or via Powershell script that connects to each server, pulls down the updated date compares...

Create a #temp table with all the columns of the proc's output.

Insert the output into the temp table, then insert the subset of columns into the destination table.

You can do the following:

[font="Courier New"]insert into tMain

(c1, c2, c3)

EXEC sp_022 'alpha', 'bravo', '1/1/2011'[/font]

You have a typo. Should be > $null