Client xx.xx.xx.xx is still trying to connect to your server, even though you've deleted the login it's trying to use. Find out what application is running on that client...

Raghavender

Please will you describe what you're trying to do? It looks as if you want to display the server name and instance name without the separating backslash. To...

I'm finding this difficult to visualise. Please will you provide table DDL, sample data and what you have tried so far so that we can picture it more easily.

Thanks

John

I would say so, yes, otherwise you will need to change your code every time your exclusion list changes.

John

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...