I have a task to restore a prod db to DEV and I want to keep all users,
roles along with all the permission in DEV like they were before the restore.
Does anyone know what would be the best way to handle this? Is there a way to
script out all users, roles, permissions that I ...

We have a vendor that is recommending that if we want to do log shipping, we
should set the db for simple recovery model. Anyone ever heard if that is
possible? The only thing that I have seen or read about, it must be either in
full or bulk-logged models.

I have a situation where I have a SQL job that needs to create some views and
sp's. The problem is that I need basically to have an sp create these views.
I have thought about using sp_executesql, but how would I deal with the
following sql command:

I have a table COUPON with a clustered index on two columns (username,
date_inserted).  COUPON table references USERS table on username.
Q1. Should I create the clustered index on (username, date_inserted) or
(date_inserted, username)?

Hi, I hope someone may be able to offer some suggestions here
The scenario
I have installed two instances of SQL Server 2008 64bit on a 2008 server.
The default instance and one called MSSMLBIZ. The default instance is

I read on another website that you can not move a table with a text or image field in it, is this correct?  If so what is the best way to re-create the table in a new filegroup?  This one table is using 85% of my database and we want to move it to another set of disk-drives.  ...

I have a SQL Server 2005 database that I do not have sysadmin credentials
for, only Public, but I need to take control of it. I.e. give myself
sysadmin. I have Enterprise Admin credentials on the domain.
Anyone know what the best/quickest way of going about this?

I need quick help and a UDF for comparing last name in the database
table to a last name in the file (one at a time). File can contain
names in any of the following ways.
Joseph Edna (interrested in parsing Edna only)

We are using SQL Server 2000. We have linked servers. We wrote a SP
containing only a print statement on the remote server. When we try to
execute SP by calling remote procedure we get the following error msgs. SQL
Server 2000 SP4

My working query:
select
min(datetimecreated),min(datetimeexpires),min(datetimeredeemed),sum(redemptionminimum),
sum(redemptionmaximum),min(localvaluetext),sum(discountpergallon),min(maximumpurchaseamount)

This is related to my earlier triggger question but it's a completely
different issue.
My db (sql 2005) is not set as case sensitive. However, I have a trigger
where I need to compare the old and new values of one particular column and

In a stored procedure, I have a decimal-defined variable as DEC(13,2).  
I need to write its value to a column in a table I'll be creating.  This
column needs to display its value as 11 chars, with the first char being
a space and values after that padded with beginning zeroes:

Can anyone please tell me why sqlservr.exe uses very high memory usage?
In one of our application, we found that the system becoming too slow
because of this SQLSERVR.exe. The momory usage sometimes crossing>1 GB. Can
you please tell me

I created a trigger to post data to a history table if the value of a
particular column has changed in its parent table. In the beginning of the
trigger I have:
IF UPDATE (Notes)

         i have three Union ALL statements with three tables , In one
scenario i need only two tables, Other than case , is there any better
way???
Thanks in Advance