There is no editorial oversight other than marketing? The sql server 2005 help system has the haphazard feel of being written over the weekend (by someone in marketing). Not found in sql server help: formula, formulas, how to write a formula for computed columns rowguid, rowguid columns...more >>

is it possible to restore a sql 2005 database backup to a sql server 7.0? ...more >>

Hello, I have a sql 7.0 server that I want to profile activity on. Is it better to run profiler on the server or remotely? the same question with running performance monitor 24 hrs. Any thoughts? Thanks ...more >>

Hi How do I hide the stored procedure code from be being viewed by others in the sql server enterprise manager? Thanks Lasse ...more >>

(on Yukon) - is there an easy way to remove html tags from nvarchar(max) field? ...more >>

Hello all, I downloaded and installed the SQL Server 2005 evaluation version (full version not the express one) and I do not know how to allow the connection from a remote computer; locally everything seems to work fine, but when I try to create a DSN on my laptop to get access to the S...more >>

Can someone tell me how to defrag. an MSSQL 7 AND MSSQL 2000 server. We have both ver. 7 and 2000 (running on two different systems). I am not a DBA but I really need to get this done tonight (2/24/2006) while we take our systems down. I will also want to defrag the Windows 2000 and Windows...more >>

hello, we have a dual xeon box with 4 Gb of RAM running windows 2003 sp1 and sql 2000 sp4. The database is 200 Mb and will probably max out at 400 Mb. Is there any way to keep the entire database in memory? Any issues with doing this? thanks ...more >>

Hi pals, am also having a similar problem to that of Simon. The log files of my server are being stored in D drive of our SQL server which is 120 GB. We have a database maintenance plan & all mdf & ldf files are backed up on a daily basis. the problem is that the log file keeps growing & wi...more >>

I have recently attempted to use replication in our SQL2000 server. Since the process installed check columns in the tables, the process was unacceptable for the application we use. Consequently, I turned off replication and removed the columns using some scripts found on a site regarding ...more >>

Hi, Just a quick question, if I want to implement Transactional Replication on a database, does that database have to be in Full back up mode? If I have the database in Simple backup mode will it replicate all transactions? Thanks in Advance, SQL Newbie...more >>

We have a stored procedure that copies records from one day to another day. There is a key rule to prevent duplicate records. The operator might select one record, then another, then decide he really wanted all of them to be copied. Is there a way to write my stored procedure so that the dup...more >>

Hello. We SBS2000(SP4) with SQL2000 installed. When i attempt to run the SQL Enterprise Manager, i get the following error: Snap-in failed to initialize Name: Microsoft SQL Enterprise Manager CLSID:{00100100-1816-11d0-8ef5-00aa0062c58f} Does anybody know how to resolve this ? Any he...more >>

Hello Group, yes new to sql. I was given the task of moving some old data to a brand new application the company just bought. I see that the new application database has several fields that have the attribute of not being able to have a null. Some of the fields are number and some are al...more >>

Hello, I'm trying to find some reference for SQL server 2005 user management. I basically need to have multiple users on the database (I don't want to have a table 'users' in the database, rather users created at the database level). While reading the help in VS 2005 about SqlConnection I s...more >>

I am getting the following error when trying to select fields from 2 tables and one query in a union query. ODBC--Call Failed [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '='. (#102). I have tried running the query with each statement separate and each works but when...more >>

I am getting the following error when trying to connect to SQL Server 2005 Express through Microsoft SQL Server Management Studio Express CTP. "Cannot connect to SERVER\SQLEXPRESS Additional Information: Instance Failure. (System.Data)" Any help would be greatly appreciated. ...more >>

Hi all, I'm somewhat new to managing an SQL Server installation. I've noticed that the log files for my database are getting quite large. The amount of actual data is quite small because a lot has been deleted recently, but the log files are now about 10 times the size of the actual data ju...more >>

Hi, Is there any way to get the DB Growth and Shrinkage rate in SQL Server through a query? Also, for the DB Log??? Please let me know ASAP. Thanks in advance.... Regards, Pramod ...more >>

I want to do something like this Select @MyText = LongDescription From MyTable Where id = inserted.[ID] I get an error message telling me that nText is invalid for a local variable how can I do this? ...more >>

I apologize for the cross post - not sure if these are the right groups. MS SQL 7.0 SP3 I have a view that sums the orders for our customers. It sums the Revenue and Qty for each month of the year for each customer, along with the ShipTo city. I then use the data in Crystal Report. The issue...more >>

How can I run a select statement on data from a previous select statement within the same query? In VFP I could select the data into a cursor and then run the second select statement on the cursor. What is the best way to get this to run properly? Thanks. ...more >>

SQL Server Enterprise Manager Recurring Job Schedule cannot run hourly I have tried a lot of things but cannot get this schedule to run every hour on the hour or every 10min SBS2003 Enterprise edition SP3 TIA Sam ...more >>

I've set up an optional parameter on a function, but when I call the function without a value, it doesn't work. Is this a common problem? -- #####-----#####-----##### POV Tips and Hints at ... http://povman.blogspot.com/ ...more >>

I've just installed SQL server express on my WinXP pro workstation. I'm running everything locally. When I try to connect to the SQL server from an Access project I get this error : [DBNETLIB][ConnectionOpen (Connect())).] SQL Server is unavailable or does not exist or access denied. Whe...more >>

Hi everyone, I'm a british developer and so my SQL Server is on a british computer. The problem I'm having is that dates are being stored in the British format and I desperately need them to be stored in the American format. The applications I'm making are all for the American market and ...more >>

Hi, I'm having some trouble with a join on two tables. Table 1 (all items) codigo | descricao Table 2 (subset of table 1 and some columns added) codigo | tipo | tb_nome Since table 2 has a subset of table 1 on 'codigo', I made my query as follows: Select tabelas.codigo, tab...more >>

I've just purchased and installed SQL Server 2005 Developer Edition as I was lead to believe that it would allow me to import and export data from Access, etc. whereas the Express edition would not. Unfortunately, I can see no way to do this, I've looked through the menu items in SQL Server...more >>

How convert a decimal column so 5.3700000000000001 will display as 5.37 at the same time .3900000001 displays as 0.39? I need to just drop the extra decimals after 2 decimal points and if possible use a preceding 0 if the number is less than 1? Thanks for your help. ...more >>

I have a VERY simple stored procedure that I've used the Stored Procedure wizard in sql2000 to create. This is it: **************************** CREATE PROCEDURE [delete_PC] (@PC_1 [varchar]) AS DELETE [mtsys].[dbo].[PC] WHERE ( [PC] = @PC_1) GO ***************************** ...more >>

In access I am able to use a query with .SELECT......HAVING whatever.whatever="" when a field is empty but not null. How do I use the same condition in enterprise manager? When I try to set "" as condition I get no data, in access I get data. ...more >>

Hi there The following query runs a heck of a long time, with CPU utilization rising to 100% for an extended period. I must be doing something wrong (or could be doing something better). Please help! Best regards Loane use database select a.refno, min(a.date), (select top ...more >>

Dear experts, I'm an Oracle guy, looking to pick up SQL Server. I've installed SQL Server 2000 on XP (home). I'm now trying to navigate SQL Server. In Oracle, I would just open SQLPLUS, and query away. SqlPlus looks like a DOS window, or telnet window into Unix. It just has the dot pro...more >>

Is there any problem installng the developer's edition (or what ever it is called now) of MS SQL Sever 2005 on the same client computer that's runnning SQL 2000? TIA....more >>

I tried to setup a NET SEND on SQL errors to my work PC Name (SYSADMIN), inside of Enterprise Manager (I'm running SQL 2000 SP-3a) and when I click TEST, it fails. If i put the name of a server that is on my network, in there, it works fine. What is wrong? I have a Windows 2003 Server Active ...more >>

Hi, After what could have been a very nasty experience with my Access database, I'm looking at possible ways of making things a little more reliable... My current configuration is a dotNET application that is installed on each client along with an Access database that contains queries and ...more >>

Can someone tell me where I can find more information on indexes and how they are utilized. I understand that indexes are B-trees (I think B+ trees), but how are they utilized. I hope someone can help me understand this better. Here is what I think I know: 1. Nonclustered indexes are st...more >>

Hi there, I restored a SQL 2000 database into a SQL 2005 server, i need to change ownership of the tables in the database for my application to work correctly. Under 2000 I could select the database, then tables and in the preview pane displayed the owner. Part 1: How do I find out wh...more >>

I'm having trouble trying to put together an update query. I have a single table that looks like this (relevant data only): PK INT PRIMARY KEY IDENTITY, nameresolved VARCHAR(30), dtresolved SMALLDATETIME, nameapproved VARCHAR(30), dtapproved SMALLDATETIME I'd like to set the nameapprove...more >>

Hello Group, new user to SQL Server. My network guy is after me to "defrag" the SQL Server databases. He says that some of my databases are bad. What does defrag have to do with databases? Rich...more >>

Hi, This que. was asked me in an interview. The situation is : I have to update a Salary of employees. comm = comm + sal * 10% for comm < 1000 and comm = comm - sal * 10% for comm > 1000 for all employees whose salary > 10,000 in emp table. How can I do this using single update statm...more >>

I was reading: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da2_8sit.asp The first bullet point half way down says "The index is implemented as a B-tree index structure...The pages .. are are inked in a doubly linked list"... I thought that would make it...more >>

Hello! I'm programming in VC++ 2005 MFC and I have never use SQL server as the database before. Earlier I have used ADO and Access database. I have a database which consist of 4 tables, see below I know all values at the same time. I wonder how do I update the database in the best way? ...more >>

Hello Group, I am new to SQL Server. What causes a date field to have the date 1/1/1900 in it? I have been given a database to extract some data from and I can see several of the records have 1/1/1900 in them. Other records have <NULL> in them; the obviously have not been touched. Wh...more >>

Just installed a dev SQL 2005 server, imported some old SQL 2000 databases. I am now trying to query a table and would like to know what the equivalent to 'Return all rows' is? Many thanks ...more >>

hi I'm using a INSERT ... SELECT statement to insert UserID values into a table. I need some function to make sure that no double entries are created with the UserID but a trigger I guess would create an error and halt the procedure - is there some way to have a trigger simply skip/delete row...more >>

Totally new to writing UDF's and not sure how to go about it. Just need pointing in the right direction. Senario: User enters into a field on webpage either a Premise No or a Person Id. Then clicks on a search. System does a check to see whether the number entered has any alpha charac...more >>

Hi, I'm sort of new to SQL and SQL Server. In Query Analyzer; Is there a way to call a stored procedure from a select statement so that I can filter and sort the output with where and ordered by clauses to see what the stored procedure is returning for troubleshooting purposes? The store...more >>

Hello, Could you tell me how to change the authentification mode for SQL Serv 2005 Std ? I found (no tried yet) via the registry but no other way (via GUI) ? Thanks, ...more >>

Hi, I have a .sql txt file, provided as a back up of a MySQL database from our ISP. When I open this in Notepad, the first line begins: DROP TABLE IF EXISTS store_category;CREATE TABLE store_category... Which, to me, appears to be SQL code for creating new tables, and populating them. ...more >>