I am brandnew to webdevelopment.
Using SBS2003 sp1 with IIS6, VS.net 2003 and SQL2000.
I created a webapplication with VS.net which has a SQLClientDataadapter,
which is connected with the SQL2000-server.

I am using server side traces to enable SQL Server 2000 and 2005 auditing.
Every time I start the server, I define a new trace file for auditing. So
till now I have configured around 100 trace files.
Now I want to get the list of all the trace files (which are at different

I installed Sql Server 2005 with NetworkService user and now
I can't connect with Management Studio with the Administrator account.
How can I do?
Thx! ;-)

We regularly need to take production DB backups and restore them onto our
development SQL Server boxes for testing (SQL2005 SP2).  Since DB level
security is much different between production and stage, we need to script
stage rights (server and object level) and refresh those ...

Is it a fair assumption to make, that the traceId of c2 auditing is always 1?
Say, I have switched on C2 audit in SQL 2000 and 2005 and i use
fn_trace_getinfo to get the active trace. Will it always return me  traceId
as 1?

What would be the difference between login deny vs login disable ? I see
those 2 options and feel they sound the same. When would I use one vs the
other ?

We want to create a SQL login  say user1 and the only privilges we want to
grant it is to be able to execute stored procedures in that database.
So is it just good enough to just do the following ?
Grant exec on sprocx to user1

I have a copy of SQL that comes with MS Vista, and downloaded SQL Server mgmt
studio express to work with it.
I want to change the authentication mode to SQL Server and Windows, and
create an sa account.  I have a database I then want to restore into this new

Hi. Please help.
Background:
A user changes their Active Directory windows password on logon and then
attempts to connect to SQL Server but fails. Once a manual synchronisation of

I am planning to change SQL service account from domain admininstrator
account to domian account with least previledges. I am not sure if i have to
change security on data and back up folder on local drive.
It will be great if i can get steps to change service account smoothly

Is it possible to tell SQL Server Express to only use SQL Authentication?  I
would like it so that there is just an sa SQL account on a SQL Server
instance.  Is it possible to script the SQL Server Express setup to do just
that?  I certainly understand that it can be more secure ...

I have some Access .adp VBA code (below) that deletes a SQL Server 2005 table
and recreates it.
DoCmd.DeleteObject acTable, "dbo.tblTemp"
DoCmd.CopyObject , "tblTemp", acTable, "dbo.tblTempStructure"

I have a problem with SQL Server 2005 SP2:
An exception occurred while enqueueing a message in the target queue.
Error: 15517, State: 1. Cannot execute as the database principal
because the principal "dbo" does not exist, this type of principal

IS it better to use mixed mode or windows authentication mode?  Which method
is more secure?

GlacierI'm trying to set up Ownership Chaining (though I would have preferred it if SQL 2005 supported EXECUTE AS for views).
When I set up both a table and view from one logon (mine) and granted permissions to the view it didn't work, evidently because "creating user" is not ...