GilaMonster (10/31/2008)

Thanks....

I don't think SSRS supports CSS. The way to have consistency is to provide custom templates for report creation.

From BOL:

Copying a database using BACKUP and RESTORE

The following example uses both the BACKUP and RESTORE statements to make a copy of the AdventureWorks database. The MOVE statement causes the...

Very nice article Gail. Clear, concise, and to the point. Sounds like a follow-up on how the checkpoint and lazy writer work would be good.

Wow, not a fun or real performant thing to do. First you need to return the data from the XML column of the product group table as a table...

Hey, practical jokes on Halloween are acceptable. It is TRICK or treat, and sometimes we'd rather of the treat of playing a trick!

I assume you have been trying to run the delete using SSMS. Have you tried just using the sp in T-SQL without the @force_delete parameter?

select * from msdb.dbo.sysmail_profile

to get...

The account with which you are connecting to the linked server needs to have the proper permissions on the linked server and in the database(s) on the linked server.

What service pack level are you on? I think this was fixed in SP2.

The query you provide should return all rows in tab where '@friends1.com' are the final characters in the email column. If you have any non-blank characters after that string...

Temporary tables are created within context and when you use dynamic sql you have created a new context, so when you

create a temporary table within dynamic sql it is...

TableDiff compares data in tables with the same schema. If the schema...

I think you need to use a script task to get that information. Or, you can download the File Properties Task from PragmaticWorks that already has that stiff done...

Are you getting any errors logged by your services? Are you seeing any errors in your event logs or SQL Server logs? Have you looked at your SQL...

I have read about some hacks to "edit" data using reporting services, but probably not the best way to do it. You could provide a link to a separate...