Thanks for pointer to SSIS - will have to look into it, I do admit I know anything about it.

Sturner - yes I do have access to VS2005, and would...

Hello Gail thanks for the response

>> Sounds like a good candidate for transactional replication.

If I understand the help file correctly, that would assume the servers are connected. This is not...

Sorry, yet another follow up.

I was just going to test this on my local server to see if I could create a copy using the code you provided and I...

Thanks Greg will give that a shot

Thanks JLK,

Wondering if I could as a follow-up.

I assume the client would have default folders to put there database and log files, is there a function that I can use...

Em: Thanks for the input, good to know it's not a huge no-no to use UDFs. FWIW, I almost always use Active/Inactive fields dates when I need to know WHEN...

Hello Andy,

Thanks for your reply. Unfortunately I don't. I'm actualy working on test data off-site and only have enough room for 1 set ;-). I do suppose you could be...

Hello Gail,

Things aren't going as expected 🙁 I had created the script below to run through all the tables, get the varchar fields and trim them. After running teh...

Thanks again. FWIW, the reason I kept on about Table variable was because most stuff I was reading said to use them as your first choice if you could, then...

Hello Ninja

Thanks again for your response. Since you are using a temp table in one and a cursor in another, I'll take it to mean I cannot use a table...

Heya Ninja

Thanks for your response, as I had mentioned, there are probably better ways to do what I want but I am trying to get the hang of what I...

Heya Gail,

Ah.. makes sense about the trailing spaces. Might see about writing some code to see if I can get that done

Thanks!

Heya Lowell,

I assume you meant DBCC DBREINDEX and I used a script to reindex all tables and now the the MDF file size is 35gig 🙁

Am I missing something, still...

Thanks wangkhar, that did in fact help

Thanks for the response, I will talk to my client about limiting what the user can filter to give use that option but I don't think that will fly for...