Forum

Posts

RECENTLY INDEXED PROGRAMMING SOLUTIONS OF Microsoft SQL Server


DTS - SQL Server  

I am having a problem with my DTS package. I want to move old backup files that are 10 days old. However, it is not passing the file name. Prior to adding the date as a condition, it moved all the bak files within the folder to the other folder. Any suggestions/ ' Move File Continue Reading
Views : 47
Monday 26th of November 2012

installation problem  

I using Windows XP SP2. My computer is Aopen 1535 notebook. I try to install SQL 7 SP4 but i got the msg as below:C:\WINDOWS\SYSTEM32\AUTOEXEC.NT. The system file is not suitable for running MS-DOS and Microsoft Windows application. Choose 'close' to terminate... Continue Reading
Views : 143
Monday 26th of November 2012

Insert Into query  

I want to insert into an existing table a row if does not already exists. For instance; If Exists(Select * from table1 Where table1.recordid = table1.recordid And not exists actioncode = 0) Insert into... Continue Reading
Views : 211
Monday 26th of November 2012

can help me pls  

i have this error when i am opening up my asp filecan any1 pls help me? Error Type:Microsoft OLE DB Provider for SQL Server (0x80040E4D)Login failed for user 'KELVIN_LIM\IUSR_KELVIN_LIM'./ASPTRYSUCCESS.asp, line 25it is used to link up to a... Continue Reading
Views : 169
Monday 26th of November 2012

Hardware performance and SQL  

I'm a complete newbie to SQL and this forum etc. so please excuse if this is a stupid question: I am running a SQL database on a HP DL360 G3 server, using the integrated 5i array controller and 2 15K disks running in RAID 0 configuration. I've looked at some of the perf... Continue Reading
Views : 121
Monday 26th of November 2012

The very small and the very large  

Couple of questions: There isn't a boolean data type. Currently I have it set up as a tinyint. Is there a better way of handling this or is tinyint the way to go? Also I want to use a blob data type to store Word Documents that can be anywhere up to 100KiloBytes in... Continue Reading
Views : 105
Monday 26th of November 2012

Extraneous spaces in job text output  

Hi Rather than providing several web-based reports for the company directors, I've opted to produce these with the SQL Server Agent by running the queries as overnight jobs and sending the output to .txt files in a secure folder Everything is absolutely fine apart from... Continue Reading
Views : 165
Monday 26th of November 2012

any1 knows how to code it.  

lets say now i have a SELECT statement tat chooses a number back based on a condition... say mayb the number is SNO.. if there is such an number(does not matter wat is the number) then i wan to do sumthing say task A.if there is no SNO tat match the condition...... Continue Reading
Views : 100
Monday 26th of November 2012

How to return the previous record  

Select lid,datelastmodified,datecompleted,statusid,statusrecordidfrom loan_status where statusrecordid -1 and statusid = 11 Do you guys have any idea, if stating -1 gives you the previous record? Continue Reading
Views : 87
Monday 26th of November 2012

Timeout expired error on SQL Server query with subquery  

hi, i have an ASP page that is querying an SQL database, and a SQL timeout expired '80040e31' error occurs on the recordset.open line. Continue Reading
Views : 286
Monday 26th of November 2012

SQL, .Net, and Crystal Reports version conflict  

I have the following Software Installed on 2000 server box: Continue Reading
Views : 74
Monday 26th of November 2012

using SQLserver db dynamically  

I would like to create program that load SQLserver database file from a mobile disk (eg. flash disk), the db should be flexible to move to any other computer and SHOULD NOT stay in the harddiski've been thinkin of solution:1. i should do automatically attach of db to the... Continue Reading
Views : 193
Monday 26th of November 2012

Need help Installing msde 2000  

Hi there, I have downloaded MSDE 2000 as recommended from my previous post, thing is, there is no better way of saying this, I really do need a Dummys guide to installing it! I have tried to run setup.exe at which point it says I need to set a SAPWD, then I have read the readme where I have... Continue Reading
Views : 236
Monday 26th of November 2012

UTF-8 problem  

hiI use SQL Server database with asp programmingmy pages encoding is utf-8 and all html are okbut when It wants to show database records it looks like unknown symbolesplease help me how to change them and show them correctlyI use nonenglish language in my... Continue Reading
Views : 107
Monday 26th of November 2012

Sql Server Primary Key Violations  

I am trying to upsize an MS Access Database to SQL 2000 and running into problems with som of my append and update queries. In MS access if you run an append query and some of the data your are appending... Continue Reading
Views : 52
Monday 26th of November 2012

ASP application from Access to SQL  

Hello: We recently purchased an ASP application from Development Solutions -www.devsolutions.us online. When we purchased it...we were supposed to be receiving an SQL version. We received an Access... Continue Reading
Views : 102
Monday 26th of November 2012

Gruop By And Sorting Records..  

I need To Sorting the Records by Countign in Group i am execute like this code Code: select name , count(*) as Total from [Table] Group By Namerecords... Continue Reading
Views : 28
Monday 26th of November 2012

Link Access 2000 to SQL Server 2000  

I have a table on an SQL Server, have setup a DSN pointing to the SQL Server and then a link to the table in an Access 2000 database. When using the following code keep getting the error message below: Run-time error '3622' You must use the dbSeeChanges... Continue Reading
Views : 152
Monday 26th of November 2012

Semi Replicating a Database  

I have been looking through google results and have not been able to find what i am looking for:I have two servers, a production and a development SQL server. In the development I have extra users (the developers) that do not belong in the production database. What I would like to... Continue Reading
Views : 66
Monday 26th of November 2012

Which Version of SQL Server Should I Install  

I would like to be able to install Microsoft SQL Server onto my laptop and desktop computers. I did a little research and found out that the latest available is version 2000. But I am not sure if the Enterprise edition is more than I need. Can someone please help me to decide which one to... Continue Reading
Views : 98
Monday 26th of November 2012

sql create database path issue  

Hi, I have a vb application, that uses as sql server database, I install an Instance of sql server, using MSDE sp3. The instance name is Nexus, so on a default machine, it should install to c:\Program Files\Microsoft SQL Server\MSSQL$NEXUS\, which is working... Continue Reading
Views : 135
Monday 26th of November 2012

Creating a Stored Procedure with Code C#  

Greetings, I am trying to create a stored procedure programatically. So far I have not been able to make it work.The code for the SQL statement is this "CREATE PROCEDURE sp_Stored1" + "(@ProductID INT, @CategoryID INT, @UnitCost MONEY,... Continue Reading
Views : 135
Monday 26th of November 2012

error checking in ASP  

hi guys!! i have another problem in my coding... how can i add an error checking in my page?? because i have a customer registration page where a customer will input items the page... how can i have an error checking in the page, just like having an error like "username should not be more than... Continue Reading
Views : 193
Monday 26th of November 2012

probably very simple, saving html in db  

what field type in mssql database allows you to save html? if not how is this done? sorry i know very little. hinch Continue Reading
Views : 133
Monday 26th of November 2012

need help creating stored procedure  

hi , i nid to create a stored procedure which clears the database every 3 monthsfor example on June 1 [sep 1,dec 1, etc] the stored procedure will delete all records dated b4 june 1. i have browse thru different tutorials on the web and have read abt cursors, but i do... Continue Reading
Views : 326
Monday 26th of November 2012

proxy SQL traffic   

Hi Just wondering if it is possible to proxy SQL traffic and get SQL to pop up a user/pass box. I want to access it from another domain, similar to this link... Continue Reading
Views : 35
Monday 26th of November 2012

help with trigger  

I hope somebody can help me, I have inserted the code for the trigger that if/when dates are changed it sends an email like below, but instead of noting that the field has changed and emailing that I need to email and capture the actual date it was set to and I am not sure how to do this. Continue Reading
Views : 249
Monday 26th of November 2012

DTS Scheduling Error  

Hi there,What does this error mean? How do i correct it. When i run the package manually it works fine without any problems...when i schedule it, i get this error.. Code: Continue Reading
Views : 52
Monday 26th of November 2012

How transfer access tables to sql server 2000   

Hi guys. I got a db in access and want to transfer it to sql server with all its reletionship and connect my access bounded forms to sql server . i be happy if some one show me how to transfer my access 2000 tables to sql server 2000 and make connection to sql sever tables from bounded access... Continue Reading
Views : 305
Monday 26th of November 2012

Export SQL data to Excel  

Hello!Is there a quick way to export SQL data to Excel using a command that I can run in SQL Server Query Analyser?I've spent at least 11 minutes reading 'Teach Yourself SQL in 10 Minutes' book to no avail.ThanksEarsbo at work with the cricket on ... Continue Reading
Views : 139
Monday 26th of November 2012