it's just a simple update...

UPDATE MyTable

Set MyDateColumn = NULL

WHERE MyDateColumn ='1900-01-01'

you mean when a database is attached, right? or do you mean when a database is...

ColumnList was a placeholder for multiple columns, not just a single one;

I would image that table has half a dizen NOT NULL columns.

you'll have to sp_help it, understand it's structure,...

here's one fast way: to use this code, you HAVE to knwo what table, and which columns you are going to insert.

insert into TargetTable(ColumnList)

SELECT

TOP 400000

ColumnList

FROM TargetTable

CROSS JOIN sys.columns...

wow you guys posted a lot of stuff while i tested my script;

when i thought i was posting, there were...

how did you test that? did you grant anything to, say a public or other role the user might be in;

this worked perfectly fine for me:

--Create the Roles used to...

if the column you are searching is a char and not varchar, it might not truely end in LA;

try WHERE RTRIM(ColumnName) LIKE '%LA' instead

nope no way to prompt or alert, not without you creating an application to do that for you.

SSMS executes code, and presents the results...that's the typical applicaiton you might use.

based...

It sounds like you were looping through every stored proc name;

if the role is going to have EXECUTE priviledges on all procs, without exception, i think you can simply do...

well, it really on if (and how) you've set up your proc to return success or failure;

you know a proc can return results in any and all of three different...

convert the date right away to time, and then you are working with hours from 0 to 23:59:59;

so when you round the TIMe, it's between 0 and 23:

--returns 10 AS...

rebuilding indexes wth sort in tempdb, maybe?

Ok if you can connect via SSMS from the 2005 machine to the 2008 Express, you can create a linked server;

change the server name belwo, and tell me if...

there are a lot of variables in there...

for example, by default, SQL Express does not allow remote connections...it has to be explicitly enabled.

can you connect via SSMS from the Other...

for #3, a Windows machine that is logged in will pass the token related to the user to the SQL server.

the token has the built in assumption that if...