Here is a sample script

•Modify and execute the sql below on the publisher to create the subscription

exec sp_addsubscription @publication = N'<publication name', @subscriber = N'<instance>', @destination_db = N'<destination...

For some reason you need to initialize transactional replication using a sql script, there is no way to do it via SSMS. Also, when you created your publication, did...

I haven't had to do this in a while, but you can restore your 2005 msdb onto your 2008 sql server overtop the one currently there. Once you do...

Try this article, it worked for me

http://deepakrangarajan.blogspot.com/2008/01/forgot-sa-password-in-sql-server-2005.html

several of your databases are set to auto grow the data file in increments of 1mb. I wouldn't use that setting for any database, i prefer to use percentages,...

that's what i thought, thanks for confirming that for me.

that resolved the issue, thanks again for your assistance:-D

I set the memory to a hard amount and had our network team grant the locking pages to the sql account. I will follow-up with the results

Thanks Again!!

Chris

I haven't but there are only 2 instances of sql and they are each running on opposite sides of the cluster so I don't think they would have a negative...

Yes it can be done.

Create a variable as object type

Create an ADO.Net connection to your database

Use an Execute SQL Task - Set the connection type to ADO.Net - Set result...

Just to clarify, are you saying you want to pull the fileids from a table and then use them as the parameter in your query inside the for each loop?

Thanks for the response:)

I am running the package from within the step as a package. I have setup this job to fail on purpose just to test the error...

You can double click on the connector after your Execute SQL task and change the "Evaluation operation" value to Expression from Constraint and then add an expression like @[User:: ]!=...

I am just trying to pass a parameter into the data flow to be used in a query to gather data.  For example.

select name from master.dbo.sysdatabases where name = ?

I...

I found a function that can be used to look up info about the instance, including the info I am looking for.  The info is posted below.

SERVERPROPERTY

Display information about the server...