hi all we have a mysterious issue. one of the tables from our database was dropped. the developer swears he never did it and nobody else seems to know anything about it. there's nothing in the log files, but i'm not sure the log files cover these kinds of transactions. if this were logge...more >>

Hello In my stored procedure, I need to check if a value in a field is a valid file and then proceed to do other things. Is there an equivalent of system.IO.File.Exists (like we have in vb.net) in sql server that I can check in the stored procedure? Thanks sue.. ...more >>

Man, talk about "jargonified" (George W Bush)...(he didn't really say that, but you almost believed me!). :o) I've been trawling through the "help" section of SQL Server Management Studio Express but can't I find any (plain English) instruction on how to simply import/export data to/from an A...more >>

I'm starting the database structure from scratch, and I'm wanting to make a decent go of it, I'd like some advice, if possible. Everything is based on the BusinessEntity table: [facID] [int] IDENTITY (1, 1) NOT NULL , [orgID] [int] NOT NULL , [regionID] [int] NOT NULL , [portfolioID] [int...more >>

Hi, I can't Copy a database from Sql Server 2000 to 2005. I am using the Copy Database option from Management menu. I want to transfer all tables, and all stored procedures. I've tried everything for the past 3 days, and it didn't work. I always get the same error. Below is the error that I...more >>

Bonjour, J’ai un truc assez basique sur lequel je m’arrache les cheveux. On a demandé de faire un Transfer de donnée. Je dois utilisé un select et uniquement une clause select en SQL SERVER 2005. J’ai une table avec 5 champs Id, X1,X2,X3,X4 Comment faire pour trouver le X? qui a la plus gra...more >>

Hi, I'm trying to create a linked server to an access database (version 2.0). The linked server was initially setup several months ago and all was fine - running queries worked exactly as expected. I believe that a recent update to the SQL server box has resulted in the jet driver being up...more >>

Hi, I'm having trouble with a new installation of SQL Server Express I did a full install of the product Installed the Express Management Console Installed SQLCMD Created a test DB and a login Enabled all network protocols I have been able to log into the server and execute commands wit...more >>

I am taking Microsoft Course 4329 on Joining Data from Multiple Tables in SQL Server 2005, and I am stumped in the Lab, Task 2, Step 3. How can I rewrite the following SQL Statement to produce the same results by using a non-equality operator in the join? use adventureworks select firstna...more >>

Is there a way/tool to rename a database in SQL 2000? I do not mean a field/file or something but the name of the whole database. I tried it with SQL Server Enterprise Manager, I can change a lot of things, but in the tab 'General', the Name label is passive. I could of course backup and resto...more >>

I have a Table imported from text file containing Records of books. BUT the fields and data value is entered as the First and Second Column (ColA, ColB). The records are separated by 2 empty rows. Some fields are missing for some records: Some records may miss the 'author' whereas some records ...more >>

Here is a simplified example of a SQL Statement that is executed with a DTS Package nightly within a SQL Server database: DROP TABLE table1 SELECT db1.dbo.view1.* INTO db1.dbo.table1 FROM db1.dbo.view1 This deletes a table, and then makes an updated version of the ta...more >>

DELETE FROM PlayerRevisionScores WHERE RevisionID IN (SELECT RevisionID FROM Revision WHERE RevisionDate < (SELECT RevisionDate FROM Revision WHERE RevisionID = @nRev) AND ClubID = @nClubID) Revision Table - Primary Key is RevisionID, an Integer. Player Revision Sc...more >>

Perhaps somebody can point me to good step-by-step guide to solve my very common task. There is table "SomeTable". There is field "Status" there. Some process need to process rows in that table when "Status"="Pending". Of course I want to do it without checking such rows every some period of ti...more >>

Hi all, I've got a weird question: is it possible (and if yes how?) to select from a table all fields whose name starts with e.g. 'b'? For instance, if we have PERSON(ID, Name, Phone, Birthday, Block), a fictional statement such as SELECT starts_with('B') FROM Person should return two columns...more >>

I was provided an Excel file to import inventory count data. I imported this Excel file to a temp table then use that to populate inventory. The problem is that the Excel file contains duplicate records. A record is a duplicate if Item and Shelf are the same. Example: Item Shelf Q...more >>

Hi, I am a .net web developer and i'm developing a database driven web application. I have 2 questions about sqlserver database design. 1. Let's say it's a online store, i have several tables in my database, like SalesOrder, Production, CustomerInfo, ProductionDescription, etc., each time...more >>

Hello, I have installed SQL Server 2005 in my PC and during the installation I have created a predefined instance (I have used Windows autentication). I could use correctly SQL Server till some days ago, when I changed the password of my PC login profile. Now, when I open SQL Server, if I clic...more >>

Hi: I want to know if it is possible to query a linked server using a variable as the query string--I get syntax errors when I try this: DECLARE @QryString varchar(256) SET @QryString = 'SELECT * FROM SybaseTable' SELECT * FROM OPENQUERY(SybaseServer, @QryString) Thanks, Kayda ...more >>

I have a field in a DB that I want to update with the contents of a text file. I retrieved the contents of the text file FROM the entry but now that I edited them, I want to put them back. This text file has only a single entry in it. No row/column delimeters needed.I tried using the Enterpr...more >>

Why would a SQL 2000 database that is used actively every day by 4-5 users hitting it with hundreds of CRUD transactions per day have a LDF log file date that hasn't changed in several months? Details below: The db has only 1 mdf and 1 ldf. The mdf is about 3 gigs, ldf is 100 MB. Both files ar...more >>

Hi All, Me and a co-worker of mine are dba's (and pretty much everything else database) for a customer service area of a financial company. We took over a system that looks like this: Backend - .MDB that sits open on a machine all day (The only purpose of this machine). The database has a...more >>

Using sql server 2000... Does running a backup using a DB Maintenance plan cause the transaction log to change or get truncated ? ...more >>

Hi there, I have a data migration question -- Hope this is the right place. Can you use SQL 2005 Mirroring (or something else) to replicate inserts/updates, but not deletes? In my case, the reason for doing this would be to move data off OLTP servers to OLAP servers in a timely and reli...more >>

Hi, I am just upgrading from SQL 2000 to 2005.Previously I used to query info from SysXlogins table in SQL 2000, but in 2005 that table is not present. Any table is SQL 2005 which can give me the same info as SysXlogins? Thanks in advance ...more >>

Hi, My goal here is to be able to generate a clean database when needed. I'd like to be able to keep a database schema script in version control, then run it whenever we want to scrub our database, or move to another server. I can generate a "sql script" via the All Task -> Generate SQL S...more >>

Hi, Need some advise before I kill my SQL2000 server :) Some time ago I upgraded to SQL2005 but still have SQL2000 server with couple databases. And I need to free up the hardware box and move SQL2000 to a different server. Will this scenario work? : - install OS and SQL2000, same leve...more >>

Hi: I am using a test SQL Server 2005 database and was finding queries were not completing. I stopped the queries so nothing was running, restarted SQL Server and now when I startup the database shows as "in recovery". It has been stuck there for a few hours. Any way of figuring out if it wil...more >>

I created a maintenance plan that should backup up our database once each night to a network drive. I have it setup with a domain account and it does work when I 'Execute' it, but it does not work according to hte schedule. Has anyone ran across this before? I was using MS SQL 2000 till about...more >>

Here is an extremely simplified copy of a table I have: Table1 Field1 Field2 1 D 1 B 2 D 3 B 3 C 4 A 4 C 4 D 5 A 5 D 5 B 5 C 6 A 7 B 7 A 7 C I would like to create a view to display records with distinct values for Field1 where there is not a value of D in Field 2 within ea...more >>

Client is running free version of MS SQL.. He is using this with a proprietary software. He has now reached the limit for SQL. He has purchased SQL Server 2005 and needs to get it installed. Would like to know the steps on how to install of SQL 2005, and how to move the database over to S...more >>

Hello, Does anybody know if I could use my SQL 2000 use/device CAL's for SQL 2005? Say I have a SQL 2000 server which has 50 user/device CAL's that I am retiring for a SQL 2005 server. Could I use the 50 CALs towards the new SQL 2005 server? Thanks ...more >>

Hi all, I am new of the group and I hope that you can help me to resolve the "problem" that plagues me... I must unload the data of many tables (... some of which rather large...) from 4 DB ORACLE on my SQL Server 2005... I have created therefore 4 linked server on my SQLServer that is connect...more >>