you need to join sys.dm_db_index_physical_stats to sys.sysindexes

the below is what i use to get all the indexes in all databases which have more than 8 pages, more than 0%...

lots of good links on google, do a search for ssis 101 or ssis basics and take a play in BIDS, knock up a couple of packages and test them...

different ways to do it

you could as I said, copy the data from server 1 into server 2 and then do a update on server 2

or

you could use a data...

You could transfer the data from Server1 into a staging database on Server2, then write a stored proc which joins to the staging database and does the update.

can you zip and attach your shp and dbf files as I have only ever done maps by embedding the geo data as a spatial query passing a bing map...

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)