Tom.Thomson (8/1/2011)

---

Kenneth Fisher-475792 (7/29/2011)

---

Same goes for 1 processor working. Technically I should have said "RTM installs fail on an odd number of logical or physical processers, unless its a...

Very interesting question. I am curious why you would need to look for a char(0) though. Is it some type of transmission error? Or is it something...

First, I would like to say that as it said in the question, this was during a DR test.

I've never used a "slipstreamed" install before, and if it...

The facet is "Server". Also don't forget that when you set your expression to a query it has to return a true\false. The example in my book uses...

Chrissy321 (7/24/2011)

---

INSERT INTO Transactions_Audit

SELECT Field1, etc....,getdate() AS AuditTimeStamp

FROM LinkedServer.LinkedServerDatabase.dbo.Transactions

WHERE

Field1 = 'This' AND

Field2 <> 'That' AND

(Field3 = This OR Field4 = 'That' AND....

UPDATE LinkedServer.LinkedServerDatabase.dbo.Transactions

SET MyFlag = 1

WHERE

Field1 =...

jshurak (7/25/2011)

---

Bumping an old thread.

I've a test system that I'm attempting to get this working on. I've set up my condition as follows:

Facet:Database

@IsSystemObject = False

AND

@status = Normal

If I evaluate...

I have to say I got the question wrong, and I'm one of those people who thought the question had more to do with a unioned query pulling against the...

bopeavy (7/14/2011)

---

I thought you were talking more about restore. I have worked some where before where we had to do some consistent restoring. So i used xp_cmdshell dir to make...

If I understand what you are looking for correctly, eg "dbname_backup_yyyymmdd", then:

select 'dbname' + '_backup_' + replace(convert(varchar, GETDATE(),102),'.','')

If you want time as well, eg "dbname_backup_yyyymmddhhmmss", then:

select 'dbname' + '_backup_' +...

Honestly I think a "boot camp" would probably not work, since as stated before being a DBA is a fairly complicated prospect, even at a basic level. Not to...

mtassin (7/1/2011)

---

Congrats!

How difficult did it seem to you? My biggest concern having never sat a cert test is a self-criticism that tells me I don't know enough.... so I...

Congrats! I'm studying for my Administration test at the moment so I completely sympathize with the hard work.

Kenneth

Count...

praveen.gln1 (5/20/2011)

---

I am having linnked server A on server B.Am trying to fetch data by querying from Linked server A.

Select top 1 * from A.Test(database name).dbo.query(table name),when i executedthis...

SELECT CustomerID, CompanyName

FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'C:\Program Files\Microsoft Office\OFFICE11\SAMPLES\Northwind.mdb';

'admin';'',Customers)

GO

Sample from the help on openrowset.

You could also look...