create the parameter at the dashboard level, then in each subreports properties pass in the parameter to run the report.

the sub report data sets and/or reports will need changing also...

two ways

add a clean up maintenance plans task and give it a number of days to keep

or

in the back up database task on the options menu enable remove files older...

I dont believe you can change the display name, you can change the email address its from in 2008 by using the @from_address parameter, but I'm sure it takes display...

stevefromOZ (3/13/2012)

---

In debug you'll want to run in 32b mode. In prod, where you dont interactively run BIDS to execute the package, you'll probably want the driver/s running in 64....

the following link http://msdn.microsoft.com/en-us/library/ms175106.aspx contains all the objects that are used in logshipping, you should be able to create a query to your needs by selecting from these.

you would need to create a batch file which calls SQLCMD passing in the .sql file and then run the batch file, the only way in SSMS is to press...

as another one on this, single user does exactly what it says allows 1 person access to the DB, if that is to much then you could set the database...

please take a moment to read the first link in my signature block on posting T-SQL

as this is fairly a small task i have knocked this up

create table #temp (col1...

are you moving a SQL2000 master database to a SQL2008 server? or is it going 2000 to 2000?

what is your goal in moving the master database? is it to...

Also to add on from Lynn you could use the convert function which does the same job as cast

First column: CONVERT(VARCHAR(10), SUBSTRING(col1,1,10))

Second column: CONVERT(VARCHAR(64), col2)

Jeff Moden (3/13/2012)

---

anthony.green (3/12/2012)

---

you might want to take a look at full text indexing and the contains function then, otherwise you will be wrapping the variable in a multiple of...

i would suggest creating a profile trace which looks at the text data of all connections for the following strings

ALTER DATABASE nameofyourdatabase SET RECOVERY FULL

or

ALTER DATABASE nameofyourdatabase SET RECOVERY SIMPLE

that...

if you have enterprise edition you can do a scale out deployment where you have multiple hosts acting as SSRS front ends which will give load balancing and HA if...

if you want to run two instances one on each node then you need two virtual names SQL01\INSTANCE01 and SQL02\INSTANCE02 for example, then if they are resources in the...

the drive sizes are ok as long as they are big enough to factor in growth, so you dont want to put in a db now which will grow to...