Hi, The SQL Server 2008 Management Studio "Connect to Database Engine" login form has a dropdown box that keeps the history of Server name & Logins...
Hi, Is it possible to use Business Intelligence Designer Studio from SQL Server 2008 to design a SSIS package that will be executed on a SQL Server...
Please ignore. Iconnected to SQL Management Studio with a low privilege user account.Just reconnected with SA account and all options are visible.
Hi, I would like to schedule a job to execute a SSIS package. But the drop down of the New Job Step windows doesn't display the item "SQL Server...
OK, that sounds much more logical. Thanks you for the clarification.
Hi, Excerpted from SQL2K Help "If CASCADE is specified, the row is updated in the referencing table if that row is updated in the parent table. If...
Thank you very much for your help.
There is no BEGIN TRAN surrounding the creation & insert in the temp tables. Thanks for your answer for Q2, now this is a serious reason not to abuse...
Hi, A stored procedure mySlowProc performs a complicate SELECT. It creates 10 temporary tables either by SELECT ... INTO #Table1 or by doing CREATE...
Hi, Can you please help e to better understand locks which are caused by SELECT. Scenario 1: Long lasting query. Let's assume the client code call...
Confirmed, After installing SQL Server 2005 SP2 Cumulative Update #5. I can now use Management Studio 2005 to connect to SQL Server 2008. Thanks for...
Thanks, let's see if Cumulative Update 5 fixes the issue.
Hi, I'd like to connect to SQL Server 2008 CTP Nov 07 using Management Studio 2005 (SP5 + Cumulative Update 4). I got an error message "This version...
Hi, In the "Connect to a Database Engine" form which prompts for login information. Any new server name input in the "Server name" box got...
Thanks for your help. I am going to give this a try.
Hi, Can I install SQL Server 2005 and keep SQL Server 2000 at the same time? Or will SS2005 replace SQL2K? If SS2005 replaces SQL2K (on my laptop),...
Thanks very much Satya for your advice. Can you please help me to clarify: Q1. What is the advantages Log Shipping over Replication? In other words,...
Hi, Can you please advise a good strategy for a backup SQL2K Server? Scenario: ServerA is the production DB server. ServerB is the standby server...
Yes of course. I was just wondering if there is a way to set Fill Factor to 0%. It just seems weird that an option cannot be undone.
Recovery model = full. The transaction log (LDF) is currently 1 MB on the hard disk.
Separate names with a comma.
