No, I'm afraid you have some tedious...

Ankur

You're probably in a better position than you think. You know what your reports are, you know what your master tables are, and you know what your ETL process...

I think you just need to ask your network people to give your SQL Server access to send mails via the SMTP relay server.

John

Ankur

I think you have two options:

(1) Set up a profiler trace, run for a period of time, then analyse.

(2) Periodically dump the contents of the dynamic management views to permanent...

Subhro

This is something that's best done by the presentation layer of your application, rather than the database layer. However, if you insist on using T-SQL, it's a simple piece...

Have you looked at DDL triggers?

John

Pooja

Thanks for the explanation. Bear in mind that we're not paid to answer these questions and most of us also have day jobs, so it isn't always possible to...

James

I don't understand what you mean by "I usually get all records in the index" and "that fixed 2 of the 3 records that were table scanning". Please will...

Pooja

Why is this urgent? Is it a homework assignment?

I wouldn't recommend doing this since it is likely that an inappropriate execution plan will be cached if you use the...

I think the line beginning with "if" should read:

IF EXISTS (SELECT * FROM sys.extended_properties WHERE [name] = 'Domain')

By the way, please try to post in the correct forum next time...

Enis

Is there any reason you can't set up a file connection and just use one data flow to move the data from the table to the file? No loops...

LiteSpeed is a good tool, but as far as I know it's not "built in"...

Iain

Yes, you need the name of the column that holds the date, instead of GETDATE(). The code you posted does not have a FROM clause. Please post the...

Radek

You can use the [font="Courier New"]WITH STATS =[/font] clause in your [font="Courier New"]RESTORE DATABASE [/font]statement in order to view the progress of the restore.

John

Good point from George about the failed restores. The change of ownership can be scripted, so I don't see that as an issue. You make your choice based...