without the install disk, it's not possible; you'll have to find the disk.

from there, it's pretty easy:

backup the existing encryption key right away, before you do anything else.

you need...

well, here's an example of how to generate 52452 integers based on your existing data;

you'd probably want to plug that into a formula that calculates latitide increments for every 25...

not sure if this helps at all, but i have a similar situation.

would mapping a network drive featuring specific username/password help?

exec master.dbo.xp_cmdshell 'NET USE J: \\DEV223\c$\Data /user:mydomain\lowell NotMyRealPassword /persistent:yes'

i've got...

not directly like that.

you have to switch to dynamic SQL to convert value s(ie a column value) to the metadata of an object name

your query qould create this code, is...

i still have my SQL 2000 scripts saved, although i don't play with 2000 any more.

there's some server functions DATABASEPROPERTY and DATABASEPROPERTYEX that can pull the values you want ,...

Matt J (6/2/2014)

I'm writing a view to check record counts in a table that has numerous datasets and therefore various "Activity Dates". Is it possible as part of the SQL...

change your thought process: the end user never tells YOU what the purchase order number is.

a user requests a new purchase order number, and you assign it.

that purchase order number...

what is the actual reason you cannot simply use the new password, or set the password yet again?

it seems kind of strange you think you need to restore it, maybe...

yes i believe that's about all you can do.

the password is stored in a credential, which you can partially review in master.sys.credentials.

It is not possible to script(even in a hashed...

Thanks for the feedback Charles! It still gives me that warm feeling of a job well done when someone says i helped them.

I think this one has been a script...

where did the 1449 come from? is it just your arbitrary starting point?

it doesn't exist or seem to be calculate-able from what you posted.

is the 2008/ portion going to come...

yeah the last time i had to fiddle with that situation, I had to edit any procedures which happen to also use temp tables;

i reviewed any joins and WHERE statements...

yes it will work.

you might run into some issues in cross database queries , and maybe some queries that spool to tempdb, but you can easily keep your old databases...

collation is saved on a per-column basis...if you copy a database, the collation of individual columns stays at whatever it was, regardless of whether you change the Server or database...

something like this help a little?

ORDER BY

CASE

WHEN datepart(mm,startdate) = 7

AND datepart(dd,startdate) = 1

THEN 1

ELSE 99

END