You can uses DTS to copy them,or you can generate the scripts on one database and then execute them on another.

Gregory Larsen, DBA

If you looking for SQL Server Examples check...

This might work for you:

create table #t (week int, store int, price money)

insert into #t values (1 , 183, .95)

insert into #t values...

You can use code like this to return a variable from sp_executesql.

declare @strstor_id int

set @strstor_id = 6380

declare @strDatabaseName varchar(10)

set @strDatabaseName = 'pubs'

declare @cnt int

Select @cnt=Count(*) from pubs.dbo.stores v WHERE v.stor_ID...

If you built a script for the first set of changes then you are home free, execute it against the second database. I'm guessing you don't have a script.

You...

One thing you need to be careful about is DTS packages. If you have the 2000 client you can build and execute packages just fine as long as you...

Sending mail using xp_sendmail via QA does not use SQLSERVERAGENT mail, it use MSSQLSERVER mail.

Do you have the some account running SQLSERVERAGENT service as you have MSSQLSERVER?

Gregory Larsen, DBA

If you...

Glad to see my code worked for you.

Gregory Larsen, DBA

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

No it does not. But you can use schema_ver and crdate in sysobjects to build something that will track changes.

Gregory Larsen, DBA

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

Here is a method also ugle, but I commented the code:

declare @n decimal(18,10)

declare @c char(100)

set @n = 0.011690000000

select

-- get the part before the decimal point

substring(cast(@n as varchar(18)),1,charindex('.',cast(@n as varchar(18))))...

Thats what I thought. About going the wrong way I agree, but here is the puzzle I am trying to solve.

I have a slow running query. Granted...

You will need to identify what the blocking SPID is actually locking. Once this is identified, you will need to determine who change process to not lock required resource...

Transaction logs help if your database is update during the day, and you want to a restore to a specific time of day in the event you have some kind...

Try something like this:

declare @line varchar(100)

set @line = 'this is the first line' + char(13) + 'this is the second line'

select @line

-- replace line feed with space

select replace (@line,char(13),' ')

Gregory...

To get the who changed the table, view, sp, etc. are you getting this information from the T-Log, or some other source?

Gregory Larsen, DBA

If you looking for SQL Server...

Have you tried to change the attachment method to "AddAttachment"? From prior posts looks like it was suggested that this was the method to use for cdosys. The...