John is correct here, the logging is the same.

Actually, the logs written are always the same, regardless of recovery model. What differs is how long the log records are retained,...

It completely depends on your path. I would guess 2012, but you'd have to test it.

http://www.amazon.com/Securing-SQL-Server-Protecting-Attackers/dp/1597496251/ref=sr_1_1?ie=UTF8&qid=1330464136&sr=8-1

Might watch out for this: http://blog.trivadis.com/b/nicolasmueggler/archive/2008/01/17/installing-sql-server-2005-after-visual-studio-2008.aspx

VS2008 has some SQL components in there to work with SQL Server instances, and those are rev'd after the SQL Server 2005 components.

If you right click SSMS in the menu and select properties, you will see the shortcut it refers to.

It is still "ssms.exe"

Is this native SQL Server backup, or a third party backup?

Is it local, or to a remote drive or share?

http://msdn.microsoft.com/en-us/library/ms189315.aspx

You should be able to see the linked servers listed in Management Studio for all instances. As for searching across them all, you have to connect to each and then...

It's a little hard to understand what is wrong since you haven't formatted things well. Do you mean that if you run this:

raiserror 22004 'This is a test'

You get...

An update statement doesn't have a select. It should be like:

update a

set a.column = a.column + 1

from Table1 a

inner join table2 b

...

Exactly what Brandie wrote.

dshaddock (2/28/2012)

---

I was curious about Hadoop, and that let me to Cassandra and DataStax and tutorials and forums--and near the end of my search I still didn't really understand whether...

He knows enough to post questions online....

I've done something similar to Gus, but I've usually then had an ETL process or replication that copied the information off to the other databases. The reason for me has...

charindex (http://msdn.microsoft.com/en-us/library/ms186323.aspx) or patindex (http://msdn.microsoft.com/en-us/library/ms188395.aspx) work well for finding places of patterns in a string.

Then substring (http://msdn.microsoft.com/en-us/library/ms187748.aspx), as Gus as done, to strip out items.