Viewing 15 posts - 4,186 through 4,200 (of 7,164 total)
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 4, 2012 at 9:20 am
Abrar Ahmad_ (5/4/2012)
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 4, 2012 at 9:09 am
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 3, 2012 at 10:19 pm
Jeff Moden (5/3/2012)
opc.three (5/3/2012)
Lowell (5/3/2012)
I made a suite of CLR export functions as a proof of concept, and i can export to any text data...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 3, 2012 at 10:15 pm
Bummer, sorry to hear that. If you find out please post back...hopefully someone else will benefit down the line.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 3, 2012 at 8:25 pm
Sure, happy to assist 🙂 what was the issue?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 3, 2012 at 7:18 pm
Rich Yarger (5/3/2012)
opc.three (5/3/2012)
[Simple as PRO-DBSERVER4B\sqladmin not having access to DB [FLEET-V3]?
The user sqladmin is a Windows user - not a SQL user, but has all needed privileges to operate...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 3, 2012 at 4:56 pm
Rich Yarger (5/3/2012)
Yes - both databases are in default instances. My understanding of the -S switch is that it gives you the ability to specify the server...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 3, 2012 at 3:54 pm
Lowell (5/3/2012)
I made a suite of CLR export functions as a proof of concept, and i can export to any text data type or HTMl...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 3, 2012 at 3:37 pm
I do not see a -S. Are you trying to connect to the default instance on the machine where you're running bcp?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 3, 2012 at 2:59 pm
Sapen (5/3/2012)
is it advisable to stop the update statistics job while its still running on prod env...its taking longer to complete (more than 3 hrs)
Update stats can be killed mid...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 3, 2012 at 1:59 pm
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 3, 2012 at 1:53 pm
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)
There is another situation where even if recursive...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 3, 2012 at 1:30 pm
...looking again...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 3, 2012 at 1:20 pm
Elliott Whitlow (5/3/2012)
I agree there IS some complexity BUT it isn't really all that complex. There are some great how-tos and even BOL does a really good job.
Straight queueing...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 3, 2012 at 1:11 pm
Viewing 15 posts - 4,186 through 4,200 (of 7,164 total)