there's no easy button or magic function that you can use to fix your issue without any work on your part, sorry.

As Jeff already identified, you'll have to fix all...

can you add a CLR?

Elliot Whitlow, a contributor here, has a very nice CLR project for file manipulation;

http://nclsqlclrfile.codeplex.com/

the code example like this works great, you cna see how you could...

twdavis-893252 (3/5/2012)

---

I have 4 transaction tables that I wish to delete all the rows that have a date/time stamp of 12/31/2010 or less. Each table is about 60gigs before I...

what he meant was your SSIS in 2012 can connect to any SQL 2000 instance, and thus do the database migration.

no need to use DTS and then SSIS if SSIS...

sqlfriends (3/2/2012)

---

Further experience on the production server, I found if I run the sql statement to change the file size, then I open ssms, it changed there, even I don't...

also, these two extended procs examples might help.

one tells you who belongs to a group, the other can tell you all the groups i belong to:

EXEC master..xp_logininfo

@acctname...

size will not change until you stop and restart the server.

at that time tempdb , since it will be recreated, will change to 10G instead of it's current size.

I don't...

yeah, as we explained above, if you are running an EXPRESS version, NO MATTER...

also, look at my forum post here:

Reverse Engineer DatabaseMail Settings

where i answered my own question with a TSQL script;

note the core issue is the CREDENTIAL for the SMTP user ;...

i think this is going to get what you are after; i'm returning true/false based on the value of the first 4 bytes; with that i think you can see...

how about a calculated , persisted column using either a hash or binary checksum, and a unique constraint on that? that gets rid of triggers and is self maintaining.

ALTER TABLE...

--#################################################################################################

--Begin Event definitions

--#################################################################################################

exec sp_trace_setevent @traceidout,114,1,@on --Audit Schema Object Access Event,TextData

exec sp_trace_setevent @traceidout,114,3,@on --Audit Schema Object Access Event,DatabaseID

exec sp_trace_setevent @traceidout,114,8,@on...

another possibility could be that the linked servers on DEV and LIVE have the same names, but different definitions.

it's not obvious, but you can create a linked server with any...

does the select statement i'm providing produce the list of items that would need to be updated;

you didn't mention the actual table naem to be updated...you'll need to change that.

it...

here's just one way to do it;

this strips out every char that is a-z,A-Z and 0-9, leaving, i assume, what would be the word separators, like space, dash, comma,...