I believe that you just use NVarchar(..) for that.

I don't think that you can receive events in VBScript or Jscript can you?

Not with a SELECT statement. It...

rbarryyoung (8/26/2008)

---

developer6 (8/26/2008)

---

Jeff: I can only assume that you are not resident in the UK. If being stupid was in any way a prevention for getting old the...

Alphabetic(A-Z) characters or Alphanumeric(0-9,A-Z)?

It's not hard to do, but you are going to have to define the sequence that you want better.

Jeff, dude:

Jeff Moden (8/26/2008)

---

SELECT ROW_NUMBER() OVER (PARTITION BY ShiftID, TableID, StationID, EmployeeID, DATEADD(dd,DATEDIFF(dd,0,CounterDateTimeStamp),0)

...

I think that you need to give them db_ddladmin.

Of course, this may also give them the ability to modify the definitions.

developer6 (8/26/2008)

---

Jeff: I can only assume that you are not resident in the UK. If being stupid was in any way a prevention for getting old the population...

Okay:

First you have to make sure that you have a System DSN that points to the Database where you want to save the performance data. You can set this...

BCP is usually recommended for something like this. However, this is dependent on a lot of details such as file format, your window for import, etc.

rbarryyoung (8/25/2008)

---

You know, I had forgotten about this, but you can also setup a Perfmon process to log to SQL Server.

If you set it up to run at system startup...

Ah, OK. You see "Incorrect syntax" is a much different error than "Invalid object name."

Hmmm...

Michael Earl (8/26/2008)

---

Once you enable xp_Cmdshell, it can be used for a lot of things. If the CLR procedure can only move a file from one location to another,...

Please see this link for etiquette on providing data and table structures: http://www.sqlservercentral.com/articles/Best+Practices/61537/