The location window will NOT show Mapped drives as above post said

You have to either

1. use T-SQL to backup to UNC path

BACKUP DATABASE [db] TO DISK = '\\Server\Share\db.bak'

2. Add the...

You can also go into SQL Server Agent -> Jobs

Select All (ctrl-A), right-click, "Script Jobs as" -> CREATE TO .... a new Query window (or File)

Then you run the script...

A good article today

How do I assign permissions to users to see SQL Agent Jobs?

I'm using SSMS 2008, it came with a lot of Standard Reports

but if I try to open Custom Report, it looks under "My Documents"

but I am shocked search for *.rdl...

Interesting, did not know this behaviour, now I know

OP, you could try shorten the column after the replace

Execute sp_help #TestReplace;

Column_nameTypeComputedLength

replacedColumnvarcharno8000

alter table #TestReplace

alter column replacedColumn varchar(500)

Execute sp_help #TestReplace;

Column_nameTypeComputedLength

replacedColumnvarcharno500

For Linked Server, you can use Impersonate Login or Mapped Login

so for 70-431 exam, they have couple questions

If you want to only give login App1 on Server1 to Server2

You create...

I am using SSMS 2008 GUI, I see "Start Job at Step..." for both SQL 2008, 2005 SP1, 2005 SP2 servers, so looks like it's in the GUI side

However, it...

It's still 1 row per SUBPLAN, and 1 row per PLAN

SELECT TOP 500 *

FROM [msdb].[dbo].[sysmaintplan_subplans] SS

inner join msdb.dbo.sysmaintplan_plans SP ON SS.plan_id = SP.id

Didn't find too...

Perhaps that is why in SQL2005 and later it separates the USER from the SCHEMA

so an AD group will own objects via the SCHEMA, and you can modify users/schema without...

I guessed wrong (1024), such a natural number.... 😛

It's really a trivia. no Google beforehand

I still remember the discussion about max # of nonclustered indexes (which is 249), and how...

If you are looking for all XML columns in a database

SELECT * FROM INFORMATION_SCHEMA.COLUMNS

WHERE DATA_TYPE = 'XML'

This is the result from my AdventureWorks2008 DB

Is full-text search an option?

I don't know anyway around how to escape/preserve the special characters in XML, since they indeed are SPECIAL

like &, , etc...

http://www.xml.com/pub/a/2001/01/31/qanda.html

Someone asked this question on StackOverflow (Google)

http://stackoverflow.com/questions/270948/how-to-preserve-an-ampersand-while-using-for-xml-path-on-sql-2005

Follow the Log Shipping wizard (right click on the DB, Properties or Tasks)

In summary

you have to take the backup of the DB from Primary, restore it on Secondary server in...

Just hit Ctrl-N in my SSMS 2008, opened a new query window for me

Ctrl-O opens the Open File window

Go into Tools -> Options -> Environment -> Keyboard

to see if you...