Ed Wagner (9/4/2014)

---

Koen Verbeeck (9/4/2014)

---

andrew gothard (9/4/2014)

---

You know Chris Date? ...

Can you connect to the SQL Server using another tool from your Windows 7 PC?

Can you use the same code in a .NET console application (C# or VB) and connect...

Please be aware that the code you have provided is open to a SQL Injection attack. Whenever building dynamic SQL you either need to sanitize the input (very hard),...

As others have said, you need some way of determining what is the most recent row for each Case. Typically that is a CreateDate or UpdateDate column, or, in...

Since this is out on a file share you could look at the open files in computer management connected to that server to see what has the file(s) open.

There's no way I know of to natively share the results of a dataset between reports. I'd question the architecture that requires sub-reports that re-use data in the main...

Are you running the report from a report server or within BIDS/SSDT?

If from a report server I'd check the ExecutionLog3 view to see if the query execution is the issue...

Sounds like a good use for RowNumber() something like this (since I don't have your schema I'm just guessing at some things see the first link in my signature for...

Because this is implemented using .NET everything is case sensitive so if dataset2 is really Dataset2 it won't match.

Steve Jones - SSC Editor (8/29/2014)

---

It better be Wed. My flight home is Thur and I have to be in San Jose Sat.

It filled up quickly. We should have pulled...

When I get this error it's usually because I've opened the file in Excel/NotePad/PickYourEditor that has a lock on the file.

How are the files being created? Is the create...

Jeff Moden (8/28/2014)

---

I don't know for sure because I haven't used it in about 3 years but that kind of information might be in the default trace file. I...

Most of this information can be returned by starting with sys.database_principals, sys.database_role_members, and sys.database_permissions. You may want to use a recursive CTE to get all the role information because...

Sure you can deploy a report to any report server regardless of what the data source is. The only issue you'll encounter is if the data source already exists...

Stefan Krzywicki (8/29/2014)

---

Just registered for the SQL in the City event in Boston on 10/8 with Steve and Grant. I'm looking forward to it, but it is a little weird...