Sponsor Post: Join Us for Endpoint Security and Identity Access Management Live Chats with Microsoft

Today’s workforce faces a constantly evolving landscape of threats to information and infrastructure—even regulatory compliance. Endpoints are exposed to attacks both inside and outside the corporate firewall, resulting in lost productivity and real financial losses worldwide.  Join us this month for two Live Chats that will help you avoid these losses and gain a better…



Answer Question   |  June 28, 2012  7:35 AM
CIO, DataCenter, Endpoint security, Exchange server software, Identity and access management, Microsoft Live Chat, Security, SQL Server, Windows
asked by:
3,235 pts.

SQL Server 2005 question self join query

I have one table that name is TblCategory on that 2 columns are CategoryName another column name is UpperCategoryID my table is like this CategoryName UpperCatID ———— ———– Book Commerce Commerce Accounting Science Math Commerce B.O. Material Pen Pen Link Pen Renolods I want ouput like CategoryName ———— Book Material



Answer Question   |  June 28, 2012  7:25 AM
SQL Server 2005, SQL Server Query, SQL Server tables
asked by:
5 pts.

TFS VSTS2010

Hello Members,                        I am very new to this blog.I want to need some information regarding VSTS2010 TFS(Team Foundation Server).I have couple of questions in my mind. I really want to share with you. At present time we want to implemnet automation testing processes for our WPF window based as well as web based applications.…



Answer Question   |  June 28, 2012  7:22 AM
SQL Server 2005, TFS VSTS2010, Visual Studio, Visual Studio 2010
asked by:
5 pts.

DB2 Recursive UDF

I am looking to create a SQL table UDF on my AS400(v5r2) that will return a listing of suboridinates for a given manager. Is it possible to use recursion? Since we are on v5r2 recursive SQL is not an option



Answer Question   |  June 28, 2012  7:12 AM
AS400 V5R2, DB2 SQL
asked by:
5 pts.

Replication Causes Client Application to Hang

I’ve got 25 Sites that are running an application that connects to MS SQL 2005, All the sites have their own copy of a database and have one similar database that holds information gathered from the different sites, now what is happening is that if a client registers at one institution and then later visits…



Answer Question   |  June 28, 2012  6:19 AM
SQL 2005, VB.NET
asked by:
45 pts.

Exclude Login from SQL Audit Trace

I’m working on a stored procedure to capture SQL Server 2005 Audit events.  There is an Application login/user that generates a LOT of rows because it is constatntly hitting the database. I’m using something like: exec sp_trace_setevent @TraceID, 14, 11, @on How do I EXCLUDE a specific login from being audited?



Answer Question   |  June 28, 2012  6:04 AM
Audit Trace, SQL audit, SQL Server, SQL Server 2005, SQL stored procedures
asked by:
110 pts.

Exclude Login from SQL Audit Trace

I’m working on a stored procedure to capture SQL Server 2005 Audit events.  There is an Application login/user that generates a LOT of rows because it is constatntly hitting the database. I’m using something like: exec sp_trace_setevent @TraceID, 14, 11, @on How do I EXCLUDE a specific login from being audited?



Answer Question   |  June 28, 2012  6:03 AM
Audit Trace, SQL audit, SQL Server, SQL Server 2005, SQL stored procedures
asked by:
110 pts.

How to import Microsoft Access to SQL Server 2005

hi, while i am importing database MS-Access to sql server 2005 its could not importing its Showing like this: The operation could not be completed. Additional information: -> Not a valid password.(Microsoft JET Database Engine) What to do? can you give the solution. Thanks, Deepa



Answer Question   |  June 28, 2012  5:50 AM
ASP.NET, C#, Microsoft Access, Microsoft Access import/export, SQL Server 2005, SQL Server 2005 import/export, SQL Server 2005 migration, SQL Server migration, Web development
asked by:
5 pts.

Tool for ETL/SSIS packages testing

Which is the Best Tools for ETL/SSIS packages testing



Answer Question   |  June 28, 2012  5:47 AM
ETL, SSIS, SSIS Package, SSIS Testing
asked by:
5 pts.

How to config iSQL Plus on computer without a domain

Hello I have Oracle 9i installed in my home computer and i want to work in iSql Plus, but i am not able to do it. I tried running the apache server but then when i tried to login i get a error message “The server encountered an internal error or misconfiguration and was unable…



Answer Question   |  June 28, 2012  5:40 AM
isql, iSQL*Plus, Oracle, Oracle 9i, SQL, SQL Plus
asked by:
5 pts.

How to config iSQL Plus on computer without a domain

Hello I have Oracle 9i installed in my home computer and i want to work in iSql Plus, but i am not able to do it. I tried running the apache server but then when i tried to login i get a error message “The server encountered an internal error or misconfiguration and was unable…



Answer Question   |  June 28, 2012  5:40 AM
isql, iSQL*Plus, Oracle, Oracle 9i, SQL, SQL Plus
asked by:
5 pts.

MS SQL Server installing in the Livelink

Hi there, I want to create a new Database ( MS SQL ) in the Livelink 9.7.0 , so which version ( MS SQL Server 2000 or 2005 ) is install in the Livelink 9.7.0 . If together can installed in Livelink 9.7.0 , whichever is better ? Best Regards, Abdullah from DUC



Answer Question   |  June 28, 2012  5:15 AM
Livelink, SQL Server 2000, SQL Server 2005
asked by:
5 pts.

MaximumErrorCount

HOW DO I CHANGE THE MaximumErrorCount IN SSIS



Answer Question   |  June 28, 2012  5:14 AM
SSIS, SSIS MaximumErrorCount, SSIS Package, SSIS Package 2005
asked by:
5 pts.

releasing SSRS reports to clients

we have clients that have ssrs installed on their servers and we would like to supply them with reports we have created using ssrs. what is the best way to go releasing our reports to our clients?



Answer Question   |  June 28, 2012  5:12 AM
Release management, Reports, SSRS
asked by:
5 pts.

asked by:
5 pts.

asked by:
5 pts.

Connecting VC6 to SQL server

how can i connect VC++6 MFC application to SQL server? plz help m out!! :(



Answer Question   |  June 28, 2012  4:33 AM
SQL Server, SQL Server connectivity, VC++, VC++ 6, VC6
asked by:
5 pts.

Connecting VC6 to SQL server

how can i connect VC++6 MFC application to SQL server? plz help m out!! :(



Answer Question   |  June 28, 2012  4:33 AM
SQL Server, SQL Server connectivity, VC++, VC++ 6, VC6
asked by:
5 pts.

Show the table field on vb.net form

How can I show table fied on vb.net form.I have used sql2005.



Answer Question   |  June 28, 2012  4:27 AM
SQL 2005, VB.NET
asked by:
5 pts.

Virtualizing Business-Critical Applications VMware expert live chat TOMORROW (10/26)

Don’t forget about the LIVE VMware expert chat TOMORROW, October 26th from 11am-2pm EDT: Virtualizing Business-Critical Applications. You’ll learn about application performance considerations, best practices and use cases for deploying Tier 1 applications on VMware. Click here and bookmark this page to access the chat.



Answer Question   |  June 28, 2012  4:18 AM
Exchange Server, Infrastructure, Oracle, SAP, SQL Server, Virtualization, Virtualization and hardware, Virtualization how-tos, VMware, vSphere, Windows Server 2008, Windows Server 2008 Administration
asked by:
3,235 pts.