I think you need to change it up a little.

For your parameter. the available values would be from your queried dataset, (All available states)

and your default would be a non...

Your question is an oxy moron, can you elaborate on your question, and state what your trying to do.

The non queried default would be "Hard Coded"

a From Query default would...

sp_executesql is exactly the same as sending an unparsed query from query analyzer.

It is parsed, normalized,  compiled, optimized, and executed.

I would doubt its the sp_executesql method, but rather the query...

You have a couple of things goin going on here.

When you construct a trigger you have to always make it accept data sets.

if you structure the trigger the way you have...

Dunno,

But I never use drive definitions for network resources in batch files etc.

Use the UNC \\Servername\sharname. instead.

In t-sql the Inner, or outer keyword is optional

inner join is the same as Join

Left Outer join is the same as left join.

I'm not sure if the ansi standards require...

Check out the samples that come with reporting services.

There are a few examples,

Look at the company sales report, It doesn't show a subreport, but the visibility, and toggle visibility...

No , not really.

But is beneficial for things like creating aggregated data in a view. for summarization. But not neccesary.

I don't generally use views very often.

With windows logins, you should be able to see individual users added to the list.

domainname\username.

But if you have Domain groups. you cannot see individual members.

yes, deleting/denying access to domain, does...

select name

from master.dbo.Syslogins

this shows the login names, but if you administer authentication thru windows groups, you cannot look at the members of the domain groups thru this query.

sql_Dmo is a bunch of com objects that are used to interact with sql server.

When you use enterprise manager, alot of the work em does to sql is done thru...

sysindexes holds information about indexes, and There is not date in the table.

sp_helpindex authors displays no date information either.

You do not need to reclaim the space unless there is some kind of issue with disk space on your hard drive.

sql will reuse the space in the log. But...

No, You are mixing the old t-sql join syntax and the ansi join syntax, they can't be mixed, its one or the other.

Use Pubs

select *

from authors a

join titleauthor b on...

From Books online

SQL Views

A view can be thought of as either a virtual table or a stored query. The data accessible through a view is not stored in the...