Koen (da-zero) (1/7/2011)

---

Brandie Tarvin (1/7/2011)

---

Don't forget the Mayans, Tom. While they didn't use it in actual math calculations, they understood the concept of zero, nothing, and the need for a...

Entirely possible. I haven't used xp_cmdshell in years. What are you using it for?

GilaMonster (1/7/2011)

---

GSquared (1/6/2011)

---

I dug around with a search engine a bit, and "sev3/sev4" refers to software support "severity level". There aren't standard definitions, but it appears that the higher...

I'm not sure about that "title" bit you're using. Using the structure I'm accustomed to, it might look like:

declare @Title varchar(100) = 'Number...

In 2005/2000 and as far as I know in 2008, xp_cmdshell runs by default under the credentials of the connection it's being run from. The issue you mention is...

I dug around with a search engine a bit, and "sev3/sev4" refers to software support "severity level". There aren't standard definitions, but it appears that the higher the number,...

GilaMonster (1/6/2011)

---

Craig Farrell (1/6/2011)

---

Best way to start that research is get yourself a small partition on a drive (usually your C:\ is smaller), create a database, and fill...

Cast/Convert the string to varchar.

Try assigning the values to variables, then using the variables when you call the proc.

You're welcome.

I'd use CLR for this. That has its own security risks, but they can be controlled/mitigated much better than xp_cmdshell.

There's a database creation date column in that table. Have you tried comparing that to sys.databases to check if they match?

If it can't find the expected file paths, it will usually put them in the default location. In that case, it won't overwrite ones in a different location.

It's an Asterix...

Jeff Moden (1/5/2011)

---

Brandie Tarvin (1/5/2011)

---

Any programming language that complains when I try to use 0 as a divisor should be taken off the market and all its install disks buried...