Viewing 15 posts - 2,911 through 2,925 (of 7,164 total)
mister.magoo (10/9/2012)
Obviously, you must ensure the web site has only ASP.NET Impersonation and Windows Authentication enabled in the "Authentication" settings for this to work...
You do make it seem simple, but...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 9, 2012 at 4:34 pm
JimS-Indy (10/9/2012)
I see. Any resources on how to verify the user is in an AD group?
.NET System.DirectoryServices.AccountManagement Namespace
I'm also really confused about App pools. Any resources on those? They look...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 9, 2012 at 10:59 am
You're very welcome. Happy to assist!
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 9, 2012 at 10:48 am
JimS-Indy (10/9/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 9, 2012 at 10:40 am
Query that checks for LOB columns:
SELECT t.name AS ,
c.name AS [column],
c.system_type_id,
...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 9, 2012 at 7:01 am
Appropriate for all? No. Pick a spot, maybe 90, monitor fragmentation, and adjust up or down.
I would be careful using a variable length column in a PK, especially if their...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 9, 2012 at 6:04 am
Yes, and references to the movie that made his flagship car famous:
http://en.wikipedia.org/wiki/DeLorean_time_machine
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 8, 2012 at 10:24 pm
I agree with the advice to use something other than a direct call inside the transaction. Write the data you need to export to a table and then have an...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 8, 2012 at 10:16 pm
No sense in reinventing the wheel. Even though the servers cannot communicate directly you can still use Log Shipping. You'll just need to automate the copying of the tran log...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 8, 2012 at 10:04 pm
Duplicate post. Direct replies here:
http://www.sqlservercentral.com/Forums/FindPost1368405.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 8, 2012 at 9:53 pm
Not directly. Linked Servers use OLE DB providers only. I did a quick Google session looking for an OLE DB Provider for JDBC but cameup empty.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 8, 2012 at 9:45 pm
Another reason not to use xp_cmdshell...
Hung connection wait type PREEMPTIVE_OS_PIPEOPS
Consider changing the process to a SQL Agent job that calls your script.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 8, 2012 at 9:27 pm
lonhanner (10/8/2012)
Will I have a...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 8, 2012 at 8:37 pm
Thanks. For future posts you can make the picture appear in your post by using the Image icon above the text window. Copy the link of the uploade image, yours...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 8, 2012 at 4:01 pm
kingrudedog (10/8/2012)
I want to say:
(automatically) estimate the backup size of this database and split it up so that each backup portion is never bigger than...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 8, 2012 at 3:21 pm
Viewing 15 posts - 2,911 through 2,925 (of 7,164 total)