I'm not 100 per cent sure what you are trying to achieve, but a query like:

select top 1 Type from Test

or

select top 1 Type from Test order by Type

would...

If you have management studio express installed, then connect to the database, press Ctrl-N (new query window), and then type in the commands, Ctrl-X will execute it.

In case you do...

You can enable user instances on SQL Server Express by executing

sp_configure 'user instances enabled','1'

(connect with management Studio, and execute the above line)

By default user instances are disabled.

Regards,

Andras

Also see http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=149&messageid=393025

Regards,

Andras

Execute statements run under a different context, and table variables are not shared. You could try using a temporary table.

Regards,

Andras

Under SQL Server 2000 and 2005 you can get the trigger creation scripts from the syscomments system table. If the trigger content is over 4000 bytes, the definition will be...

An alternative for SQL Server 2005:

select object_name(object_id)

from sys.sql_modules

where definition like '%your_keyword%'

(This solution does not need the distinct, as the definitions are LOBs; also the syscomments will probably go in the...

Have you tried the GRANT SHOWPLAN database permission?

GRANT SHOWPLAN TO someuser;

Regards,

Andras

David,

do you have the Query Execution->SQL Server->Advanced->Disconnect after the query executes set?

Andras

Unfortunately you cannot drop the identity property with a simple alter table statement. You will need to rebuild this table (create another one with no identity property, copy the data,...

From the storage point of view there is not much difference. Both of these are stored together with the row data. Whether a column is null is just a flag,...

Hi Mark,

For that you would actually need a proper log reading tool. (I've written one a few years ago, but it is only for SQL Server 2000. This of course...

The transaction log does not always record the user who is responsible for a particular action, but I'd do something like:

dbcc log(databaseid,-1) with tableresults

You need to fill in the database...

You can use SQL Server 2005 setup to create a new instance. Before that I'd make sure that the SQL Server Browser service is running. This is needed to connect...

This is just one possible solution, but would you be able to make them register with a dynamic dns service (something like DynDNS http://www.dyndns.com/services/dns/dyndns/). This would allow to identify your...