Viewing 15 posts - 1 through 15 (of 155 total)
Michael Earl (2/26/2009)
If you are using integration services, you may have some additional deployment issues and you have to switch to 64 bit drivers for connections.
Specifically as it relates to...
March 24, 2009 at 12:10 pm
Everything worked like a charm, thanks for the assistance.
February 10, 2009 at 10:51 am
Jonathan Kehayias (2/10/2009)
3) I've drilled down on the table in SSMS and I see no KEYS, no CONSTRAINTS, no TRIGGERS. Is there anything else I should be concerned with?...
February 10, 2009 at 9:00 am
This is a double-post. Please respond here:
http://www.sqlservercentral.com/Forums/Topic652712-338-1.aspx
February 9, 2009 at 5:55 am
This is a double-post. Please respond here:
http://www.sqlservercentral.com/Forums/Topic652712-338-1.aspx
February 9, 2009 at 5:54 am
This is a double-post. Please respond here:
http://www.sqlservercentral.com/Forums/Topic652701-146-1.aspx
February 9, 2009 at 5:49 am
This is a double-post. Please respond here:
http://www.sqlservercentral.com/Forums/Topic652701-146-1.aspx
February 9, 2009 at 5:48 am
Okay, but now we aren't even on the topic of the original post, so I don't want to hijack the thread. Bottom line of the original post as I...
February 7, 2009 at 10:02 am
Gift Peddie (2/7/2009)
you should know 2000 did not have a separate security section with the database. The separate security section within the database is new to 2005
Maybe I'm misunderstanding,...
February 7, 2009 at 9:44 am
Same. I've only been a DBA for just over a year (came from being a programmer - mainframe at that, lol), so I'm always trying to understand more and...
February 7, 2009 at 9:19 am
Yes users will be transferred. However, a db user is different from the login that user is mapped to. Just distinguishing between the two.
February 7, 2009 at 8:40 am
A restore of a *user* database will not restore the logins to the server, only the users of that user database, whether sql2005 or sql2000. The database users will...
February 7, 2009 at 8:17 am
You could certainly take a gander at index_physical_stats and index_usage_stats, for starters. It kind of depends on what kind of tuning you are trying to do. Are you...
February 7, 2009 at 7:58 am
Keep in mind in the future that TRUNCATE TABLE will reset the Identity property back to the seed. DELETE FROM TABLE will maintain the current Identity.
February 6, 2009 at 10:50 am
Viewing 15 posts - 1 through 15 (of 155 total)