I have installed SQL Server 2005 (sp2) on Windows 2003 on both 32 bit and 64 bit platforms. SSMS works fine with alias on the 32 bit platform but it...
Good morning everyone, SQL Server 2005 - I need to audit who performed security related operations (create login, grant server level roles, create...
I have a SSIS package that copies data from one table in SQL Server instance A to a table in SQL Server instance B. The two SQL Server instances (A...
I am trying to create a SSIS package to copy one table in SQL Server 2005 to another table in SQL Server 2005. Both table have the same column...
I recently restored a database from a backup provided by a vendor. I created a new user in this database and did nothing else to it (did not grant it...
What is the best way to audit a single user's activities for a single database within a SQL Server 2005 instance. There are over 100 databases in...
For discussion, I have the following setup: production: table a - column a, b, c table b - column r, s, t table...
In our production database, our developers have read access to the tables. They want to be able to review the custom stored procedure codes (those...
Does SQL Server rebuild/defrag indexes in the system databases internally as needed or should we set up something to do that for the system...
Is there a log that shows history of connection attempts to a SQL Server instance? Is there a log on the server side as well as on the client side?...
I've set up perfmon to log counters to a *.csv file. When I use perfmon to look at historical logs, I cannot add certain counters. I open the file...
I have 2 questions: 1) If I have both SQL Server 2000 and SQL Server 2005 clients installed on the same server, how do I make it so I can be using...
I'm trying to see if there is a SQL Server counterpart to Oracle's RAC configuration but couldn't find any. Oracle's RAC basically have multiple sets...
We will be upgrading some of our instances to SQL Server 2005 while the others will remain on SQL Server 2000. Is the SQL Server 2005 client fully...
We use a mix of Windows and SQL Server authentication in our instances. We have Windows groups and users in our instances with various accesses to...
I have heard that certain query formats that worked in SQL Server 2000 will not work in SQL Server 2005 (I don't even know what these might be but I...
Is there any way to manage what resource a users or a set of users can have within a SQL Server instance? For instance, cpu usage, execution time,...
What does it really mean that SQL Server 2000 is desupported (mainstream) on 4/8/2008? Does it mean if you have a new problem that hasn't been...
What is the best way to capture all the existing privileges of a database so that it can be recreated? I want to capture all the roles, users,...
I have one database in a SQL Server 7 (7.00.1077) instance that I want to move to a SQL Server 2005 instance. What are my options in getting this...
Separate names with a comma.
