View t-sql SPID is executing
Is there a table that I can query to view what sql statements a spid is running? I do not want to use the dbcc inputbuffer.

Answer Question   |  January 13, 2010  4:20 PM
SQL, SQL Server 2005

When submitting a procedure via CL program, i do not get any abnormal end message.
When submitting a procedure via CL program, i do not get any abnormal end message even though the procedure has not not completed normally, is there anyway by which we can find the cause of the failure of the completion of the procedure normally.

Answer Question   |  March 8, 2010  1:02 PM
CL programming, CL programs, CLP, Stored Procedures

RPGLE external stored procedure when called with OUT parameter having issues when called from C#
We have created some stored external procedure with paramter type OUT but these were giving memory protection at C# side.However when we call it from operation navigator ,it is running succesfully.I created some SQL stored procedure with OUT paramteres and these were working correctly when invoked from C#.What can be the issue with external Stored [...]

Answer Question   |  January 13, 2010  9:02 AM
RPGLE, RPGLE Stored Procedures, Stored Procedures

Create A Fixed Text File From SQL DB Table
Hello programmers. After doing much research I am unable to resolve how or where to custom format each field of my SQL table output into my text file. Can someone help me with enhancing the below vb script? I need to reformat certain values. Do I do the formatting in the Dim section or in [...]

Answer Question   |  January 12, 2010  1:56 AM
ASP.NET, SQL Database, SQL tables

SQL saving off data created to copy into new database
Data is created in one SQL DB for testing and then a new DB is created. Is there a way to save the data you need for testing in the new DB, so you don’t have to create it each and everytime for testing?? Any suggestions would bew appreciated.  Thanks…

Answer Question   |  January 12, 2010  3:34 PM
SQL, SQL Database

Cannot INSERT data into table with identity column
In my program I have an EmployeeRegistry table which holds data of each employee’s work attendance. Every attendance record is uniquely distinguished by an IDENTITY COLUMN called “AttendanceID” which has an IDENTITY SEED of 1 and an IDENTITY increment of 1. However when I try to insert an attendance record to the table via my [...]

Answer Question   |  May 11, 2012  2:54 AM
INSERT statement, SQL Server 2005, SQL Server 2005 Express Edition, VB.NET 2005

Earn 250 Knowledge Points now by tweeting out our contest
We’ve recently added 250 Knowledge Points to the following profiles for tweeting out our Google Nexus One Challenge: Jaideepkhanduja OwenAmbrose Carlosdl Ryan8613 MarkK Tweet out our Google Nexus One Challenge now and you can also earn the 250 Knowledge Point bonus. Remember that you don’t have to be an expert to earn Knowledge Points in [...]

Answer Question   |  January 27, 2011  3:23 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP Gateway

SQL Server 2005 error log, could not read information for this log entry
Hi, There is a SQL Server error log entry in the SQL Server 2005 production box with the following.   “Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:”   Has anyone seen anything similar? Does anyone know what [...]

Answer Question   |  January 14, 2010  12:41 AM
SQL Server 2005, SQL Server error logs, SQL Server errors

New Contest: Win the Nexus One Google Phone with your Knowledge Points!
You’re asking and answering questions already, so why not put those Knowledge Points to good use? Win a Nexus One, Google’s new cell phone! It’s unlocked, so you can sign on with the (select) carrier of your choice contract-free! Read all the details, but the short and long of it is that over the next [...]

Answer Question   |  February 27, 2010  3:30 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

Access Rights in SQL Server 2005
Hi,  I’m using sql server 2005 and in my application i have 2 DB say A and B , and 2 servers SR1,SR2 and DB A,B and present on both (SR1,SR2).now i want to give access to users entering my DB not to view any of the entries made in the DB, not even the [...]

Answer Question   |  January 7, 2010  6:29 AM
SQL Server 2005, SQL Server permissions, SQL Server User Accounts, Windows Vista

Microsoft servers software and hardware upgrade
We have the following architecture: 2 Microsoft SQL servers. OS is windows 2000. SQL database  is 7.0. The server hardware is HP proliant 800. The server is a SQL applicaiton server. The server is used for data mining. RIght now it has a script that used bulk inserts to push “csv” files to the database. [...]

Answer Question   |  January 7, 2010  4:30 PM
HP ProLiant, SQL Application Server, SQL Server, Windows Server

Where can I download SQL Server 2005? All trials are no longer available.
I desperately need to install SQL Server 2005 to learn it for a new job starting monday. Does anyone know where I can download a trial. Thank you tresortx@yahoo.com

Answer Question   |  January 7, 2010  4:21 PM
SQL Server, SQL Server 2005

bcp – clock time meaning
Attempting to BCP a large resultset using a view and the queryout option. I have been playing with the network packet size and the size of the batche using join conditions. When looking at the command line output file. What do the values in “Clock Time (ms.) Total” signify. I am trying to measure the [...]

Answer Question   |  January 6, 2010  3:55 PM
BCP Utility, SQL 2005, SQL Server 2005

Find a particular text from all tables in DB.
Hi There are 100 tables in my DB. I want to find if a text say “ABCD” is availbale in any these 100 tables. If it is availbale can we list those tables. Can someone help me out with the Query.   Regards Mayur

Answer Question   |  January 15, 2010  11:46 AM
SQL Server, SQL Server database

Synchronizing SQL Server 3.5 Compact Edition to SQL Server 2008
How do you synchronize of SQL Server 3.5 Compact Edition to SQL Server 2008? I have the framework installed, do I have to create a third party application to actually perform the synchronization?

Answer Question   |  January 5, 2010  8:32 PM
SQL Server 2008, SQL Server 3.5 Compact Edition

Reporting Services 2005
Hello, I am running reporting services 2005. I created a subscrition for a report named “paid_claims” that will auto generate an excel file into a shared folder on the network. The “paid_claims” report has a link to another report named “sub_paid_claims” in the same folder. We recently renamed our server from MEDI01a to MEDI01, when [...]

Answer Question   |  January 13, 2010  4:23 PM
Reporting, Reporting Services, Reporting Services 2005, SSRS, SSRS 2005

Create Excel file on web server by using SQL
How can I create an excel sheet on web server by using a stored procedure in SQL Server 2005. I’m retriving data from sql select query and creating Excel file dynamically on we server of that data using asp.net. But I want to do this with the help of SQL stored prcedure. i.e. In a [...]

Answer Question   |  January 13, 2010  12:02 PM
Microsoft Excel, SQL Server 2005, SQL Server stored procedures

SQL Dumper library failed to
How can I get by the Log on to Windows page when I have SQL Dumper library error message?

Answer Question   |  January 4, 2010  3:23 PM
SQLDUMPER

network connecting only one way
Iam trying to connect to server in network not connected but server to all other connecting ok. changing firewall setting time system shows “windows firewall cannot run because another program or service is running that use the network address translation component( ipnat.sys)”

Answer Question   |  January 4, 2010  4:58 AM
Crystal Report, Oracle, SQL Server

SQL Server Express 2005 Installation Failure
Here is a fix for SQL Server Installtion failure. And a fix for newly installed programs that cause memory faults. I encountered an issue after installing SQL Server Express 2005. Where I get a blue screen with c000021 0xc0000005 this is an install on a Dell PowerEdge 600SC Widows XP SP2. To correct the problem, [...]

Answer Question   |  December 23, 2009  7:07 PM
0xc0000005, SQL Express, SQL Server 2005, XP