MySQL has the group_concat function which is one of the only places I have seen it outshine SQL Server, and I use the word outshine lightly. The lack of a...

Steve Jones - SSC Editor (4/6/2011)

---

The Transcender practice exams I have seen in the past used to contain the actual questions on the MS exams. There was a time when...

It's Mr 🙂 And my name is opc.three ... Mr or Mrs 500 is just my rating at the moment based on the number of points I have on the...

Steve Jones - SSC Editor (4/1/2011)

---

I will say that my take on the exams is that they don't prove a lot, and if you use Transcender exams or other quiz...

Too bad this in not being done on Denali (or is it? :-D) where we have the OFFSET/FETCH expression.

Here is a video that may help you understand the basic use...

Looks like an SSC article waiting to happen...

You can get IP address from a DNS lookup on the server name...if you need the whole set of IPs bound to all network adapters on the server then you'll...

I trust you're just looking for opinions and not some concrete answer...I can imagine a couple scenarios where it might be useful:

1. I could see using the approach from the...

RamSteve, please post the code you have so far so we can better assist.

Lowell offers a good tip but one I would reserve for one-off troubleshooting. If you're using connection pooling (which you should be) you may want to consider how a change...

Just to clarify, a csv file is not the same as Excel file as noted by the xls and xlsx extensions. CSV stands for Comma-Separated Value and is nothing more...

I for one am having fun 😉 ...sounds like you are almost there JimS...keep us posted!

Try it this way:

USE BackupDatabase

GO

SET IDENTITY_INSERT TableA ON

DELETE FROM PrimaryDatabase..TableA

OUTPUT Deleted.PrimaryKey

INTO TableA (PrimaryKey)

WHERE 1 = 1

SET IDENTITY_INSERT TableA...

db_denydatareader may not be enough depending on what level of access the AD Group affords them. If they have permissions to create or drop tables then db_denydatareader will not prevent...

JimS-Indy (4/6/2011)

---

Just tried that. Exceeds nvarchar(max) limit....

Probly need to execute one at a time.

On second thought. It simply didn't print the whole command. Maybe it's a limitation of the print...