In Registered SQL Server Properties (General Tab) there is a check box
name "Always prompt for login name and password". A user can do it
using Enterprise Manager. But I need to know if it can be done by any
system SP or TSQL?

i have a sql 2005 express edition installed on a win2003 server. i
tried to run a select query from a database. The performance is fast
on some workstations however some workstations are at least three time
slower than those fast one. i ran the query from same machine same

We have an SQL Server backup job that backups up a database every two
minutes. We also have an alert where if the percent log used is greater then
75 then the response is to run this same backup job.
The backup file is named as such:

Is there any way to check if SQL server Command Line Utilities is
installed in the system using SQL?
Thanks for any help in advance.

When configuring a connection to a sql 2005 server via the Data Connection
Wizard in Excel 2007, there's no problem using Windows Authentication. But to
use an account other than what i'm logged in as, namely a domain service
account that i hope to store with the excel report, ...

I have two tables that are related. The first table (Sites) has a varchar(4)
for a primary key and I want to change it to be an int identity column. I
broke the relationships and renamed the current pk column to siteID_Old. Then
created a new column called siteID and made it int ...

If I have a server that is ONLY running SQL Server 2005.  What are the
pros/cons to running Norton Antivirus on that server?
Does it make sense or is it a waste of resources?
thanks..

I have a query developed in SQL2000 that is now on SQL2005.  It is run daily
to a grid, where we use "save results as" to write the results to a csv file
for use in another system.  The query works fine, but the output is now
Unicode instead of the (SQL2000) ANSI format.  Unicode ...

When I have to restore a number of Logs, I have to change the FILE number in the RESTORE command
manually.
Is there a way to automatically restore *all* log files?
Thank You

I have a stored procedure which has an In Bit parameter, when I run it, I
input the 0 or 1, but I am told that the  can not be converted. How can I
input
Clara

 This is surely a newbie question but I'm not sure of the answer.
If you do an update with a where clause (or delete/insert for that
matter), does it work by first gathering all the rows and then doing
the update?

Have a programmer thats allowed users to enter "apostrophe" is a name field.
Im attempting to search of them using:
select * from table where [name] like '% ' %'
i.e

I want to know many things about Joins and subqueries...I am working
as a DBA for 3-4 years now and in my current company, there are
several projects where I have observed that many Stored Procedures
used in the respective Databases actually uses several no of joins on

I need to backup data on Computer A and restore on Computer B.
How do I do that?
Both are SQL Server 2005.

I’m sorry if this question’s been asked before, but I couldn’t find anything
online.
I’m working on an Installshield installation that needs to create an instance
of a database on a Vista 64-bit PC using SQL Express 2005, then later use