Most of the content is copyrighted so you will have to purchase the resources you require from places such as Amazon.

There is no official MS Press book for 70-450, but...

You probably already know this but, as you have done select * in the query, it needs to return all the other columns along with the postal code. To...

there is no query, use SSMS, connect to server, expand database, expand tables, right click table, hover over script table as, click new query window

What is your RTO, RPO, once you know that information you can then decide on the best HA/DR method to take.

sqlfriends (5/22/2012)

---

I need to rename a reporting server which is installed SQL server 2008 R2 , both database and reporting service is on the same server.

Now after we rename the...

script the table using the script table as function when you right click the table

what are the requirements?

is it an object which exists on ServerA and you need to script it to move it to ServerB? If so right click the object and...

I've just done a quick test, 2 data sets, one based on the sample data given as a data set, and another as a proc based on the data in...

george sibbald (5/22/2012)

---

whats the recovery mode of the database?

For mirroring it needs to be in full recovery mode, for log shipping bulk or full recovery, else the features (not futures...

if it is SSRS, it could be custom code within a report, the unattended execution account, a data source, a subscription which keeps firing, an app which utilises the reportviewer.aspx...

easy, just set @sql = to what you want it to do then execute it like this

declare @sql nvarchar(max)

set @sql = 'exec master.dbo.xp_cmdshell ''rmdir "c:\tempo_SGCTLOCAL\"'', no_output'

exec (@sql)

set @sql = 'exec...

Well firstly I would get up to speed with SSRS, use Google, use the Stairways on this site to get up to speed, then start to look at what you...

Google is your friend

http://www.mssqltips.com/sqlservertip/1361/building-a-dashboard-in-sql-server-reporting-services/

not nessesarily, it could just be a invalid char to which there is no local code page varient for and it displays a box to show you something is there....

you could query the definition of the object in sys.sql_module in the databases and then query sysjobsteps in msdb where the definition or job step is like the linked server...