How do you give ALTER PROCEDURE permission without giving full db_ddladmin
permission to a database? I always thought that you automatically were given
this permission when you are granted CREATE PROCEDURE permission but this
doesn't seem to be the case.

Sometimes the result of "tablesample" is very uncertain.
The following sentence works normally and returns approximate 100 rows.
  use AdventureWorks
  select * from Sales.SalesOrderHeader tablesample (100 rows)

I have a SQL scheduled task that executes a statement similar to this:
osql -Q"custom_stored_proc" -SserverA -Uuserid -Puserpass -dMYDB -o"\
\serverB\output\outfile.txt" -h-1 -s,
Nothing fancy, just running a stored proc and sending the output to a

I currently have a log file that is close to 400 Gig, the data file is close
to 950 Gig. I have Log Shipping (remote site across a dedicated pipe) and
Mirroring setup on this database. When I examine the log file I have about
360 Gig of free space with in the log.

I have in my mind that I saw somewhere that in 2008 (EE) there is a tool to
claverly compare 2 sorces to see if they are the same (not soundex ). any
body knows what i'm talking about?

I am moving a bunch of data from tables in one database to another.
I disabling all my constraints to do this.  I would normally not do this but
I am moving data from an old database to new one and just want to get the
data there and deal with issues afterwords.

SQL 2008
Just started using the above database and after a week, no one could get
into the database. A quick call to the creater of the software told me the
transaction logs in SQL 2008 needed to be shrunk.  He walked me through it

I know in the past that there was a performance reason to put varchar
columns at the end of a table structure, and I believe, only having
one of them per table.
Are any of these true today? Is there any downside to using varchar

I've been having a bit of a problem setting up a differential backup
routine using the maintenance plan wizard in SQL Server 2005.
To cut a long story short, I take a full backup which is about 16 Gig,
my next differential is about 300meg, but then the following night, and

Hi, I have posted this in the Access Newgroup and it was suggested that I
should post here.
Using Access 2003 (vba) and sql 2005, I want to programmatically build a sql
database using another database as the template. That is, the new database

I want to see the actual size of the database in sql server 2000 as
autoshrink option is disabled.
Regard,
Muhammad Bilal.

I am making a schema change (changing a column to not nullable in a table
full of data) and it has taken 40 minutes already. I have no idea how much
longer it will take, so how can I stop it without upsetting the database?
TIA

Last  week we had purchased Application Server win 2003 and configured all
your internal appilcations in to that.
Yesterday end users got a error while uploading batches into SQL Server.
error:-

I'm a system admin.  Is there a way to dynamically monitor transactions
queued to be committed to database?  Perfmon counters?  Also, what's the
default check point interval?  The recovery interval on mine is 0. Is it
possible that slow disk could cause transactions committed ...

here is the table data:
cID CNAME   AGE   DOB          STATUS  Payment
1   SMITH   23    01-01-1986   1       90.00
2   SMITH   23    01-01-1986   1       100.00