Viewing 15 posts - 24,751 through 24,765 (of 39,817 total)
wow, I've never expected a vacation for turning in notice. I'm surprised that valued employees would feel that way. Changes my definition of "valued"
March 16, 2009 at 11:32 am
This sounds like something that would be fun, reduce work load, reduce phone calls. Wouldn't you want to enjoy this and delete them one by one :D:w00t:
March 16, 2009 at 11:30 am
I might suspect that the services are not started then. You want to use SQL tools, not the Windows ones to work with SQL Server.
Moving to SQL 2005 Admin
March 16, 2009 at 11:30 am
I might suspect that the services are not started then. You want to use SQL tools, not the Windows ones to work with SQL Server.
Moving to SQL 2005 Admin
March 16, 2009 at 11:30 am
I think SQL is a flat file database for the engine. Extents, pages, they're laid out like a flat file. Every flat file has some level of meta-data in it,...
March 16, 2009 at 11:28 am
Crazy, if you're getting that many, fire up Profiler and get a check on what might be kicking it off. I haven't heard of this happening, but you never know.
March 16, 2009 at 11:23 am
You should not need to on a detach/attach type move, but you never know. When the files are copied, it's possible they get more fragmented, and a rebuild might clean...
March 16, 2009 at 11:21 am
Lots of MVPs are highly technical and tend to have a high opinion of their own work and opinions. Some of that comes with the territory of being very smart....
March 16, 2009 at 11:21 am
Run it as a print and please post that.
March 16, 2009 at 9:30 am
I think a program could do the job, but not by just installing and click "next". A person that undestands the data and relationships should be able to map fields...
March 16, 2009 at 9:16 am
you are welcome and thanks for the update. Glad it worked for you.
March 16, 2009 at 9:13 am
I have updated the script with code from Farhan as well.
March 16, 2009 at 9:11 am
Glad you saved the bike :P, and heal soon.
I think IT overall is a bit of a frontier. It's maturing, but it's still not as mature as many other industries.
That...
March 16, 2009 at 9:10 am
I declared the other variables, and then ran your code and it worked fine.
I suspect you're getting this error on an exec(@sql), correct? Please include the code that's the problem.
Instead...
March 16, 2009 at 8:59 am
Viewing 15 posts - 24,751 through 24,765 (of 39,817 total)