You can look in SQL configuration manager or run the below script:

DECLARE @test-2 varchar(15),@value_name varchar(15),@RegistryPath varchar(200)

IF (charindex('\',@@SERVERNAME)0) -- Named Instance

BEGIN

SET @RegistryPath = 'SOFTWARE\Microsoft\Microsoft SQL Server\' + RIGHT(@@SERVERNAME,LEN(@@SERVERNAME)-CHARINDEX('\',@@SERVERNAME))...

Easiest thing to do is open a trace and see how SQL itself is connecting, then just emulate.

Andrew

If you use functions in the where clause, whether user defined or system functions, then the optimizer is unaware of the value and has to determine it on each row,...

When I first started at a position, a couple of heavy revenue earning SQL boxes where being backed up via VERITAS to tape, the rational that there was not enough...

I needed to do this for an audit, only user DBs, looks like SQL management Studio does it like this, cobble from the enture script, we have replication so needed...

can you add DTexec.exe to the enviroment variables via right clicking mycomputer and choosing properties?

Andrew

Check out this blog post, shows how to do it:

http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/05/04/dyk-maintenance-plans-have-owners.aspx

Andrew

This should give you what I beleieve you are after, you may need to add more feilds, sure I got this from here in the past, can't remember:

select

SUBSTRING(s.name,1,40)AS'Database',

CAST(b.backup_start_date AS...

Or create roles or logins that are windows security groups and use these to assign rights.

You could use a stored proc and capture the calling user, as long as they are using windows login and then use the value in the proceding select

declare @loginame...

What version of the OS is this on, if its 64 bit, I believe there is no jet driver?

Andrew

I like books that Brian Knight has been involved with

Professional SQL Server 2005 Administration is good, and the earlier book dealing with SQL 2000 is good as well

SQL Server 2000...

You will need to issue a shrink file against the files in the file group, after they are empty you can then drop them and the filegroup.

Andrew

If I get you requirements correctly, wouldn't database schemas work here, have each client have a schema in one database. Search this site for schemas, or check out BOL?

Andrew

It really depends on what type of shop you are trying to get into, if you are looking to get into a large shop it may be difficult, junior level...