I am not convinced you want an actual IDENTITY column given your comments. Can you please provide the CREATE TABLE statement and an example of the data as you want...

Are you using Check Names just to validate? i.e. are you usually provided the complete domain\account info? If so, while the GUI is good for some things, these types of...

AFAIK you'll have to work through your NAS group. You will not be able to see that through Windows since it not a Windows partition, it's just another network resource.

Most...

Abrar Ahmad_ (5/4/2012)

---

[font="Verdana"]Hi Folks,

Can we skip all other old auditing/security techniques (Physical copy tables/Different Audit columns in each tables etc) to utilize the currnet/modern type of auditing/Security features introduced in...

A couple more articles I meant to mention by JKehayias

Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents[/url]

Trading in xp_cmdshell for SQLCLR (Part 2) - Export Data to...

Jeff Moden (5/3/2012)

---

opc.three (5/3/2012)

---

Lowell (5/3/2012)

---

is adding CLR assemblies an option?

I made a suite of CLR export functions as a proof of concept, and i can export to any text data...

Bummer, sorry to hear that. If you find out please post back...hopefully someone else will benefit down the line.

Sure, happy to assist 🙂 what was the issue?

Rich Yarger (5/3/2012)

---

opc.three (5/3/2012)

---

The user sqladmin is a Windows user - not a SQL user, but has all needed privileges to operate...

Rich Yarger (5/3/2012)

---

Hello -

Yes - both databases are in default instances. My understanding of the -S switch is that it gives you the ability to specify the server...

Lowell (5/3/2012)

---

is adding CLR assemblies an option?

I made a suite of CLR export functions as a proof of concept, and i can export to any text data type or HTMl...

I do not see a -S. Are you trying to connect to the default instance on the machine where you're running bcp?

Update stats can be killed mid...

Seth provided exactly what you asked for, but I must ask, why do you need to " reorganize and rebuild all indexes of database" at one time?

Typically you only rebuild...

I had to check again (hence my last post) since the trigger is for INSERT & UPDATE...wanted to retest...my response is unchanged:

tfifield (5/3/2012)

---

Orlando,

There is another situation where even if recursive...