You might want to read this

http://www.sqlservercentral.com/Forums/Topic1173815-392-1.aspx#bm1173927

and determine if the use of !! to execute operating system commands will work in your environment.

If you do test ... please post your result...

Ed Wagner -

I know, practicing is not fun or exciting, but you don't want your first recovery to be when you need it and the boss is breathing down your...

I suggest that you read this article by Jeff Moden

http://www.sqlservercentral.com/articles/T-SQL/71550/

For an excellent article including sample data and the code that will do what you seem to asking how to...

Same problem with other authors .... for example Phil Factor and Guest Columnist: Larry Gonick

Ed Wagner (9/10/2013)

---

SQLRNNR (9/10/2013)

---

Brandie Tarvin (9/10/2013)

---

I am seriously thinking of making DBCC Timewarp settings one of my own interview questions, just to see how far the SQL Conspiracy has spread....

Now I known why I detest using triggers.

You might want to start by reading this:

http://www.4guysfromrolla.com/webtech/071906-1.shtml

and then if you have specific questions ask those questions in a new posting.

Thanks for a nice question - good way to start a work week

+1

Jeff Moden (8/15/2013)

---

I'm prepping a table, which has gotten kind of large, for partitioning. While I've found some workarounds for it, it seems bloody incredible to me that you...

I believe you will find what you are searching for in these two older articles here on SSC.

http://www.sqlservercentral.com/articles/function/67046/

http://www.sqlservercentral.com/articles/function/68323/

I would suggest using ISNUMERIC, however it has several disadvantages that can lead one to a false conclusion.

I would suggest that you read the following article by Jeff Moden to...

Read the following:

http://msdn.microsoft.com/en-us/library/windows/desktop/ms675048(v=vs.85).aspx

It lists what you can do and how to do it .....

This worked for me using SQL Server 2000, have not used in a later version.

Give it a try and then come back and post if it worked or...

For all the...