Topics
Started by
Posts
Last post
How do i get select within the contains clause to work with the dynamic sql ? if (@Name <>…
22 replies
Date6/18/2012 12:07:08 PM LogJob History (abcd) Step ID1 Serverx-yz Job Nameabcd Step Nam…
5 replies
Hi, A bit confused on how to trigger an email if average temperature rise is bigger then 10%. Any s…
25 replies
Hi all, In the wizard, my source table is an excel worksheet. Instead of choosing to copy data from…
1 replies
I need to get a history of when/how often my stored proc ran for the past few months. Is there DMV …
2 replies
I am running SQL Server 2008 R2 on my local SBS 2011 server and I have legacy SQL Server 2000 datab…
4 replies
We rebuild our indexes online. Since data and indexes are huge and our tables are partitioned, we r…
4 replies
Sorry I forgot to paste the code in the previous email. Select COUNT (MS_DRG) as 'cntof MS_DRG',ms_…
1 replies
THE FINAL table should look like this. I have temp table A and I have two fields FYPer/yr, and MS_D…
2 replies
I have implemented both custom logging and canned logging that comes with SSIS. This is all good an…
1 replies
Hello, I've recently been asked to look at a server that was running at a minimum of 50-60% CPU wit…
6 replies
Hi, I need to take a date in YYMMDD format and select it as YYYYMM or MMYYYY format as a date and n…
2 replies
I am having a problem with my query and subquery within the query. I get and error: Subquery retur…
2 replies
Quick one. If I inherit an encrypted db in 2008. I have the cert and password how do I transfer thi…
2 replies
Hi, I want to define a policy to make sure every table and every index (including those for indexed…
2 replies
Viewing 15 topics - 16,786 through 16,800 (of 30,189 total)
You must be logged in to create new topics.