Yes. Provided it is not being blocked it will complete practically instantaneously.

This type of comment is not surprising at all. Yes prejudice still exists and no it is not going to go away anytime soon. Thanks for shedding some light on...

Krispy Kreme

Gantt

pdanes (8/22/2013)

---

opc.three (8/21/2013)

---

... consider a Linked Server configured to connect to and issue queries against AD. Getting a user's group memberships, or a group's members list, is trivial using a...

Do you control the connection string the application uses? If yes, are the users in the group prevented from seeing the connection string either due to the architecture or the...

Expiration Date

Matthew.Peters 13064 (8/21/2013)

---

No, We have 3rd party backup software which has made a backup call to SQL server, this process has been stuck in a rollback state for over a...

Have you seen the @from_address and @reply_to parameters of msdb.dbo.sp_send_dbmail?

Sorry pdanes, but using SQL Server as a conduit to AD, especially via xp_logininfo, to control what a user can see or do within an application seems like a bad...

You can't. Are trying to track down which OS process was spawned by a call to xp_cmdshell by any chance?

taigovinda (8/20/2013)

---

In trying to understand this a bit better, I googled for 'primary key clustered' vs 'unique key clustered' ... if I understand correctly the unique key will NOT prevent...

SQL Server will use and hold onto as much memory as you allow per the max memory setting. It is expensive to retrieve data from disk and load it into...

SQListic (8/20/2013)

---

Hi Experts..

Requirement:

--If the following query resulted greater than zero rows, send the results in email in a tabular format using SQL Server database mail

--if is is equal to zero...

Oracle765 (8/20/2013)

---

Hi Professionals.

I have a question regarding importing data from spreadsheets.

I manually use SQL Servers Import and Export wizard to import a .xls spreadsheet and it is intelligent enough to...