That is how our SQL Server Server account is set up, although it is my understanding that having local admin access is not a requirement to getting it to work....

That is how our SQL Server Server account is set up, although it is my understanding that having local admin access is not a requirement to getting it to work....

Here is KB article that should help you with setting up SQL Mail.

http://support.microsoft.com/default.aspx?scid=kb;en-us;263556

As far as shutting it down, I think you can just run xp_stopmail. I've never had a...

Mkumari suggestion sounds good, and normally works for me.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Have you ever tried running this script prior to shrinking the log file:

http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=26&CategoryNm=Maintenance%20and%20Management%20&CategoryID=1

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

I personally always have all objects owned by "DBO" then any user in the database can access that object if they have the appropriate permissions.

Are you trying to...

I'd go with the bulk export/input idea. This is clean and simple.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Here is some code to change the not null and default value for a column:

create table xxx(xxx char(1) not null, yyy char(1))

insert into xxx (xxx) values ('x')

select * from xxx

update...

Sorry that really should be:

sp_recompile '<database>.bruprod.catTitles'

where you replace <database> with the name of the database where catTitles is an object.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out...

have you tried:

sp_recompile <database>.bruprod.catTitles

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Not exactly sure what you are asking. But if you want change the owner of the table use the "sp_changeobjectowner" SP. Look in BOL for complete syntax.

Gregory Larsen,...

I've always thought you could build a process. The process would read the syslogins table and use either the password field or the updatedate fields or both, and store...

I used to think I didn't want my logon or SA associated with MASTER, until I tired to recover my server one day a year or so ago.

Can't...

Are you looking to run your database off the CD-ROM? Or are you just trying to move your database from one server to another via CD-ROM media?

Gregory Larsen, DBA

If you...

Here is another option for you:

select a.TransAno, a.Prodcode,a.SumQtyCheck, b.sum_qtyonhand, a.SumQtyCheck - b.sum_qtyonhand as different from

(Select TransANo,Prodcode,sum(QtyCheck) as Sum_QtyCheck

From Trans_A

Where Sum(QtyCheck) > 0

group by TransANo,Prodcode) A join

(Select TransBNo,Prodcode,Sum(QtyOnHand)as sum_qtyonhand

From Trans_B

group...