Is the Username and Password specified in the Connection String of an ASP.NET
application transmitted to an SQL Server 2005 send as clear text from the IIS
Server?
The reason I asked is our IT department has mandated that all

I just tried out the encryption in SQL 2005. It looks like SQL server will be
generating different varbinary for the same plain text every time I run the
encryptbykey function. Is this how the encryption works? I was kinda thinking
that for the same plain text, it should always ...

I 'm looking for commands or list of commands, like alter exec, insert, drop,
and so on, that can chage or are dangerous for SQL. I will have web page, but
i would like to limit, what user can do.
I would allow select.... But not drop, so i 'look for commands that can

I created several stored procedures inside of SQL Server 2005 Studio
Managment, but I cannot view the stored procedures inside of Visual
Studio 2003. When I add a SQL data connection in VS 2003. I can see
the tables but no stored procedures. The DBA gave me create

We have a new dba that is requesting domain admin access to perform tasks
like checking account operator roles and settings on computer accounts.  This
is a new request to me, but I definately don't won't to just hand over domain
admin access.  Are there any specific high level ...

I have two database on the same server. Database A and datadase B.
I am using sql server for the databases and Microsoft Access as my front end.
I create a view in database A to see a table in database B.
no problem here.

We’re preparing to deploy service broker in production environment for the
first time. Our query which returns the ServiceBroker queue name for the
given ServiceBroker service name is returning nothing. At root of the problem
seems to be that the user does not have permissions to ...

Microsoft has confirmend that the encryption on sql server 2005 is not good
enouth (in 48 hours the data will be unencrypted).
And they say it will be match better on sql server 2008.
Did someone got data about it?

I've asked this question on vista group - but nobody seems to know how to
fix the problem...
I have a question regarding connection to SQL server using Management Studio
Express on a computer with Vista Business while using a VPN connection to

SQL Server 2005 has been installed on windows server 2003 machine by the
support team.
Microsoft SQL Server Management Studio    9.00.3042.00
Now this machine has been passed on to me to create databases, tables, etc...

I have just added to an application I am working on the ability for the user
to create a backup of the database the application is connected to.  The
backup works just fine, but prior to the backup I'd like to be able to check
that the user has BACKUP DATABASE, BACKUP LOG and ...

System: Server 2003 r 2, terminal services, SQL server, Citrix Presentation
server 4.5
Issue: An unknown IP address becomes attached to the server (class A, out of
a Canadian registar) on restart or even if the restart is performed w/o my

I have a question that I can't seem to figure out.  When I install a SQL 2000
w/SP 4 and no other users except for myself and sa, I see that the 'sa'
account is connected to SQL.  I'm using my server account to logon, I don't
have any startup stored procedures that are using the ...

Here's the set-up. We have a client with a very large active directory forest
(if correct term) and lots of users and servers. So we use Windows Groups to
control access to the database, rather than individual users.
We have a Domain level Local Group, which contains a Global ...

When using mixed auth, can a sql server authenticated account be set to lock
after a certain number of failed logins?  
I do not mean using the “enforce password policy” checkbox that will inherit
it from windows domain policies.