Viewing 15 posts - 25,546 through 25,560 (of 39,921 total)
January 18, 2009 at 9:17 am
There are lots of scripts on this site (See the scripts link on the left) that you can moidfy.
January 18, 2009 at 9:17 am
I hadn't thought about the repetitive motion thing. I guess long term it could be, but for presentations, they're an hour or two. I wish I could have swiped at...
January 18, 2009 at 9:15 am
It's not quite clear what you are doing here, or how you want to use this. We also like to see you do some work, show some effort in T-sQL...
January 18, 2009 at 9:14 am
T-SQL doesn't have a way to do a conneciton. You can use T-SQL to set up a Linked server, which then you can query through, but you can't open directly...
January 18, 2009 at 9:12 am
I stumbled on this one last week: http://www.devx.com/dbzone/Article/40531
Once you restore to a 2008 instance, no matter where the backup is from, the structure changes. Therefore you cannot back it up...
January 18, 2009 at 9:09 am
db_datawriter would give them insert (and update/delete) permissions. Check all the groups, look for DENY as ADI mentioned, and let us know which roles the user is a member of.
January 18, 2009 at 9:07 am
As Perry mentioned, you can have multiple instances and an upgrade will target one. Someone would have targeted one and the others would remain untouched. That's the idea of instances,...
January 18, 2009 at 9:06 am
There's still an Informix building here in Denver, pass it at times. It's supposed to be a great DW engine.
January 18, 2009 at 9:04 am
January 18, 2009 at 9:03 am
Sue moved over to PM'ing full time, not really much SQL Server last year. I actually was thinking to send her an email and see how she was doing as...
January 18, 2009 at 9:00 am
The typo is being fixed.
The developer's edition is Enterprise with different licensing. It includes all features so you can build applications with them. Developer's Edition cannot be deployed to a...
January 18, 2009 at 8:53 am
We rerun the best articles at times to ensure that people see them. There's no good way to republish the comments.
There's a bug on the article page that doesn't show...
January 16, 2009 at 11:10 am
You need a script to do this. Lots here on the site in the scripts section.
January 16, 2009 at 10:54 am
Viewing 15 posts - 25,546 through 25,560 (of 39,921 total)