Microsoft SQL Server Forum

Hi all In a new installation, if the data directory is stipulated as d:\data, it installs all data in d:\data\MSSQL\data. I need to place the data in d:\mssql7\data to incorporate backsup from old data backusp Any ideas ?

HI, I have a problem in formula column. I have 8 1 bit varibles in a table for ex: Flag1, falg2, flag3 ...Flag8 Now I want to create another variable as a small integer and copy all the flgas to that field. For ex: (flag1 << 0x80) | (flag2 << 0x40) | ..... | flag8

Hi, I would like to know if anyone out there really uses SQL Server 2000 (which edition?) to hold the data for a data warehouse? How much data does it handle efficiently? TIA Frank

hello all i am having some problems calling a stored procedure on MSSQL2000 from VC7. i have build up an OLEDB-Consumer (for stored Procs) via vizzard and modifyed it a little, to bring in the cloumn and param map. when i start the program i can call OpenAll() and the system gets the recordset from the DB. but data is corrupted :( also the...

Hello all, I have been trying to find some information about exporting data from postgresql on linux to ms-sqlserver 2000 on windows but have not been able to get hold of any information. I would really appreciate if someone can point me to some source of information. Thanks in advance, Nishy

Anybody know if there is a system function that can be used from a stored procedure that determines if a given primary key has existing dependencies? I want to make a check for this and if there are none, I will delete the record. If there are, I will change a field called bitStatus from 1 to 0. Enterprise Mgr. does something like this under...

Hi I've not used SQL Server for a while, and I've forgotten how you hide all those system procedures (beginning with dt_) in Enterprise Manager. Could some kind person please refresh my memory? Thanks Captain Nemo

How to get data from cubes in analyses manager to MS access using for example ODBC ? Does existe any other posibilities to get data from cubes directly to the accees ? thanks Kris

Hi; I'm brand spanking new to sqlserver ( nice so far ). I need to make a simple data change across a list of tables. Basically replace an old date with a new date. However, the people I am doing it for want a program that produces logging of what it does.

What is/are the differences between narrow and wide indexes ?

When a covering index is used by a query, how to improve the performance ? - data is stored in sorted order by the index OR - all of the data in SELECT list is available in the leaf nodes of the index OR - the resources of multiple hard drives are leveraged OR - database fragmentation is avoided through the use of index ?

Do you know what RAID type is housing the transaction log ?

#temptable (order, name, activity and count): 1 mark1 null 0 1 mark1 movie 5 1 mark1 game 4 1 mark1 game 3 2 mark2 null 0 2 mark2 sports 6 2 mark2 game 4 2 mark2 game 3

Hello, I am running SQL Server 7 on a Windows 2000 server, with aprox. 10 databases. The largest database is 1,5 Gb the smallest 10 MB. The databases are used as databases for various websites. My problem is that (since a few days), when I start the MS SQL Server 7 service, the process (sqlservr.exe) is directly increasing fast to...

A lot of our data is in a database originally provided to us by a vendor. We can add tables to the database (although we prefix them with our own company name), and stored procedures and our own triggers, as well. However, we have been hesitant to change the vendor's tables (despite serious flaws), as our changes may get lost whenever we...

#temptable got order,fname and age. trying to find two high maxes per each order. query returns (1) but (2) is correct answer. supposedly, max(age2) < max(age1). **** select d.order,case d.t when 1 then s.fname else null end as fname, case d.t when 1 then s.age else null end as age1, case d.t when 2 then s.fname else null end as fname,...

Having decided not to use the undocumented checksum in SQL 7, we are now using SP_TABLE_VALIDATION to work out the checksum of a table. We have an issue in that we are calling it from a VB app and we get the message back stating how many rows were counted etc. but it also returns an error code with the message and stops the VB app getting...

Which of the following does NOT cause the execution plan of a query to be recompiled ? - new column is added to a table accessed by a query OR - index used by a query has been dropped from the database OR - query perfoms a join to return data from multiple tables OR - significant amount of data in a table has been mofified

I've been getting 3-4 notifications per week from Norton's Personal Firewall to the effect that somebody tried to get into my system to insert this thing....and I don't even have cable or DSL - just dialup. Anybody else getting this? Could Norton be a little oversensitive in this area? I've got SQL server running on another box that's...

I need to extract data from this table to find the lowest prices of each product as of today. The product will be listed/grouped by the name only, discarding the product code - I use SUBSTRING(ProductName, 1, CHARINDEX('(', ProductName)-2). I can get this result, but I had to use several views (totally inefficient). I think this can be...

I got an assignment usig perl and xml. And I was told to design the database. I'd like to know that how one would structure the data storage and retrieval process on a site which stores a range of data on a particular entity, keeping in mind that we may wish to add or delete fields in the future, and how the data for any one field would...

Hello, I have query joining several tables, the last table is joined with LEFT JOIN. The last table has more then million rows and execution plan shows table scan on it. I have indexed columns on which the join is made. If I replace LEFT JOIN with INNER JOIN, index is used and execution takes few seconds but with LEFT JOIN there is a table...

How would I write a trigger that updates the values of a Description column to upper case for even IDs and to lower case for odd IDs? I need this trigger to fire for INSERT and UPDATE events.

is it possible to do: (A) declare @numberofitems Int @numberofitems = select max(itemorder) from store, department, etc. and pass the @numberofitems to a #tempStore table, like: (B) (store, department, @numberofitems,...)

Hi, We have an ODBC/Visual-C++-6 -bases application (currently working with both MS-Access and Postgres) and want it to also cooperate with MS-SQL-server and MSDE. Since we don't want the user to wade through the ugly ODBC-setup, we have our own dialogs (e.g. the usual file dialog for MS-Access) and build the ODBC-connection string from the...