Exchange – extracting email properties
Hi there, just need a bit of guidance here. I need to extract from email accounts a list of the emails in that account – I don’t want the content of the emails – but what I want is emailID, subjsy, date received and it’s current location (ie what folder is it in) in that [...]

Answer Question   |  March 29, 2013  9:35 PM
Microsoft Exchange 2007, SQL Server tables

Trap SQLCODE from RUNSQLSTM
I have a RUNSQLSTM that updates a table. When it hits a duplicate, it quits and returns SQL9010. What I want it to do is just skip the step that got a duplicate and move on. Is there a way to do this?

Answer Question   |  February 7, 2013  9:13 PM
RUNSQLSTM, SQLCODES

Joining unmatched tables with duplicates
Hi, I am a beginner SQL user and am trying to take table 1 (contracts) and pull in the calltype from table2 (equipment) with the control number as the common field. However, there are duplicate control numbers in table2 which are causing me an issue. I have created this query on table 2 to get [...]

Answer Question   |  November 29, 2012  5:50 PM
Microsoft SQL Server 2005, SQL Server tables

Trigger
What is the use of the trigger?

Answer Question   |  September 21, 2012  9:02 AM
SQL Trigger, Triggers

Query timeout expired – State:S1T00,Native:0,Origin:[Microsoft][SQL Server Native Client 10.0] on production server
Hello, I am getting the below error on customer production error, Query timeout expired – State:S1T00,Native:0,Origin:[Microsoft][SQL Server Native Client 10.0] The queries are forming on the fly using MFC’s record sets. if I try to run that queries on SSMS directly I am not getting that error. How to identify exactly which query leads this [...]

Answer Question   |  August 20, 2012  8:38 AM
Microsoft SQL Server, SSMS

SQL Query
how to select only those table name from database that have a two field in table like PID amd EID table that have PID also have a EID in a single table those table i want to select

Answer Question   |  June 4, 2012  1:14 PM
SQL Server, SQL Server tables

SQL trigger on column
Table have delete and update trigger. How to identify which columns are affected by this triigers? or  which column have  triggers ?

Answer Question   |  May 9, 2012  4:46 AM
SQL Server, SQL Trigger

update the tables in to two server using a single ssis package
i have 2 servers server A and Server B.i have written a package in server A.i want to update the tables in both server A and B.when i execute the package from BIDS it is working fine when i schedule the package in agent job i am getting the below error.  Executed as user: RICRDWDEVSYSTEM. …ckage [...]

Answer Question   |  April 5, 2012  10:04 AM
SQL Server 2005, SSIS Package 2005

unable to connect sql server 2000 on network
We have sql server 2000 instance on a machine say “comp1″.The problem is when i need to connect to it via another computer on LAN using SSMS it is unable to connect but when i connect to the “comp1″ via run and give password then i am able to connect through SSMS Can someone give [...]

Answer Question   |  April 11, 2012  1:19 PM
SQL Server 2000, SSMS

Matching key question – resubmitted
Hi, resubmitting because the first upload did not seem to work… Here is the problem I am trying to solve. I need to extract some information from a table, say Tab2, using a matching key from another table, say Tab1. Tab1 has two columns, Col1 and Col2. Col1 is digits (1, 2, 3…) Col2 has [...]

Answer Question   |  March 16, 2012  10:25 PM
SQL Server tables, SQLServer

Schedule SQL job to run and export to CSV file
Hi. I am trying to create a SQL job to run every hour and export results to a CSV file. I have created the job and scheduled it but can not figure out how to have it create the CSV file. Thanks!

Answer Question   |  May 8, 2013  11:45 PM
CSV, SQL Jobs, SSMS 2008

RUNSQLSTM ALTER TABLE
i’m trying to run SQl statment in batch job to alter Table CCSID to 420 but i have error Reason code 10  Hani 

Answer Question   |  February 27, 2012  10:51 AM
AS/400 V5R3M0, SQL tables, SQL/400

SSRS 2008 R2 Trendlines
I cannot find out how to add trendlines to my SSRS 2008 R2 report. TechNet http://technet.microsoft.com/en-us/library/dd207034.aspx refers to a ‘Values’ area and an option to ‘Add Calculated Series’. The ‘Values’ area I see does nothing on a “Right-click” and the option to “Add Calculated Series” I cannot find anywhere.

Answer Question   |  October 25, 2011  8:19 AM
SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS, SSRS 2008

Error Message in SQL Server 2008 code.
Hi, I am currently going through the Tutorials on SQL Server Management Studio 2008 R2. One of the samples instructs me to run the following code: SELECT  Mgr.EmployeeID AS MgrID, Mgr.LoginID AS Manager,  Emp.EmployeeID AS E_ID, Emp.LoginID, FROM EmployeeDemo AS Emp LEFT JOIN EmployeeDemo AS Mgr ON Emp.ManagerID = Mgr.EmployeeID ORDER BY MgrID, E_ID; [em]When [...]

Answer Question   |  March 31, 2012  11:20 AM
SQL Query, SQL Server 2008 R2, SQL Server Management Studio, SSMS 2008

Is there a way to find out when a patch was last applied to an instance?
Is there a way to find out the date a SQL Server instance was last patched?  I need to keep track of dates each of my instances had a patch applied whether it be a security patch, hotfix or service pack.  I looked in the ServerProperty function but did not see anything that would return [...]

Answer Question   |  March 31, 2012  2:20 PM
SQL instance, SQL Server, SQL Server security, SQL Server User Instances

How to configure parameters display in SSRS 2008?
Hi, I know it wasn’t possible in ssrs 2005 to have parameters displayed into more than 2 columns. My question is has it be solved in ssrs 2008r2 ? If yes, how can I do it ? If no, is there a possibility to walk around this issue ? Many thanks, Sonia

Answer Question   |  March 31, 2012  11:29 AM
SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS 2008

sys.conversation_endpoints build up
 It Seems that there is a lot of problems with SB cleanup? I have SQL 2008 r2 running on two different servers. The target system processes the millions of records in the queues but will not clean out the sys.conversation_endpoints, or the sys.conversation_endpoints tables. This is part of the activation proc that is run on [...]

Answer Question   |  March 31, 2012  11:40 PM
SQL Server 2008, SQL Server 2008 R2, SQL Server Service Broker, SQL Service Broker

Reg:Problem with SSAS
Hi team, This is the first time i registered in such communities. I have a problem with SSAS. We planned for a migration from 2005 to sql 2008 which also involves cubes. I am trying to point out SSAS 2005 cubes to 2008 sql server. Is it possible to do this way or do I [...]

Answer Question   |  March 31, 2012  2:17 PM
SQL Server 2005, SQL Server 2008, SQL Server migration, SSAS, SSAS 2005

SQL Server Error 7202 Could not find server
Hi all, I am currently running into the following error when run a stored procedure with BEGIN TRANS:  ”Could not find server ‘VS-DEVELOPERDEVELOPER_SQL’ in sysservers. Execute sp_addlinkedserver to add the server to sysservers.” The server shown above is the a local sql server instance that is running the stored procedure and therefore shouldn’t need to [...]

Answer Question   |  March 31, 2012  2:12 PM
SQL error messages, SQL Server, SQL Server error messages, SQL Server stored procedures

SQL Injection in my network
How can I protect against SQL injections and remove the injection point?  Also, how can I remove an injection that my antivir has detected?  My computer is running extremely slow and I’d like to know what information has been compromised.

Answer Question   |  March 31, 2012  6:40 PM
SQL injection, SQL Injection Validation, SQL Security, SQL Server security