I like to repair bicycles.  In the spring, when my coworkers are starting to think about summer riding, I'll have 1 or 2 bikes to work on in my garage...

Mark,

You can't remove the identity property from a column without recreating the table.  You can use SET IDENTITY_INSERT to allow insertion values, but you can't remove the property permanently.

Greg

No way that I know of unless it's logged in msdb's t-log.  If it is, a log reader like Lumigent's Log Explorer or Apex SQL's Log would retrieve it.

Greg

Would you describe your DTS package in more detail?  What tasks and connections are in the package and what is the workflow?

Greg

Phil,

Look at this article by Robert Marda: http://www.sqlservercentral.com/columnists/rmarda/howdynamicsqlcanbestatic2.asp

It helped me rewrite a dynamic query in a stored procedure into a static query with the same performance and nearly the same...

It shows up that way on some of my servers too.  I read one theory that the query might return 'Disabled' if the license mode was set to per processor...

No difference.  SQL Server 2000 works the same way.

Lotta posts this afternoon, Adam.  Got a quiz tomorrow?

Native SQL Serve backups don't require the server to be offlilne and most 3rd party backup...

Oh, sorry.  Try this:

SELECT SERVERPROPERTY('licensetype')

I'm not positive this works with v7.0.  Another way to find the license mode is to look at SQL Server 2000 Licensing in the servers's Control...

Hi Sonia,

You can use either BCP or DTS to load the data from text file to table.  Both can be scheduled in a SQL Server job.  Both are pretty well...

Run this in Query Analyzer:

SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY('productlevel'), SERVERPROPERTY ('edition')

Greg

Have you tried SQL Scan from Microsoft?  It's part of a bundle they released following the Slammer worm.  We use it and it seems to find all instances.

http://www.microsoft.com/downloads/details.aspx?FamilyID=9552D43B-04EB-4AF9-9E24-6CDE4D933600&displaylang=en

Greg

Did you rename the steps or the tasks?  Step names are what appear in the package logs.

Greg

You specify the connection in the Execute SQL task, rather than connect the task to a connection with workflow.  In your case, S2 is specified in (SQLTASK).

Greg

As far as I know permissions for DBCC commands can't be granted to users, only to roles.