Viewing 15 posts - 3,676 through 3,690 (of 5,588 total)
I believe that the document is pretty clear... an in place update of a Windows Server 2003 cluster / sql 2005 cluster to Windows Server 2008 cluster / SQL 2008...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 9, 2010 at 7:50 pm
I don't see an issue with it. Why do you think there is one?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 9, 2010 at 7:45 pm
If you want help, you need to put your data into INSERT statements. I've already pointed you to the article for how to do this, so why don't you help...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 9, 2010 at 5:15 pm
gmamata7 (8/7/2010)
We have 2 node active/passive cluster set up for SQL Server 2005 x64 with SP3 on Windows 2003 x64 with SP2.
Now we want to first perform in-place upgrade for...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 9, 2010 at 5:03 pm
Sounds like you need a table of tasks, and email address of person assigned to each task. Then the package just utilizes this table to send emails out. All you...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 8, 2010 at 11:58 am
Tara-1044200 (8/8/2010)
could you help me to update in batches please.
Try this link
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 8, 2010 at 9:24 am
Tara-1044200 (8/8/2010)
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 8, 2010 at 7:04 am
IF OBJECT_ID('tempdb..#TestTable') IS NOT NULL DROP TABLE #TestTable;
CREATE TABLE #TestTable (TableName sysname, Qty int);
execute sp_msforeachtable 'insert into #TestTable select ''?'', count(*) from ? where date_modified >= DATEADD(DAY, DATEDIFF(DAY, 0, CURRENT_TIMESTAMP)-2,...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 7, 2010 at 7:13 pm
Ron has already asked you this...
You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 7, 2010 at 7:08 pm
Okay, this time I'm going to insist.
You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE,...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 7, 2010 at 7:04 pm
That being said, I think that this will work. Since there is no test data to test against, all the testing of this code is up to you.
UPDATE ME
...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 7, 2010 at 6:59 pm
You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 7, 2010 at 6:49 pm
CirquedeSQLeil (8/6/2010)
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 6, 2010 at 6:36 pm
Check out the articles in my signature on Cross-Tabs / Pivot tables, Part 1 and 2. Part 2 delves into dynamic solutions, which sounds like what you would need.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 6, 2010 at 9:22 am
You might want to try http://www.ssmstoolspack.com
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 5, 2010 at 8:10 pm
Viewing 15 posts - 3,676 through 3,690 (of 5,588 total)