Princiapl server in SQL 2005 SP1 and mirror Server in Sql 2005 SP1 Planning to upgrade ONLY Principal server to SQL 2005 SP2. Do we encounter any...
is day light saving time affect on sql server jobs? is there any MS article on this?
Satya, Coudl you please confirm is it a bug in this system stored proc or i am doing something wrong? Thanks
At peak I am seeing lot of memory pressure errors I am running 2k5sp2 ,win2k3 HEre is the DBCC memory status . I have seen some negative values in...
This systemp SP sys.sp_dbmmonitorupdate having this line of code i try to find this SP could not find any where any ideas?exec @retcode =...
Hello I have to resgister 240 servers . My co-worker already resgistred them in Sql management Studio. Is there anyway easy way I can copy to my...
Satya, I do not have 2008 on my machine. I can't test it. IF you guys find something intersting please let me know.
Satya, Thanks for the links, However, they are pointing to SQL2K . I am working on 2005 ssis. It says FTP task completed. but file not downloaded....
Hello There, I have setup the plain FTP task nothing fancy. It is turnign into green however, the file which I mentioned in the task is not...
When I was watching Merge slide show. I have observed You can insert records with the following statement INSERT INTO Production.UnitMeasure VALUES...
thanks Dinesh. Submitted. https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=288124
Where can we submit suggestions for SQL 2008?<br /><br />I would prefer If they introduce the following feature in sql server 2008<br /><br />In...
Satya,<br />Thanks for the info . However, Our folks do not want to go with MS PSS at this time. I don't care if they dont care . All I can do is...
Windows NT 5.2 Build 3790 CSD Service Pack2<br />Microsoft SQL Server version 9.00.3042.00 <br /><br /><br />Satya, I could not find any details in...
Hello Team, We are running SQL 2K5 64bit on wind 2k3. It was running fine since 5/30/2007 until last firday. We submit jobs they run for at least 6...
Yep , I usually use that option. IT is not real time . The above command give real time info.
Y'night I have started restoring one of my PROD db copy on QA server. (120GB)<br />I have submitted as a SQL SERVER JOB. So, I do not have any clue...
Hello , Here is the interested topic between me and Mike Hotek ( The inventor of Transactional replication ). If you have time read it ! I learned...
Can someone tell me in dataware house application which reports are completing in 1hr time.. ? Just intersting to know.. <br /><br />Joe, You mean we...
Joe,<br />I understand the concern But, We have gone thru lot of iteration where we can reduce the time & unnecessary code. these reports are very...
Separate names with a comma.
