Take a look at the SQL Server Health and History tool. It collects event log data into a repository database.

Lookup "Latching" and "Locking Architecture" the SQL Server Architecture section of Books Online.

Generally the first thing I do for our SQL Server installations is setup the SQL Server Agent to forward all events to a central server/workstation. This gives you a single...

What size are the tables in the database? If you have a very large table with a clustered index you will need approx 120% of the used space for that...

I'm not sure that you are able to administer SQL Server 2005 from SQL Server 2000 Enterprise manager. If you apply SQL Server 2000 SP4 to your SQL 2000 installation, you'll...

The way we solved it was by using a specific SQL login when connecting to the server to edit packages.

Doing a SELECT INTO #TempTables can cause blocking in tempdb.

I don't think that's a modifiable property.

In my opinion, if you're doing this often enough for it to become troublesome, maybe you should...

Most likely culprit is that the strJob variable isn't re-initialised. It should work better if you change this line after the CreateTextFile line,

 strJob = strJob & "--------------------------------------------------" & vbCrLf

to this

If this is "a direct insert from one table to another", why is BCP involved?

If you are importing data into the table from another source, then again, why is BCP involved?

In...

Microsoft also provide a basic SQL Admin program thats web based. It's not as feature-rich as EM though

http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&DisplayLang=en

SQL should indeed be able to handle sorting out generating the identities in this scenario. What you should be aware of is the different methods of returning the generated identity...

You're missing the "INTO @pk" part on your second FETCH statement.

The reason this problem arises is because SRS evalutes both sides of the IIF statement.

Try this instead,

=iif(Fields!OnHandCount.Value = 0, 1, Fields!OnHandCount.Value) / iif(Fields!IssuedCount.Value=0, 1, Fields!IssuedCount.Value)

You've got two options I can see straight off. Either way you won't be able to use the wizard.

1. Import your CSV file into a seperate table the database using...