Yes please watch out. I have learned my hardway. Thanks noeld

you are also assuming that log file name is <Database name>_log and also every database has 1 log file.

oops I read wrong. I thought you need to shrink the log files name like DMRT_ or name like DMRT_ or SRC_ or STG_.

Note: _ is a special character you...

try using exec  sp_MSforeachdatabase or you can use loop to shrink the file.

to get log files

SELECT * FROM sysfiles

WHERE GroupId=0 AND (Name like '%SRC__%' Escape '_'  or like '%STG__%'...

UPDATE Feed1

SET subdistrict = Zips.subdistrict,

city = Zips.city , state = Zips.state

FROM Feed1 JOIN Zips

ON Feed1.zip=Zips.Zip

AND (

Feed1.subdistrict<>Zips.subdistrict

OR

Feed1.city<>Zips.city OR

Feed1.state <>Zips.state

)

thanks for the reply but it will drop the constraints. I just want to disable for not for replication. We can write scripts to do that (some what similar)  but...

see if xp_cmdshell can help you.

I hope this is what you are looking.

CREATE TABLE VendorTable

(

AllFeatureCode VARCHAR(1000)

)

CREATE TABLE LookUpTable

(

FeatureCode VARCHAR(10) ,

Feature_Description VARCHAR(100)

)

INSERT INTO VendorTable

VALUES ('A04,A01,A02')

INSERT INTO VendorTable

VALUES ('A03,A01,A02')

INSERT INTO VendorTable

VALUES ('A04,A03,A02')

INSERT INTO VendorTable

VALUES ('A03,A01,A02')

INSERT INTO...

it is possible in tsql. if I understood your question

For logins  You can scripts them (using Query Analyser) this will eliminate Orphaned Users section

There is no such function available (to the best of my knowledge) . You will be required to write one.

SELECT * FROM Table1 A

JOIN Table1 B ON A.Type<>B.Type

AND A.Type = 'Subject'

SELECT * FROM Table1 A

JOIN Table1 B ON B.Type='Percentile'

AND A.Type = 'Subject'

You can do in other ways also

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthnextrec.asp

if this does not work. Google on nextrecordset

Can you explain as what result set you are looking. I assume you need some kind of cross join.

This will generate 2 recordsset. In ADO we can use NextRecordset. Refer http://msdn.microsoft.com/library/default.asp?url=/library/en-s/ado270/htm/mdmthnextrecx.asp

I hope this helps