Hi: I have a download form. On completion the information is saved into the database and a unique username and unique password created, additionally I save the datetime for when they form was submitted. From there they go to a login page. On login (checks for the unique username and u...more >>

Is it possible to return a table with different type/number of fields from a UDF depending on some input parameters? Thanks Yannis ...more >>

Greetings, I've seen this done in other places...I wish I had paid better attention because I can't remember how it was all done. But can someone point me the resources to accomplish my stated desires to FTP a file from within a SQL Statement and also to run an .EXE from within a SQL Sta...more >>

I have an application that I would like to begin selling on my website. I would like to create an eCover for my software so that it will present a professional touch to my product. Currently, I will only be selling the software via an electronic download. I've seen many websites that util...more >>

First, this is an abuse of cross. Second, you have future-posted. Hopefully everyone will ignore your post until you show a little courtesy. ...more >>

I am trying to find and debug errors in distributed transactions. I have altered many of the 7300 series of errors so that they are logged in the SQL Server Error Log file. The problem I am having is that the error messages represent the values stored in the sysmessages table, and not what wou...more >>

I need to import an Oracle Database into SQL Server 2000. I know this can be done easily using DTS but I do not have access to the Oracle Database, I only have an Oracle Database Export File. The Export file has been generated using SQL*Loader. ...more >>

My original intension is turn off the IDENTITY column and renumber the each row. SQL Server thrown an error that I can't do that because it is an IDENTITY column even I turn on using SET IDENTITY_INSERT <table> ON. So, is there any T-SQL statement to remove that IDENTITY first, then I'll ...more >>

Hi there ... after much research i still can't quite find the right answer to this problem, so here goes. I'm trying to find a simple, robust and scalable way to manage unique identifiers in my database system. The system generates paper forms containing the UIDs and sends them to customers, s...more >>

Hello all, I need to add Year & Months to a persons age from a datetime (DoB) field. The current script I have (as below) can calculate only Years but NOT months. Does anyone have any idea or a ready script that I can use which will give me months & years for that person using the Dob fi...more >>

Hi All, How do I know or Display the Name of the DB to which I have connected? Like : SELECT @@SERVERNAME will Give the Name of the SQL Server Name. Thanks Prabhat ...more >>

I am experiencing problems similar to those that have been posted here... Currently I get a DCOM error shown below: Event Type: Error Event Source: DCOM Event Category: None Event ID: 10009 Date: 1/21/2005 Time: 4:28:10 PM User: vadoc\vadocsql Computer: DOCCORIS1 Description: DCOM ...more >>

I am currently setting up a new SQL box that I intend to have two RAID arrays: a RAID 5 for data files and OS and a RAID 1 for the log files. In my previous RAID controllers I was only given a choice in for the RAID 5 stripe size, which I have set to 64K but this new controller I am using als...more >>

I am using a linked server to connect SQL Server to an Excel Spreadsheet on the network. If I'm physically on the SQL Server box I can open the linked server and see the named range on the desired spreadsheet. Also If I'm on the SQL Server box I can query the spreadsheet using OPENQUERY and ...more >>

Could someone explain why it is better to properly size a column? Or = explain that it is not better if that is the case. Here's an example to = illustrate: If I know that a particular varchar column will hold strings between 1 = and 8 characters long. However, rather than a varchar(8), I s...more >>

Hi, I have a server A and a server B. I would like users to be able to use the copy database wizard to copy databases from A to B. what is the basic permission I need to give to the uers on Server B? Thanks Ed ...more >>

In my Agent table I have a column called Name and SMGROUP in which I have a question. The table can have the following agents 1070 1070ME 1070YOU 1050THEM All of these belong to the same agencycode I need a query that will show me if there is at least one "Principal" in the SMGROUP col...more >>

I am using the following query that is not returing the results I need. SELECT * FROM dbo.MonthlyUnapprovedTime WHERE EmployeeID = 123456 AND uMonth <= datepart(m,'5/1/2004') AND uYear <= datepart(yyyy,'5/1/2004') On the table below [dbo].[MONTHLYUNAPPROVEDTIME] ([MU_ID] [int] IDEN...more >>

Hello, I´ve got the SP below that dinamically generates a filename to load its content into a table by using a bulk insert into a table. The issue is that I have to play with different quotation marks (simple and double) to form the 'bulk insert' line to be executed by using exec. If I try ...more >>

Is there an easy way to determine the IP-Address of the connected client like SYSTEM_USER does for the userneme? thx, Gerald. ...more >>

I would like to know if an "IF" statement can be used in a view? I would like to create a view and then based upon a value the view will have the correct filter of data. Or do I just need to create a different view? If this value = "Europe" then show all Europe info. If this value = "Asia" then...more >>

Hi! In a database server the system calculates the result of a (quite complex, indeed) view. In the copy of the same database this is done much faster (about 10secs instead of more than 1 min). In the slower one I did a lot of backup and restore, maybe that caused some fragmentation in the datab...more >>

I have an installation question for SQL 2k analysis services... the os is w2k3. I have installed sql2k once, with sp3a. then i installed reporting services on top of it. later on, i decided to add Analysis Services, because the Foodmart report sample in reporting services didn't work. but sql...more >>

Hi All, I have a table that I wish to group by the change or switch in the "PaidOnTime" column while sequenced by descending invoice # I have read a bunch of gr8 articles that describe this situation... i.e. http://www.databasejournal.com/features/mssql/article.php/10894_2244821_2 http:/...more >>

Hi I am reviewing a number of SQL Scripts written. I have always used DateAdd when adding and subtracting days from dates. The programmer who wrote these scripts just used "DateField - 3" etc instead of DateAdd(D, 3, DateField) Does this work the same? Thanks Ben ...more >>

Hi: I'm looking for a place where I can see the currently active users (and maybe the tables they are using?), is this possible? I'm using SQLServer 2000 with the latest service pack available. TIA, Martin. ...more >>

I have a table with prod, prod_desc The data in the table is as follows: XXX XXX-- product 1 YYY product 2 PQR PQR product 3 I always need the prod_desc to be prod--prod_desc (I have no control how the data comes in the prod_desc column) In the above example it would b...more >>

How to create trigger on the table1, which before insert change one column value to another same value on the table1. thankx ...more >>

We have recently set up a new sql server (2000). I realize that the dates are not handled correctly in code. However in the meantime I need to fix this issue asap. Is the Set Dateformat command permanent? The reason I ask is that in our present databases UPDATE Project SET LastUpdated ...more >>

Hi all. If I have an open cursor in a stored procedure, and an error occurs in a SQL statement, what will happen with the cursor? Will it still be closed and deallocated? And what if I were to write... if (@@error <> 0) return(1) ....inside the cursor loop - would the cursor be cl...more >>

We have a .NET application that uses salt and hash to store encrypted passwords in our database. However, we need to receive "new" passwords from an informix database which will be sending us the original password unhashed and without salt. We have no control over this. We could have a .NET ...more >>

I am writing about 10 million records to a table that contains a clustered index via C++. I create a table lock, drop the index, execute a bulk insert, and re-create the index. The C++ application writes the data in order so that when I recreate the clustered index there is no movement o...more >>

Hello, first of all, thank you for your time. I am looking for feedback regading a table partioning concept. Any suggestions or links would also be appreciated. Background: I have a denormalized table (used for a data warehouse and reporting solution) that contains millions of rows and ~2...more >>

Using http://support.microsoft.com/default.aspx?scid=kb;EN-US;q186133 I can easily rank individual rows However - I am trying to Separate Groups By a Condition ----Input Table Invoice PaidOnTime 1006 Yes 1005 Yes 1004 No 1003 ...more >>

Is there a function in sql that will return the name of a month from an integer? I don't want to write my own. ...more >>

I have a query which returns 3 columns: site_name | site_id | state A | 1 | Texas B | 2 | Texas C | 3 | California D | 4 | Florida E | 5 | Florida F | 6 | New York I group by the state Id like to get output like California C | 3 Florida D | 4 D | 5 New York F | 6 Tex...more >>

I have created an indexing service that populates a details table with the stripped out phrases from the web pages. The details table has a few fields including: iParseID int (primary key) iPageID string sPhrase string iRank int The iPageID field contains a GUID value that forms the re...more >>

Hello.. Here is what I want to do... And how I want to do it.. The question is Can I do it? I have a string of about 25 characters in length. The string can only contain the lower case of the alphabet. Any other character needs to be removed. My thought is to create an array loop throug...more >>

I am modifying my application (a PPC application in eBv) and my database to update with a new procedure that requires the use of a recursive trigger. I am using SQL2000 to push data to a PPC with SQLCE. On my sql2000 I have a trigger on the table MDTLink which is the same table that is pulled ...more >>

Is there a way to output a declare table using the following sample using exec sp_xxx as a source of input to the declare table. We have a variable that is getting parse from an xml document then a stored proc is executed dumping the data into a temp table. I would like to basically get ...more >>

Is it possible to use a stored procedure to insert into a table variable in layman's terms here is what I'm trying to do... Here is the first Proc ****************************************** Create Procedure dbo.sp_Test as select 'Now','Then','Later' **************************...more >>

Hello All, how can I check by a comand line command where my SQL Server 2000 was installed? Thanks in advance Marek ...more >>

I currently trying to wirte a reconcilliation program to Reconcile client data on a daily basis. The client connects to our FTp servers and uploads files and downloads reports. The FTP server is a third party peice of software that writes all information into a text log file. I have got to t...more >>