Sunday, August 4, 2013

[SQL Server 2008 issues] Generate "One Merged Email" from any query result ran against multiple instances in CMS (Central Management server)

[SQL Server 2008 issues] Generate "One Merged Email" from any query result ran against multiple instances in CMS (Central Management server)

Generate "One Merged Email" from any query result ran against multiple instances in CMS (Central Management server)

Posted: 03 Aug 2013 05:01 PM PDT

Hello,We manage our instances via CMS. As a daily process, we ran a script against PROD group under CMS to check Last night backup and Job failures and many other things. We then place the output of those query result into excel sheet and then manually add colors to this excel and then send report to the group. It's been going on for a while. I like the fact that we use CMS for this info. But I would like to change this process now. I have created a script that ran against any "individual" server and generate a html good looking email with all the filtering we do in the excel. Now I am wondering if I can get this script to run against CMS server and generate one single email with all the data in it, then all our manual work on generating excel will be gone. It will save 90 minutes of our dedicated work everyday.Script is generating output in temp tables and from those temp tables, am filtering out the unwanted stuff and asking it to generate a email. Now the Issue is, when I ran it on CMS Server. It is sending me "individual mails" from "each individual servers" that are part of the CMS group. Resulting I am getting 90+ emails.Is there any way to send only "One Merged Email" with all the data in it, rather then individual emails from all the servers individually with the result of any query ran against CMS.I am not sure if this is possible. Since in sql query option there is a option for multiple server, over there by default "merge" has been set to true. That is how CMS generate all the result merge into a single result window.Is there any way to do this ? Please advice..Thanks!

passing date parameter in ssis 2008 at run time

Posted: 03 Aug 2013 12:13 PM PDT

hi again,i need to run data parameter in ssis 2008 through BIDSFor example, the package contains dumping the data into table when u select 1st april, 2013.then the data should be extracted for previous 3 months (1-jan-2013 to 31-mar-2013) regardsshaun 2012

Generate a day date according to existing month+year+daydiff

Posted: 31 Jul 2013 06:46 PM PDT

im using sql 2008.i got this 5 columns:StartMonth,StratYear,EndMonth,EndYear,DaysBetweeni dont have the day of these dates and that's what im trying to generate for example:12 2008 1 2009 8now, i want to create a random date (start date and end date , format as dd/mm/yyyy) which will include the day and will make scene upon the data i have under days betweenFOR INSTANCE,if i know that i got 8 days (DaysBetween) and the startmonth is 12, the date must be from 24/12/2008 cause if i add 8 days i get the EndMonth (1/2009)if i would choose the date 2/12/2008 i would get 10/12/2008 and its not good cause the month is still 12....and i need 1 (2009)how can i generate valid dates ?thank you

Backup Set List Not Populating

Posted: 01 Aug 2013 04:14 AM PDT

I have posted this on Amazon's Developer Forum, but I have also seen this happen at other times.I have a Windows 2008 server with SQL Server installed (image_1) on Amazon EC2. I create an image of that machine, then I launch the newly created AMI (image_2). When I go into (image_2)'s Management Studio to perform a database restore, I noticed that all of my backup result sets are not displaying, yet they are on disk.What it does look like: NoBackupSets.jpgWhat it should look like: ListedBackupSets.jpgWhat I was hoping that would happen is I could fire up image_2, then using the Management Studio's GUI, restore a database from a point in time. This would speed up the process greatly over having to do it all individually by script.My question is, when the backup set list is not populated, is there a way to populate it or do I have to run my restore manually from script?Thank you in advance,Jim

Login Creation

Posted: 31 Jul 2013 07:06 PM PDT

Hi Team,While creating a new login, Effective tab is missing in securables window,Please suggest..

Loading Hierarchical data

Posted: 02 Aug 2013 07:56 PM PDT

Hi Experts,[code]CREATE TABLE #Source( Id int identity(1,1) ,category int ,Leaf_Node_code varchar(10) -- ,Level1_Name varchar(20) ,Level2_Name varchar(20) ,Level3_Name varchar(20) ,Level4_Name varchar(20) ,Level5_Name varchar(20) )INSERT INTO #SourceSELECT 1,'101','World','Asia','India',null , null UNION ALLSELECT 2,'102','a','aa','aaa','aaaa' , null UNION ALLSELECT 3,'103','b','bb','bbb','bbbb','bbbbb' Here category 1 has 3 levels , category 2 has 4 levels , category 3 has 5 levels , below is the target table, here Leaf_Node_code should populate to only for leaf nodes for each category .. Need to populate Node_id with hierarchical data I am unable frame a sql query to handle different levels , in future #Source may have more levels .Please guide me on handle multiple hierarchy levels .. here only leaf node should have Leaf_Node_code CREATE TABLE TARGET_TABLE( ID INT IDENTITY(1,1) primary key,Node_id HIERARCHYID ,category int ,Parent_id int references TARGET_TABLE(id),Leaf_Node_code varchar(10),Name varchar(20))Here is the expected output:ID category Parent_id Leaf_Node_code Name Node_id 1 1 NULL NULL World2 1 1 NULL Asia3 1 2 101 India4 2 NULL NULL a5 2 4 NULL aa6 2 5 NULL aaa7 2 6 102 aaaa8 3 NULL NULL b9 3 8 NULL bb10 3 9 NULL bbb11 3 10 NULL bbbb12 3 11 103 bbbb[/code]Thanks.

Exam 70-448 retired or not

Posted: 03 Aug 2013 12:54 AM PDT

HiCan somebody please tell me, is the exam 70-448 SQL Server 2008, Business Intelligence Development and Maintenance retired or not?This link says yes: (overview) [url=http://www.microsoft.com/learning/en-us/exam.aspx?id=70-448&locale=en-us]Link[/url]This link says no: [url=http://www.microsoft.com/learning/en-us/retired-certification-exams.aspx]Link[/url]Furthermore, I had a online chat (31/7) with someone from Microsoft Learning, who said no.I failed on the 31/7, and was told that I could not retake because the exam now retire. My company have spend a lot money, and I have used a lot of time reading (apparently not enough), so I am pretty annoyed, if I can't retake
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog