I have been trying to create a linked server on a named instance to a default
instance using intergrated security.  It seems to work fine from a default
instance to any other SQL instance, including a named instance, but any time
I create the linked server on the named instance a ...

I am having some difficulty creating database diagrams in SQL Server Express
2005.
My design machine is running Windows XP Pro.  This machine is a member of a
Windows 2000 domain that I will call MYDOMAIN.  I am logged on the design

I've developed a tool in Visual Basic.NET and have a local instance of SQL
Server 2005 running. This tool loads a lot of data into my database. It runs
locally just fine, but when I set it to load the data into the remote
(webhosting) database, I get an error: "You do not have ...

I installed SQL Server 2005 for the first time today, and I set it to
mixed mode because that is how we have always had to configure 2000 in
the past for certain applications.  I used a weak password for the sa
account, and it caught that, so I changed it.

Hello, someone please help!!!!
I am trying to simplify life by combining 2 sql instances that are on the
same box into 1.  Basically there is only 1 database per instance that is
being used for any real time production activity.  My main problem is, that

We have a third-party SQLS 2000 based client-server system where the client
software uses SQLS logins (not LAN logins) to access the database. This
opens up the risk of users using tools like MS Access, MS Query, etc to
access the database directly rather than through the client ...

Is there a way to find out which user dropped my table in SQL Server
2000 and when? Thanks.

Need some assistance on the MS sql server security issue.
how to get all the users privilage ,vulnerable of a whole database ,
how to manage the configurations for whole database for a production team ,
is there any powerfull tool or .,.,.,i have to create a visual dialog script

What is the difference between 'Windows Authentication' login and 'SQL
login'?  I have IIS, MSDE installed on my home computer and I don't log
into windows.  So how does 'Windows Authentication' apply in this case?
Thanks,

I need backup Master data base, or only my DB?
why?
And What othen ?
Thanks

We have a product that is currently working with dotnet 1.1 and SQL 2000 &
MSDE , now we are upgrading it for SQL2005 and SQL Express and framework 2.0,
we use a stored procedure that reads a binary data from the database and
writes it into a file on the file system, this was ...

Hello.  I was wondering which method is the better security practice since I
read that windows authentication is better than my preferred method of sql
login authentication wrapped in https.  I'm creating an .asp database
application using windows basic authentication wrapped in ...

How can we proactively find out when a Windows Authentication ID in SQL
Server is no longer valid, i.e. an employee is no longer with the company so
we should delete their related Windows Authentication user IDs from our SQL
Server databases?

We created a Role (Alpha) and made it a member of the datareader Role.  Our
hope was that members of this role would only be able to preform data reads.
On a test we granted Alpha exec rights to an update Stored Procedure.  The
members of Alpha are now able to run the Stored ...

I have a stored procedure that I use to execute database backups.  It deletes
old backup files and then creates the full backups of all the databases.
I want to create an ID that can only execute this procedure.  I tried
creating a SQL ID with execute permission on this SP and ...