no triggers. Current type is int, null changing to varchar(66), null

Thanks. I basically had it just wasn't casting the text field as varchar(max) so was having issues with the LEN -1. But also ended up using your code with...

Thanks. I was very close, actually changed to that code as I didn't allow if there was no tab after. Plus I basically had it right in my...

Getting errors that the ta.team could not be bound. Here is a quick example of what I need.

Edit: Sorry I will read article I missed that part...

That works great. I had never seen that function scipt before. I just had to then create a script to catch the firstname , lastname and...

Yep ran query and have 10db in 100 3 in 90 and 1 in 80 mode. I will exclude that DB for now until I find out if it...

Thanks, I like the read, read/write solution as the old DB are for reporting only so no writes. I will work on getting this up and working.....

How many groups is the windows account a member of. I have had this issue when passing Active Directory accounts with a lot of group memberships. The...

One new note. Found that if I add a space after the servername when trying to login to the domain that the services are not started with I can...

I like the idea.. But the sure number of pc's not to include the number of possible regions, then departments within that regions would make it extremely time consuming to...

I will check it out in the morning. Thanks