Hi I need to upsize an access 97 app to sql server. Is it possible to upsize is directly or should I first upgrade the app to access 2003 before upsizing? Is there an upsizing wizard for access 97? Thanks Regards ...more >>

I did an upgrade of a site system, computers and servers from NT4 server and workstation to Win2K server and XP workstations. I made a backup of the datatbase (SQL7) and did a restore on the new PDC (SQL2K server). Did a change DB owner and then preformed another backup from the PDC to move to...more >>

is there a good proceedure for transfering DB files from one server to another for failover. To clairify, I have 2 servers one primary the other backup. I want to regularly transfer the DB from one to the other so that if the primary fails they can switch to the backup and the DB will be fairl...more >>

Has anyone had to encrypt the credit card numbers for storage in a SQL Server 2000 database? We have credit card numbers stored in several tables and these values need to be encrypted. The values are used by many different stored procs that need the credit card number in the clear.. I hav...more >>

In SQL Server Configuration Manager I cannot connect to WMI provider. I have permission. I don't knowing mount the MMC in windows XP to SQL Server 2005....more >>

Is sql server 2005 fully backwards compatible with sql server 2000, or are there major upgrade issues. Thanks, -- Rick...more >>

I am considering purchasing Visual Studio .Net 2003 ( just over $1000 CDN at Future Shop ). I have spent hours ( actually days and weeks ) trying unsuccessfully to get Express Edtion of Visual j# working - keeps hanging - tried everything including re-installing Windows - anyway besid...more >>

Hi I have a fairly complex access frontend/backend app which I need to upsize to SQL Server. At this stage I would prefer to use access as frontend. I have the following questions; 1. Should I keep using the mdb as frontend or switch to an adp (access project) instead? Any reasons? 2....more >>

Hello, I have a db server that has to be open to the internet.. and get 'hackers' trying to login to sa/power all day The thing is, the connection is 'force encryption' , so I cannot snif the traffic.. and since these 'hackers' are using their own tools, cannot tell their client software to s...more >>

I had to convert a database from VFP into SQL 2000. I have a primary key I have added, plus I have properly indexed the table as well. Unfortunately, I cannot create a query that supports the TOP clause. SQL Server keeps returning "Incorrect syntax near '100'" The user DBO has permissions to ...more >>

Hi, I am currently new to microsoft sql server, so following a book I need to create a empty database (is ok), afterwards I need to run a script (name.sql) against this created database. The problem is that I don't know how to do this (after having struggled for one hour with the import ...more >>

Hi: I'm running a software upgrade process on our server. The application sits on SQL Server 2000. In the SQL Trace, everything seems to be running fine. But, every so often, I'm seeing a message saying "Select N'Testing Connection". What does this mean, out of curiosity? Thanks! ...more >>

Hi I am running my sql server 2000 server and agent as a service with domain admin user. Is this recommended? Who should be the job owner? sa or application user? Can the job be run by any other user other than the user who started the sqlserver agent. TKS Mangesh...more >>

I have several tables containing 150+ million rows. SQL 2005 June CTP is failing on the create clustered index with the following messages. Anyone seen this before? CREATE UNIQUE CLUSTERED INDEX c_c ON PREMI60SOURCE.DBO.XSTAGING_EN(ID,FDATE,EDATE,PROD_TYPE) Location: fgcb.cpp:409 Exp...more >>

Does the Developer Edition Beta2 contain fixes not in the June CTP? ...more >>

I'm new to sql what do you type in at the top of the Query Analyzer then you start on the Query ...more >>

Hi, I have writen a database installation application that simply creates tables inside a database. I also need to create and schedule full-text indexing on some of my tables. I am using SQL server 2000 and and VB.NET 2003. Thank you, _dino_ ...more >>

Hi I need to upgrade an access app to sql server, for the first time. In the first phase I would like to upgrade only the backend to save time. Are there any pointers for a newbie to help in the upgraded? I need to give a time/cost estimate to client for the upgrade (backend & frontend)....more >>

Is it the June CTP or Beta 2? Beta 2 on MSDN has the latest post date, but I wasn't sure. Thanks!...more >>

Hello, I have a PC with an application using SQL on a SBS 2003 server and the SQL database is on a SBS 2000 server. I get from the SBS 2003 server to the SBS 2000 server through a router. The IP address are non-routable so it does not go out over the internet. When I execute the applicati...more >>

Hi, I am new to sql and have a problem that I need quick help. I need to copy data from a column in one table (from backup) to the same column in another table. Basically like this: TABLE BACKUP TABLE TO COPY TO colID title date colID title date I need to copy date colum...more >>

I currently have two databases which contain the same database structure but different data. How do I merge the two databases into one single database? *** Sent via Developersdex http://www.developersdex.com ***...more >>

Hi, I'm testing out the restore strategy for a 34GB database. The backup for the database was taken from a Windows 2000 SP4 SQL Server 2000 SP4 system via a maintenance plan. I copied the .bak file to another server Windows 2003 Ent SP1 SQL Server 2000 SP4 to perform the restore. I have ...more >>

I have run a db copy from one sql server to another. All the tables came across fine but I'm a little puzzled on the views. I can query them but they don't show up in Enterprise Manager as existing. Anyone know why or how to make them visible? -- Thanks Paul Bergson ...more >>

Hugo, I replied with sample data and details you asked , related with Subject ' SQL HELP' on the thread started on 7/22/2005 10:18 A.M Do I have to repost as a New Request to get noticed ?? Thanks Again for all the help Mike ...more >>

Question: All of my developers (2000) use DTS to load data. However, I just had the web admin come to me and want to set up a user that would be able to be BULK ADMIN and load using BULK INSERT statements. I'm a little afraid of that because BULK INSERT can read anywhere on the drive(s), ...more >>

Sorry to post this here, but of course I need to give expert advice in the next 5 minutes. Does anyone have any experience with either of these? My company is going to start using one of these in addition to MSSQL for long winded reasons and they want my input as to which one to go with. I ...more >>

Hello, I've just installed SQL Server 2005 Beta 2 and trying to get used to it. One thing I cannot understand: When I run the query in SQL Server Management Studio, the query result pane opens below, just like in the Query Analizer in SQL 2000. But in Query Analizer I could close it, here I ...more >>

Outlook client 2000 has been installed on SQL Server 2000 SP3a, I'm able to send and receive emails to and from this Outlook account. However, I get this error message when trying to execute xp_sendmail: xp_sendmail: failed with mail error 0x80004005 Please advise, thank you in advance for ...more >>

how can i use query analyzer to list the constraints for a given table? ...more >>

My apologies if this question shows up twice. I sent this yesterday but we're having Exchange problems. Not that Im looking for a new job or anything, but I've noticed alot of job postings these days want DBA's to have Data Warehousing experience. (at least in the Phoenix, Az. area.) Now I ha...more >>

Greetings All, We want to have a user_id which will be a primary key and all other tables will be joining on this user_id. My question is Option 1: Have user_id an identity and have foreign key on this identity table. Option 2: Dont use identity as user_id and generate user_id with some lo...more >>

I am running one instance of SQL on a Windows 2003 cluster with 6GB per node running in active/passive mode. I have set the /3GB and /PAE switch in the boot.ini as documented in this aticle: http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx It also instructs you...more >>

Hello, I am in pain. A lot of pain. Been working on this for quiet some time now. And now facing some crazy problem. This is related only to SQL 2000. I have a procedure setup to setup a trace to capture certain commands like 'alter database', 'alter table', 'truncate table' and 'drop t...more >>

how do you startup sqserver without recovering user databases?...more >>

Hi I have users in domain group who use application which uses sqlserve, they have rights to insert, update, delete. I want some of the members of this domain group to connect directly to the database using query analyzer but with right only to read and they still of course can use application...more >>

Hi - I have one SQL job that run on schedule. This jobs normally takes 1 minute the most( It is simply truncating tables on other SQL server and populate data to those tables). One time it ran for almost more than 24 hours and I have to manually cancel it. This SQL job is schedule to run every...more >>

Hello! I have a problem on my sql server, It's very slow, and some simple query have a long time execution. I look on EM->management->Current Activity->Locks object, and I look for a strange lock on temp.dbo.##lockinfo54 TAB/X/GRANT/Xact/##lockinfo54 on right click -> "dbcc inputbuffer(54)". ...more >>

Does anyone have a list for Windows 2003 memory configurations allowed for SQL under different SKUs/edition for SQL and the different editions of OS. ...more >>

Dear All, I have a DTS Package. When I run the package manually, it works, but when it is executed by scheduled job, it always fail. The error message is : "Executed as user: <DOMAIN>\<Username>. The step did not generate any output. Process Exit Code -1073741819. The step failed." P...more >>

I have updated a number of tables at home (size is around 200MB) and I am able to connect to office via Terminal Server. I would like to know what is the best tools I can use to transfer the tables to my office and update them. Should I transfer the whole database (around 1 GB) and use ...more >>

Hi, I am using SQLServer on my development laptop, and it's running without any problems since at least 6 or 7 months. Suddenly, since yesterday, when I start the Entreprise Manager, it takes absolute AGES (minutes, with a very intensive disk activity) until it shows the console root, and...more >>

I'm running SQL Server 2000 SP4 with the AWE hotfix (build 2040?) on Windows Server 2003 with replication. This morning, my log reader agents failed. In the server log, I saw the following messages: SQL Server Assertion: File: <logscan.cpp>, line=1985 Failed Assertion = 'startLSN >= m_c...more >>

I am going to remove the BUILDIN\Administrator's log account as recommneded for the security reason , is there anyone has thouhgts on how good and (or) how bad it can be if I remove it ? and what if I need this acccount later? can I put it back? Thanks a lot ...more >>

I am new to SQL Server 2000. I notice that when you backup/restore a database in SQL Server 2000 that the system keeps a record of the backup. Over time the tables in MSDB can grow. I want to be able to purge this old history out of the MSDB tables. I found a knowledge base article #152354, "D...more >>

Hello there I was wondering is there is a stored procedure to witch I could feed the name of a maintenace job and it will give me all the data that exists in the maintenance configuration screen ? thanks ...more >>

Hi, Please see the three table below, I'm designing the db schema so that it maintains each Client has exactly 1 default service. table ServiceType ( ServiceTypeId, ... ... ) table Client ( ClientId, .... .... ) table ClientAvailableService ( ClientI...more >>

stupid queston what is the key sequence that lets you insert nulls into the results pane without making an update query? Thanks! ...more >>

We would like to go for clustering. Does anybody have recomendations on Veritas clustering versus SQL server clustiring (i.e. SQL server clustering on top of Windows clustering) Thanks -- RK...more >>

Dear all, I want to do a UNION of 2 queries and Minusing the result set of 3rd query. I know it is workable in Oracle using MINUS clause. select * from table a where .. UNION select * from table b where .. MINUSING select * from table c where .. Kind regards Khurram Shahzad ...more >>