Thanks for the quick reply. I agree XML is difficult to navigate through. I was looking at the loop and time this would take and decided to go...

I am now running into the next issue. I would like to modify an attribute within the xml. I was looking online and since we are treating this...

In the block above what does the WITH do? Is it creating a work table or something? Is there a cost to having the with statement. The...

It looks like it was the VMware doing the backup somehow. I am not sure how the 3rd party software is trying to backup my local DBs. I...

I went into my local current log and found this

Date12/18/2013 8:54:41 AM

LogSQL Server (Current - 12/18/2013 10:43:00 AM)

SourceBackup

Message

Database backed up. Database: USINITIAL_752, creation date(time): 2013/12/17(13:44:49), pages dumped: 20402, first LSN:...

I would think that is possible, but I know my machine does not have any backup stuff beyond iron mountain. That strictly backs up my document directory. This...

Yes it shows that it is being backed up but not to a physical location. Instead I get something like this

{1E63C7F9-E947-42C9-8733-8C166C58B9C4}9

Where as when I have actually backed the db...

I was trying not to run a trace but yes I may have to. No one has peeped up saying they did it.

Hey sorry about the confusion. I must have been doing something differently that was not working. I tried this again today and it worked. Thanks

I did find that one in searching

EXECUTE sp_msforeachtable @command1="Print 'Test'", @Command2 ="ALTER TABLE Foo.tblFoo WITH CHECK CHECK CONSTRAINT all"

Am I doing something incorrectly because it seems to have no...

Charles - Thanks for the reply. That is exactly what I did. Made a sproc that reads the tables data and scripts it for CE but it is...

Great so I am not totally crazy. I thought it was very strange that I can even fill the TVP in 2005 compatibility. It has to do with...

That got me to the right spot with that link

Declare @datadir nvarchar(4000)

,@logdir nvarchar(4000)

EXEC master.dbo.xp_instance_regread

N'HKEY_LOCAL_MACHINE'

, N'Software\Microsoft\MSSQLServer\MSSQLServer'

, N'DefaultData'

, @datadir output;

IF @datadir IS NULL

BEGIN

EXEC master.dbo.xp_instance_regread

N'HKEY_LOCAL_MACHINE'

, N'Software\Microsoft\MSSQLServer\Setup'

, N'SQLDataRoot'

, @datadir output;

END

EXEC master.dbo.xp_instance_regread

N'HKEY_LOCAL_MACHINE'

,...

I apologize - I must have killed the session after the update the first time. So I still had a transaction open. If I run the select in...

So I can take that as when you apply a hint it is going to lock that table whether it is Tablock or TablockX while the update is going and...