While I can't think of any way of getting keywords through a query, the best way I have found to locate keywords is to use SQL Server Books Online.

Just...

Thanks Gail. I have taken your advice. I am setting up two virtual servers one for my SQL 2005 Servers and the Other will be for my SQL 2008 Servers....

The purpose of using Log Shipping is for DRS. I have recently took over the DBA position at my company and found that all SQL Servers have no redundancy.

All...

Good to know thanks guys for the insightfull information. Looks like I do have some planning to do. Since I am still working on only one database server so far,...

Yeah I kind of figured that. Unfortunately I only have licesening for SQL Server 2008. All my SQL 2005 Licenses are used.

As for upgrading the database: is that why...

I think you could go a few ways with this. One would be to create a sql plan that would write the query for you then use the FOR XML...

Yes most of them are. However if you would like a slim down version I would suggest the new SQL Server 2008 R2 express edition. They have changed the database...

I think that depends. If your test environment is stictly for development then I think you can use the developer edition. However if it is used for testing, QA, then...

Yeah we have encrypted email so I figured I would send and email after I ship out the drive. I work in a Hospital and after reading about someone loosing...

Thanks for the Advice. I will certainly do a test from that drive. As for them trying on test I am not really sure. I was given this task by...