i also have this saved which uses one of the DMV's to identify slow queries on the server:

use msdb

go

if not exists (select * from sys.schemas where name = 'MS_PerfDashboard')

exec('create schema...

without using SQL Profiler, or creating a Server Side Trace, it is not really possible. a server side trace has minimal impact, and I consider it a best practice to...

GlenParker (5/14/2010)

---

I am copying data from an inner join condition to select only applicable data for an external customer.

My problem is that I need to deselect the column attribute ie....

from msdn:

http://msdn.microsoft.com/en-us/library/ms189077.aspx

By default, the VIEW ANY DATABASE permission is granted to the public role. Therefore, by default, every user that connects to an instance of SQL Server can see all...

you have end users logging into your Server using SSMS?

anyway, I'm thinking because CONNECT rights give them read access to the master database, and sys.databases has the list of...

yep it's documented; what you are looking for is editing the "noise words" file;

mine happens to be located here:

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTDataoiseenu.txt.

if you look inside it, you'll see all single...

I'm a little twisted around i guess; you'r not doing this from a C# application like you said, or are you getting the estimated plan in your results to your...

if you are doing this from a .NET application, can't you jsut put the results in a DataTable and get the DataTable.Rows.Count?

otherwise i think you can get the "xx...

as far as i know, you can get it only if they used their windows credentials to login to the server; if they logged in with a SQL login, it's...

you had joined them, thought that's what you wanted;

try a UNION ALL instead:

Select

Alias1.id ,

Alias1.type ,

Alias1.number ,

Alias2.ID_NBR ,

Alias2.PHONE_TYPE ,

...

a slight variation on your original code; all i've really done is present more data, so you can see the changed columns;

since you never showed the PHONE_NBR from the other...

restoration of items is something done from within TFS inteface in Visual Studio, and never at the SQL Server;

i'm pretty sure this is the steps:

in Visual Studio go to "Tools>>Options"...

well, i was looking at using the function is_rolemember(which returns 1 or NULL, not 1 or 0) and IS_MEMBER('af_developer'), but i think it finds explicit grants to roles, and not...

I don't think you understand the security model;

it is very common, for example, that an end user does not have any rights to tables, and all the operations occur only...

TheSQLGuru is right! this forum is one of my first items on my list of resources!

this...