Stored Procedure
I am calling some stored Procedure, having selct statment, after inserting some a new data entry by different stored procedure. Some times my Select stored procedure does not return any value. Data is exactly correct and when I explicitly called that SP with same data by Query analyzer, I will got the desired result. The [...]

Answer Question   |  July 19, 2008  2:35 PM
ADO.NET, SQL stored procedures

SQL
How to find out if database are crypted

Answer Question   |  January 31, 2008  9:54 PM
SQL Server administration

SQL Command
I have created a stored procedure in SQL2000 like this : SELECT p.PO_code,p.Po_date, p.Supp_code + ‘ : ‘+ s.Sname as Supp_Nme,p.po_total,r.RC_code,r.Amount FROM PO_list p inner join RC_list r on r.PO_code = p.PO_code inner join Supplier s on s.supp_code = p.supp_code WHERE (p.Supp_code in (’102200′,’102083′)) and (substring(p.PO_CODE ,5,1) = ‘R’ ) and (p.cancel = ‘N’ and [...]

Answer Question   |  February 12, 2008  3:09 AM
SQL Server 2000, Stored Procedures, T-SQL

Microsoft SSAS with Cognos Front End
Is there anyone out there that is working or has worked with a Microsoft back-end (SQL SVR 2005, SSIS, SSAS) and a Cognos front end ? What is your experience with this ?

Answer Question   |  February 8, 2009  11:44 AM
Cognos, SQL Server, SSAS, SSIS

SQLEVN70.RLL error
IT Answer “Your SQL server installation is either corrupt or has been tampered with (Could not open SQLEVN70.RLL). <I have been getting this error during bootup since i tried to install the microsoft office professional 2007 trial software i received with a computer book that i am currently taken in college. Before then the system [...]

Answer Question   |  May 16, 2010  6:44 PM
Recovery of SQL Server, SQL, SQL Server, SQL Server 2000 SP2

How to control SQL Server transaction log growing to a maximum size
Transaction log in SQL Server getting completely growed to maximum size frequently even when it is being backed-up and shrinked.. Please provide early and feasible solution.. What is the possible cause for the growth of transaction log to that extent.. and how to avoid it…

Answer Question   |  February 22, 2008  1:54 PM
SQL Server, SQL Server transaction logs

Upgrading two instances of SQL 2000 running on the same SVR to SP4
I currently have two instances of SQL 2000 running on the same SVR. recently I commissioned a new CRM SVR and as I’m sure your all aware that the minimum requirement for the CRM to work correctly is SQL 2000 SP4. I downloaded and installed SP4 on the SVR running SQL 2000, however, my problem [...]

Answer Question   |  February 22, 2008  4:47 PM
SQL Server 2000, SQL Server 2000 SP4

SQL 2005 Replication
hello, i have a replication which is done between 2 sql 2005. server AB which is on a cluster is the publication whereas there are multiple servers who are the subscriber. whenever reepliaction is done i have the error : error authenticating proxy domainusername. check that the username or password is correct. please help!!

Answer Question   |  January 31, 2008  6:35 PM
Replication, SQL Server 2005

SQL Server transaction log problem
An error like” Transaction log full.. backup thelog and shrink the database .. ” occured.. Many times the transaction log was backed up and shrinked.. Niow a stage has come where even doing the phenominal process.. the error still re occuring.. Afetr going thru a website transaction log was disabled by using DBCC command.. Still [...]

Answer Question   |  February 22, 2008  10:14 AM
SQL Server, SQL Server logs

convert a query from access to sql server 2005
Ive recently been given the task of converting an application from an Access database to sql server 2005. One of the queries has this on the ORDER BY Clause ORDER BY not isdate(Obsolete), not isdate(not_relevant), isdate(assessed), isdate(published), isdate(implemented), not locally_adapted, guidanceType DESC, nice_ref DESC this wont work on sql server. Locally_adpated is a bit column [...]

Answer Question   |  January 29, 2008  3:47 PM
Microsoft Access, SQL Server 2005

How to use subselect in a case statement
Getting error… “Token EXISTS was not valid….” on case statement… ,case when g.GFGSTS = ’2′ and not exists (select a.GFTSEQ from GFTP010 a where a.GFCSQ# = g.GFCSQ# and a.GFGSTS = ’3′ ) then count(*) end as Void#

Answer Question   |  January 17, 2008  3:11 PM
CASE statement, SQL, SQL Subselect

documents on sql server upgrade from 2000 to 2005
Hello, If anyone has following documentation on SQL SERVER UPGRADE FROM 2000 TO SQL SERVER 2005, I will appreciate. 1) Pre-Checklist for the Upgrade 2) Process for the Upgrade 3) Post Check list for the Upgrade Thank you so much. If you kindly email me at cqldba@gmail.com, will appreciate thanks Sam

Answer Question   |  February 22, 2008  10:30 PM
SQL Server backup

passing the records based on the division condtion
a falt file containg 500 records so i need to pass the records based on the division condition to the 4 output files created i.e records divisible by 2 not by 4 means 2nd,6th,10th records must pass to file 2 and divisible by 4 pass to the file 4 and divisible by 3 passed to [...]

Answer Question   |  January 17, 2008  5:32 AM
Conditional expressions

Temp Tablespace in 10G
have a Oracle 10g database that is with its temporary tablespace full. Is there any way to clean this tablespace? I tried to restart the database, but i’ve no effect

Answer Question   |  January 25, 2008  7:42 PM
Oracle 10g, Temp Tables

ROW_NUMBER in SQLServer
In Oracle, I can use the analytic ROW_NUMBER function to assign sequence numbers to output rows, re-starting the sequence as certain values change (e.g., there’s a separate count for each deptno in this example:) SELECT deptno , ename , ROW_NUMBER () OVER ( PARTITION BY deptno ORDER BY ename ) AS seq FROM scott.emp ORDER [...]

Answer Question   |  February 22, 2008  11:15 PM
ROW_NUMBER, SQL, SQL Server

Need to create SQL DTS Package
We are using SQL 2000 DTS Packages and I want to create a DTS Package which can copy only all text file names from folder(source) to SQL table column(Destination). Also i want to write number of rows in particular text file to SQL table. DTS or Procedure or Activex Script??

Answer Question   |  February 22, 2008  3:35 PM
DTS, SQL, SQL Server 2000

Problems with sp_send_dbmail in SQL Server 2005
I am trying to convert my stored procedures in SQL 2005 from using xp_smtp_sendmail to using sp_send_dbmail. When I use the “Send Test Email” option in the management studio, I am getting the following error message from the sp_send_dbmail: The mail could not be sent to the recipients because of the mail server failure. (Sending [...]

Answer Question   |  February 22, 2008  5:32 PM
Sendmail, SQL Server 2005, Stored Procedures

DTS error after deleting xls file with script
All, After I have deleted a xls file using an ActiveX script the DTS Package fails because the file is not there. I then have to go into the properties of the task and go to the destination tab and click the create button. The I have go to the Transformation tab and then run [...]

Answer Question   |  January 10, 2008  5:11 PM
ActiveX, DTS, SQL, XLS

SQL Server 2000 backup failed
can not backup a 2000 db, dbcc checkdb ok. see following: Errorlog: 2008-01-08 09:54:40.69 spid62 Starting up database ‘CP2005′. 2008-01-08 09:54:41.00 backup BACKUP failed to complete the command BACKUP DATABASE [education] TO DISK = N’C:fjs1education_db_200801080954.BAK’ WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT 2008-01-08 10:19:18.34 backup BACKUP failed to complete the command [...]

Answer Question   |  February 22, 2008  6:51 PM
MSDE, SQL Server 2000, SQL Server 2000 Desktop Engine

view and temp. table which one works better in T-SQL?
please tell me which one performs better view or temp table ?

Answer Question   |  February 22, 2008  12:13 AM
Oracle Views, T-SQL, Temp Tables