You could use a DSN-less connection with Windows authentication, which would look like this:

ODBC;DRIVER=SQL Native Client;SERVER=YourServer;DATABASE=YourDatabase;Trusted_Connection=Yes

you don't have to worry about type or location of a DSN.

In my case the blog post for Windows 7 was not correct. I found the auto-recover files at

C:\Users\<user_name>\Documents\SQL Server Management Studio\Backup Files\Solution1

what should the expression return if ColA is not null? if the desired result is ColA, then how about

COALESCE(ColA,ColB,ColC,'Other')

Tripz,

you may have thought of this already, but when you execute as a job on the server, the C: drive is the one on the _server_ C: drive, so...

sys.syscomments uses nvarchar(4000) for the sql text, so if you have a procedure longer than 4000 it will be split into multiple...

your version gives different results from the original or my own version...

you could use an undocumented system sp to avoid the cursor

CREATE TABLE #temp

(

[name] nvarchar(128),

...

according to http://msdn.microsoft.com/en-us/library/ms175098.aspx

"IDENT_CURRENT returns the last identity value generated for a specific table in any session and any scope...When the IDENT_CURRENT value is NULL (because the table has...

here is another way to do this without a cursor

http://www.wvmitchell.com/tips/SQL_table_sizes.htm

There is a very old trick that worked with Access 2002-2003 where you would basically switch the default printer to your PDF creator, print the report, and then switch the...

The problem is that the default encoding for CSV is Unicode. Add this inside the DeviceInfo clause:

<Encoding>ASCII</Encoding>

I would choose VB.NET over C# because SSRS uses VB.NET syntax for expressions and custom code.

I would suggest that you search these forums for DMO or SMO which can generate some very nice scripts.

Are you actually getting the lowercase y with the two little dots over it?

If so, your sql file is saved in Unicode, not standard ASCII. Open the sql file in...

An Access report requires only a SELECT statement to retrieve the data, so there must be some VBA code that runs when you launch the report - and that code...