From SSMS, I am getting the generic error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005,...
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...
satya, The two instances are on 2 separate servers on the same network. I want to kick off the ssis package which moves data on one instance to data...
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...
Thanks, Frank. That's exactly what I needed. Jethro
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?...
Luis, I have collected historical performance data on *.csv files and I am trying to review them using the performance monitor. I captured a bunch...
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...
madhu, Is there anyway to define what the default instance is for a particular session? In Oracle, there is a environment variable ORACLE_SID that...
Thanks Luis and Madhu. I didn't think there was any SQL Server counterpart to Oracle RAC. Does anyone know if SQL Server 2008 has any new features...
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...
Thanks to everyone for their quick and helpful responses. They are much appreciated. Jethro
Separate names with a comma.
