create function dbo.tfFoo()
returns @t table
(
ID int

What is the difference between local administrators group and domain
administrators group?

Everybody knows that on SQL 2005 password expiration can be enabled for SQL
logins. The question is how to know on a Client side about password
expiration date in advance? You know, to ask user something like "You
password will expire in a 2 days, do you wanna change it now or ...

I think this has happened to me before, but can't seem to find any notes on it.
I've got a windows-authenticated login that is the database owner.  Login
cleanup occurs in Windows, and the login is dropped.  What is the impact on
the database that still references this ...

Dear all,
I have a question about the difference between file/filegroup backup and
copy the mdf, ndf, ldf file directly
1.) If i copy the mdf,ndf,ldf file and then replace the file(recreate the db

If i want to setup login account for application developer to access the
production sql server
and i just want the user can preform any task only in one user database (say
ShoppingCarts)

hello im brand new to SQL server but im very well versed in access so i know
how sql works, to aid me in my transition im the microsoft press SQLServer
2000 book and am trying to follow the simple instructions to create a table,
the script is very simple:

Dear all,
i want to verify whether the following backup planning can restore to the
original environment  or not
1.) backup master, msdb, model with full backup to bak

one of my database is suddenly crashed with power fluctuation and when i
started the server it is showing "not able to connect database". I have taken
backup and i was trying to attach database in other system. It has given me
the following error.

Does any one can help me to find good documentation on SQL Server Disaster
recovery plan.  SQL 2K.
Thank You,
Larry

Can someone please let me know what are the best practices for securing a
sql server?  The department is split - I have dba's and network analysts.
The dba's are responsible for sql and the network analysts are responsible
for the os.

I have configured my SQL Server to run under domainname\username
account. It is wroking fine till i restart the m/c. If i have
restarted,then Sql service is not being started. I have not changed the
Password also. Everytime i need to go services tab and then i need to

I have a SQL Server 2000 on an intranet with windows security. A stored
procedure is called every time  users add orders into table ORDERS.
How can I detect the login name and domain for the user that adds a new
order? What would the lines of code look like in the stored ...

We currently have a database that is in development using MSDE  and being
hosted at the delopers site (Front end is in Access).  Clients currently
access the database via IP.
We are planning on bringing this in house and using sql server.  Just got