We have a set of Views that we only want a client to be able to see. The
client has been given a local, SQL Server login with sysadmin rights. A
corresponding User on the database has been granted SELECT permission against
the Views. The Views have been created with dbo as the ...

Any recommendations on a product t for version/source control type
stuff related SQL server database management?

We are in the process of migrating a windows server 2003 domain controller
with SQL 2000 SP4 installed to a different domain. At the moment, the SQL
service (under Services) logs in under domain\administrator. When this 2003
machine is moved to the new domain, this particular ...

We have a SQL database (BE) with MS_Access (FE) that works well (~80 users).
New requirement - we need to take this application, put it on 12 laptops so
the data can be collected at remote sites - (sites without a connection to
the internet, not even wireless connections.)

with many system SP's, there are 'optional' input paramters you either
can pass in or skip and the SP's response accordingly. I am wondering
how does that work. can someone please show me an example .
Thanks

I am running Windows 2003 SP2 x64 with SQL Server 2005 X64. Does the
counter SQLServer:Memory Manager/Total Server Memory (KB) show the
amount of physical memory is use by SQL? Why isn't this value reported
by the sqlservr.exe working set?

SQLServer 2005 version 9.00.1399.06
I am seeing what appears to be a discrepancy between DBCC OPENTRAN and
the SQLServer2005 Activity Monitor window.
In the activity monitor, there are processes that show a value >=1 in

Hi. I change the data type in a column (with data inside) from nvarchar(x) to
varchar(x), which to my mind should entail decreasing the table size, and
what happens is the opposite. The table grows. I issue this:
ALTER TABLE table_name ALTER COLUMN column_name varchar(x);

I wanted to configure Windows application log alert, when a Microsoft SQL
Server database goes offline.
Could any one have idea what’s best way to achieve it?
Thanks a lot in advance.

I would like to share my own experience with performance tests in raid 10
configurations. From what i read from web was that # of iops directly
proportional to number of spindles in raid 10 conf and 1/2 of write iops
capacity of all drives.

i have some problem with SQL2005 and Sql Injection .
I have developed a web application Asp/Aspx that connect to my SQLServer
2005  using  a sql account for reading the data.
The Sql Account used have only this permission :

On Sql Server 2000,
MSDN says to change the name of the instance you do:
sp_dropserver old_servername\instancename
GO

I am using SQL 2005 64x on Server 2003 64x. My current db size is
approximently 30gb. My log file is around 211gb. I don't really have any
issues with speed or performance. This is a Dell Dual Xeon 2.6 with 16gb of
memory, but I am getting a little nervous on the size of the log ...

I am trying to store Unicode characters (i.e. - Chinese, Polish,
French, English, ... )
in my database tables.
Sample Table:

I am unable to execute this statement in SQL express 2005 :
DELETE TABLE Servers CASCADE ;
If I remove the CASCADE, I am able to execute the statement.
why is this so , is this statement for SQL Server/Oracle full installs?