Hello, I have a question regarding stored procedure desing that provides the optimal performance. Let's say we have a table Products that consists of three columns: Name, Status, RegistrationTime. All columns are indexed and users should be able to lookup data by any of the columns. We have...more >>

Is possible in SQLSERVER to use a syntax like this? select x,y from table_1 where (x,y) not in (select h,k from table_2) I've tried, but it doen't work. Do you know any workaround? Thank you Fede ...more >>

I'm a beginner in using SQLServer and I 'm trying to bring a db Schema written for DB2 into SQLServer. My problem is this: using a tool to translate the script for creating the DB, I obtain the following code: ALTER TABLE PROJECT.RSURETTA ADD FOREIGN KEY(VOCE ) REFERENCES PROJECT.RSANVOCE(VO...more >>

Is there any problem with implementating some kind of replication and backing up transaction logs at the same time? SQL Server 2000 Standard Edition The server is configured to back up log files regularly, with the presence of a(New) Disaster recovery server and with an inability for standb...more >>

I have MSSQL2k SP3a on WIN2k SP4. moved a Date/log files to this server about a week ago from a SQL7 server and attached it to this new Sql2k server. everything works fine for about 24hrs and then it starts timing out !! all I have to so is restart the MSSQL service and works fine again ...more >>

I have my SQL 7.0 server set for Mixed security. I see now (finally) the advantages of having windows authentication security for windows groups. I do most of my developing in Access Projects which require a login of some type. I have been using my SQL login to develop with SQL and then when ...more >>

hi, There is facility to do backup of the database. I can use that facility to backup the database. But before i do a backup i want to check if the disk space available enough to backup that database. I have a 22gb database mdf file, when i took a backup of that its only 3gb. SO i cannot use ...more >>

How to use a dsn-less connection from DTS? Source: MySQL Destination: SQL Server 7.0 I have the ADODB.connection code but unsure where and how to use it. Pls advise. TIA! Bob ...more >>

SELECT DISTINCT product.product_id AS Expr1 FROM [SELECT product.product_id, product.item_name, product.display, product.selling_price, product.smallpicture, product.main_size, product.main_dinnerware, dbo_coupon_special.coupon_id, dbo_coupon_special.special_price, coupon.effective_date, coupon...more >>

Hi all, Have a situation that my company has never run across before. Client is running NT4 for the domain server, using terminal services 2000 and running an application with a SQL Server backend and they are experiencing locking problems. Once one person gets locked out then everyone tryi...more >>

Hi all. I have a simple vbs script I use to connect to sql server, try and read from a table, and if it fails notify me that the sql server might be down. Works fine in its very simple way, but what I am wondering is if I should try and connect to one table from every specific database on the se...more >>

In the code below I get an Internal SQL Server error in Query Analyzer. Ultimately I want to get thos code working in a function. DECLARE @WeekNumber tinyint DECLARE @Comp decimal(18,2) DECLARE @PeriodFromDate datetime DECLARE @PeriodToDate datetime SET @WeekNumber = 27 SET @PeriodFromD...more >>

I am trying to run the following query: ALTER TABLE dnb_profile ALTER COLUMN [family update date] datetime and I keep getting the following error: Server: Msg 242, Level 16, State 3, Line 1 The conversion of a char data type to a datetime data type resulted in an out-of-range datetime va...more >>

I have tried to set up log shipping for one of our databases - first time. Using EM I was able to create the job and maintenance plan sucessfully. I wasn't able to find any errors in any logs. In the monitor server, when I look at job history, everything is getting copied and loaded sucessfu...more >>

Hello, We have a SQL 2000 installation (running on NT4 SP6a) with a database accessed by a client application. Currently the application logs into the database using a the SA account. I'd like to move the client access over to Window Authentication. Each user has their own NT account. What ste...more >>

I have a strange performance question hopefully someone can clarify for me. I take a production database and make a copy of it, called test, on the same instance on the same server both running at the same time. All the same things are running for each database and no one is using each database ...more >>

hi pls tell the site's where i can download free e-books, bye, s.premkumar...more >>

Hello, I am having difficulty with global variables in DTS. Specifically I would like to instantiate a global variable with a value obtained from a SQL database. I have created the global variable through the package properties section. Now i need to instantiate it with a value from the d...more >>

I have an application that lets users upload pictures. These pictures are stored in different folders depending on the user ID (of the user that it belongs to). The path can be figured out dynamically by knowing the user ID. However, the programmer that's coding my application has decided to ...more >>

I'm getting ready to start a fairly large application to be hosted on SQL-Server. In the past I have used Access 2002 (as a front end, wasn't happy with the number of bugs I ran into), PowerBuilder 6.5, Oracle Forms 7 years ago (also no happy with the number of bugs). I was curious what the st...more >>

Version: SQL Server 7.0 App: MS Access 2000 I created DTS to move records from MySQL to SQL Server (approx over 500,000+ per months dataset) for purpose of canned and adhoc reporting. The app have a simple interface using MS Access where user will input the timeframe of the dataset they wil...more >>

Hello I have to tables ar and arb, ar holds articles and a swedish description, arb holds descriptions in other languages. I want to retreive all articles that match a criteria from ar and also display their corresponding entries in arb, but if there is NO entry in arb I still want it to sh...more >>

my analysis server is hosted on a win2k server with IIS, the hosting page is on another machine. I have followed everything as per MS KB article and I could not connect through the analysis server using http. i have similar implementation on my dev machine but the main difference is my OLAP is...more >>

Hey all, I have a basic table that looks something like this. CREATE TABLE MyTable ( ID INT IDENTITY PRIMARY KEY, Company_ID INT NOT NULL, Round VARCHAR(50) NOT NULL, Details VARCHAR(250) NOT NULL ) It has a few rows of data that look like this: Identity Company_ID Round ...more >>

If you use the command UPDATE <tablename> SET <fieldname> = ' ... ' to update a CHAR or TEXT field there are some characters that can cause problems such as a single quote. Are there any other type of charaters like that? TIA ...more >>

This might not be possible, but on the chance that it can - is there a way to do the following: Given a arbitray one dimesional value list: ('AALGX','12345','XXXXX','AAINX','AMMXX') Is there a way that I could do a select statement, or similiar, in the value list, to get the following resul...more >>

What am I doing wrong in the following snippet of code? ----------------------------------- declare @FullPath varchar(255) set @FullPath = 'C:\MyDir\MyFile.txt' bulk insert Northwind.dbo.Sometable from @FullPath with (FIELDTERMINATOR = ',') ----------------------------------- This w...more >>

I have a user defined function that may be called multiple times in the same query - here's a rough example select col1, get_random_number(), col2, col3, get_random_number() from table1 The problem I am having is that I need to have both calls to the user defined function return the same va...more >>

Hello all, I just started a new job this week and they complain about the length of time it takes to load data into their data warehouse, which they do once a month. From what I can gather, they rebuild the indexes before the insert with an 80% Fillfactor, then insert the data (with the in...more >>

I want to move my Access 2K database into MSDE. The Access Upsizing Wizard crashes (a known bug wi A2K), so I'm using the following suggested method: Access --> New --> Project (Existing Database) This asks for the name of the .adp file to create and then launches into the Data Link Pro...more >>

Hello all DBAs what is the best methodolgy to replace a server with a new server in a multiple sql server environment.. Is is using back up/restore to another/bridge type server then rename servers or is it to bring in new server then tranfer the datafiles. Does tranfering the data files includ...more >>

I have a problem trying to get a value from textbox 1 and textbox 2. If those two values match the data in the database then it has to return a third corresponding value to a third textbox (or label) after a user clicks a submit button. Basically, I am trying to allow users to enter a value of ...more >>

I am new to SQL server and I am looking for the best practice regarding the following: The GUI for the database I am creating has a number of questions like: A. Where are you currently living? 1) In my own home 2) In the home of a family member 3) In a shelter 4) On the street However, f...more >>

Hi All, I am close before throwing the machine out of the window. I tried to establish a linked server on our SQL2000 server pointing to a DB. EXEC sp_addlinkedserver @server = 'DB2', @srvproduct = 'IBM OLE DB Provider for DB2 Servers', @provider = 'IBMDADB2', @provstr='DSN=JDE_PROD;UID=XXX...more >>

I am running SQL Server 2000 SP3 on Win2k Server. I have just built a new maintenance plan that first backs up the database, then analyzes it for allocation and rebuilds indexes. Below is what I am using: exec xp_sqlmaint '-S SCDEV -U "sa" -P <my_sa_password> -D ScProd -PlanName Web_DB_Backu...more >>

Hi, I have a stored procedure, that works perfectly when run from the query analyser, however if I run it through access vba, (using exec) I get a runtime error 208: invalid object name '#tmpContact'. Any ideas why this happens? The temporary table #tmpContact is used in the procedure, b...more >>

I need some help with the following query: DECLARE @SRV VARCHAR(20), @date smalldatetime SET @SRV = (select @@servername) SET @date = '20040901' select Srv_Name = @SRV, DB_Name = 'DB_NAME', Table_Name = 'Info_Table', Date_of_Records = @date, count(*) AS 'Actual Total' , max (SER_NO)- mi...more >>

Hi all, I am trying to perform a delete that I could achieve in Access but need to do this in sql2000. I have two tables Warranty and Registrations. I would like to delete all items in the warranty table where there is a match in registrations on a common field. I access the query would be:...more >>

Hi! Stupid question as this also depends on hardware but is there a limit on how many rows I can have in a single MSSQL 2000 table? Table consists of six int columns and has three indexes. Is like 10 Million or 100 Million considered to be 'normal' or unrealistic? Thanks very much for your ...more >>

I have the following Question: Is it possible to install a Reporting Service at IIS Webserver without SQL Server 2000 on the same machine. We have a Enterprise SQL Server at another machine and i don't want to install another SQL Server at a IIS. Thank you for all responses Flecki...more >>

Hello all, First of all, I must state that I'm new to SQL Server, but have been a long-time software guy for quite some time. Please excuse the potential simplicity of the solution to my problem. I create a blank database (TestDB) under my server machine (SQL Server 2000 Standard)... I ...more >>

After having seen my co-worker reinventing the wheel when he busily labored to build MS Access framework, I want to share my perspective. Having experienced with Access, Visual Basic, Visual C++, and PowerBuilder, I think Sybase's PowerBuilder is the most productive tool to build front-ends f...more >>

I am trying to using sqlserver as back-end for an application(web) running on the window 2X, one thing I am not sure is that once I establish the connection between database server and application, should I keep this connection open while application is running, or only open it when there is a r...more >>

hello friends I want to specify a field to save icons I want to give this field a maximum of 120kb for each icon to be stored in the db. what datatype should I assign to this field and how do I specify the size ? Thanks Tom ...more >>

Greetings All, I was hoping that a replication sage might be able to answer a question for me. I want to have one subscriber subscribing to N publishers. I essentially have a company that has a main headquarters and three satellite offices. I want each of the satellite offices to push their ...more >>

Dear Group, I have a table in the a database that I need to change the owner to dbo. How can I do this. Thanks in advance. Jeff Magouirk ...more >>

I am working with an application that is returning a second based timestamp. It returns values based on the 86440 second day in GMT. Is there an ability within SQL Server to convert the value into an hour time value? I need to take this value and convert it to a hour value for the time zone...more >>

Dear All, W2000 Office2000 Access adp SQLserver DB Problem: Adding a new property for a company in the subform. The FIRST time I Select a property in combobox CPROP_PRP_ID the subform act strange. 1. The selected value doen't show in the combobox! 2. The sortorder of the subform change...more >>

Do any of you know if it's possible to get the name of your field from another table? E.g. Select FYear as [Select description from YearTable where category=1] I need the name of the fields to be user defined and the only way I can see this happening is through a table. But now...how do ...more >>

Hello to everyone! How can I print the structure of a table from the SQL SERVER ENTERPRISE MANAGER? Thank You Fabio *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

Hello to everyone I am using SQL Server Enterprise Manager and I would like to print the structure of each table of a database, with the purpose to see the whole record layout. (In Access there is Analyzer which does that) but apparently I acnnot find anything similar in EM. Who Could help me...more >>

Hi I am trying to implement a invtentory control system and would like some advice on the best design for it. The system will have to main tables Product and Stock which will look as follows Product ------- ProductId PartNumber Description Stock ----- StockId ProductId SerialNu...more >>

Hi All We are running SQL Server & Outlook with an exchange server. We are looking for a way to import the address book & email details into a database table. We have managed to do this with MS Access by using the import option exchange(). Is there a similar way this can be done in SQLServe...more >>

Anyone knows what would cause this?When Enterprise Manager is used to open a table Runtime error data provider or other service provided an efail status...more >>