Hi I want to get SQL Server version. I know this way: Select @@version But this gives me a very long string, i.e. Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 18 2006 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Personal Edition on Windows NT 5.0 (Build 2195: ...more >>

This is a "was working yesterday" issue. On our PCs trying to connect to MSDE 2000 SP4 (via .NET SqlServer Connection object) resulted in a "timeout expired" message (using default 15 seconds timeout) This is only happening when connecting to MSDE. Full blow/developer editions are fine. ...more >>

SQLServer2005: How can a seperate script file for each single db element (instead of generating one file for all elements) ? ...more >>

This: SELECT FirstName, LastName, BirthDate FROM tblPeople WHERE LastName IN ( 'Cosner', 'Dobson', 'Housley', 'Spinks', 'Braucher', 'Fosgate', 'Marcum', 'Littler', 'Underwood' ) or this: SELECT FirstName, LastName, BirthDate FROM tblPeople WHERE LastName = 'Cosner' ...more >>

Hi I don't want to start another flame-war here, but I like to know where we are with this question today. In SQL Server 2005, are there still any major performance benefits of using stored procedures nowdays, compared to dynamic queries (with parmeters)? (Under .NET) (I don't talk abou...more >>

Hi, I'm using SQL Server Management Studio Express and I have made a website that uses a database with stored procedures. When running pages in my webpages it cost around 2 seconds to load each page. Thanks too long!! But where is the problem??? I like to see a list of all executed sto...more >>

Hi, Can anyone confirm that SQL 2005 does not support NaN (not-a-number) and INF (inifinite) values anymore? Seems that SQL2000 can handle those but not 2005? ...more >>

My computer runs the MS SQL Server in the XP Professional environment. I assume that this is because my machine has the small business contacts manager installed, which came with Outlook 2003. However, I do NOT ever run the small business contacts manager and my OUTLOOK 2003 is not configured ...more >>

We have developed an application which uses Tomcat + ApacheSSL installed on Server 1 (Windows 2000) and connects to a SQL SERVER 2000 database installed on Server 2 (Windows 2000). They connect thru a SQL SERVER 200 JDBC Microsoft Driver with SP3 (the latest one available). We had connected th...more >>

Is there a terse way to include as an aggregated field the percentage Count() represents when using Group By... For example I have (abbreviated): Select QCLIENTNO, Matters.AreaofLaw, Count(Matters.AreaofLaw) >From Matters -- --Inner Joins -- Group By ContactsQCLIENT1.QCLIENTNO, Matters.A...more >>

Hi All, We recently upgraded from SQL 2000 server to SQL 2005 Server. For the few days after upgrading, everything went to crap. After running a full index repopulation and modifying various indexes, we managed to get everything performing even better than it was in SQL 2000. Our applicatio...more >>

Is there a means other than manually, exporting Current Activity\Process Info to a delimited file? Thanks ...more >>

I inherited an application (or two) that run on SQL Server 6.5, which I haven't used in years, and am having a problem. I get the error: ------------------------------------------------------------------------ Can't allocate space for object 'Syslogs' in database 'master' because the 'logsegm...more >>

What is the offical word from msft conserning installing SQL2000, hotfixs and service packs via Remote Desktop Connection. Is it ok to do this? Also, does the same hold true for installing a virtual server on a cluster? I have read a lot of confilicting articles and was wondering if there is ...more >>

It would seem that someone removed the ability for you to generate scripts including permissions when we set sail down the path of sql server 2005/express. Need to be able to generate the scripts of objects with the appropriate permissions included. Have not found anywhere in the options et...more >>

Hi I am brand new to SQL server 2005. My agency is looking to migrate some big DB2 datasets to SQL server 2005 and I would like to get some foundational understanding of how to use that interface and how to develop applications to use SQL server. Any suggestions about good starting poin...more >>

Hi, We have several Access database that we would over time plan to convert to SQL. I am looking for a tool that works better than the upsize wizard in helping with the transition - I am looking for something reliable yet reasonably priced. Thanks in advance for all your help KR ...more >>

Hi, I am having stored proc which returns 2 resultset, now i want to call this stored proc within another stored proc(nested stored proc) but i want to use only the second resultset from this stored proc. Please tell me how can i go about it.. Thanks in Advance, Regards, manoj singh. ...more >>

Hi, I'm using SQL Server 2005, and I would like to understand how to create and to drop a database without errors: Infact, if I try to create a database that already exists, SQL Server throws the error "Impossible to create the database because it already exists", and if I try to drop a databas...more >>

Hi, Our requirements are that four decimal places are more than accurate enough for our needs when tracking prices of items. I was about to settle on the money type, when I noticed something odd.. declare @m1 money declare @m2 money set @m1 = 324.34556 set @m2 = 100 select @m2 * @m1 ...more >>

O.K., I am no expert so I have a couple of pretty important questions. Can someone please correct me where I am wrong. I have set up 'maintenance plans' to do full backup every single night of the databases on all our servers. 'Full Backups' don't truncate the old sections of the backup log. ...more >>

Hi there! I have a Sql Server 7 running on a webserver. Now I have a quite complicated query that I run on 4 ways. 1: Using ODBC-driver directly on the Sql Server. time to execute: 12 seconds (done this about 10 times) 2. Using OLEDB-driver directly on the Sql Server. time to execute: 12 ...more >>

Hello, One of the softwares we use store an id number as binary in its database (MSSQL) I can see the content of the binary file from crystal reports it's something like this: 39623766346664382D303232322D346630302D616439362D66383535363239363938656600 What is this and is there a way to convert ...more >>

So I calculate the distance between ALL the possible orders and ALL the possible warehouses... And my cartesianing is way out of scope; and I can't get results in the right performance window. And of course- I can't do this one order at a time. I mean.. Gosh; this is really going to sound me...more >>

Given the following tables: target {target_id, target_name, target_description} category {category_id, category_name, category_description} target_category {target_id, category_id} Imagine the following data: target ------ target_id target_name target_description 1 ...more >>

Hi, To look up information about indexes for a given table in SQL Server 2005, I can use: sp_helpindex TableName or select * from sys.indexes where object_id = object_id('TableName') But this just gives me information about the column or columns on which the index has been defined. H...more >>

Hi, I'm looking for a systemtable that contains a column for which exist two rows containing the Values True and False to join this against my own tables. Does such a table exist? Thank you in advance. Regards marco ...more >>

The documentation for this table describes the resolution for several timers as microseconds. I looked it up and a microsecond is 1 millionth of a second. That is 1000 time better resolution than the timers in the other documentation I have read. I didn't think there was a timer that fine on m...more >>

hi all, I was wondering how I can enforce some configurations to sql server 2000, like auditing failure logins for example, but without using the enterprise manager. I need to implement a tool that will set some configurations automatically without human intervention, any idea how can i do ...more >>

For example: I have a table 'products' with columns id, name and price In this table there can be duplicate product names: 1 - product1 - 10 2 - product1 - 15 3 - product2 - 12 4 - product1 - 9 I need a select query which returns unique products (by name) and if it finds duplicates,...more >>

Hi I wasnt sure exactly which group this topic would pertain to I am currently using crystal and stored procs to generate reports. The problem is that my users want the ability to modify their own reports, (modify grouping, layout etc) I am using IIS and sql server 2000. Does anyone know if th...more >>

On MSSQL Server 2000 I'm trying to create a view that returns the value from two different columns in a table as a single column... SELECT (TRIM(fname & " " & lname)) AS name FROM users; How is it done? ...more >>

I have a query that joins happens to joing one table twice. SELECT orders.id AS OrderID, orders.start AS Start, orders.description AS OrderDescription, orders.status AS Status, teams.description AS Team, LTRIM(users.name_first + ' ' + users.name_last) AS Creator, tasks.id ...more >>

OK, first of all, don't ask me why we're doing it this way. There is a good reason. Just trust me on this. Having said all that, here is my problem: I need to find the last value stored in a table and return that value. Here is an example: DECLARE @groupPrefix int SELECT MAX(ClientID)...more >>

The SQL Server 2005 Management Studio Express is the IDE for users to create/access/edit different DB objects like tables, stored procedures, triggers etc.; then what is the SQL Server 2005 Express (Configuration Manager) for? Secondly, SQL Server provides 2 modes of login - Windows Authentica...more >>

Hello, I'm working on a sql server 2000 db and I noticed that the results of GETUTCDATE() function is wrong. There is any way to fix it? What causes this? Alex ...more >>

Hi all, For the development of an idea, I am trying to find out how many servers will be required to process half a terabyte of data, in one second? To clarify the problem, we have 13 weeks' daily POS data that runs into half a terabyte. I think the only way to have the result of a select que...more >>

I have a 750mb database I need to post to a separate webserver on a daily basis. The timliness of the data is not an issue. The client is accepting a 24 hour delay in the availability of the data (it doesn't change all that much on a daily basis). The idea here is to make the transfer and updatin...more >>

Is this even possible? When trying to insert data using the query below into a partitioned view that is on a linked server, I get the following error: 'SQLOLEDB' IOpenRowset::OpenRowset returned 0x80040e21: [PROPID=DBPROP_COMMANDTIMEOUT VALUE=600 STATUS=DBPROPSTATUS_OK], [PROPID=Unknown Pro...more >>

Hi to All, I'm Alessandro, I've a question for You: I execute a query in SQL Server 2005 with Management Studio. Client stores all temporary query results on folder "C:\Documents and settings\User\Local Settings\Temp\n\" in a .tmp file. Can I save my temp result in another disk/folder? or it...more >>

Hi I have a requirement to provide quick backup and recovery of SQL Server databases, in the event of a Disaster Recovery situation. We have a 'Live' server which will host the DB applications, and a redundant server (serving as a DR warm-stand-by), in the event that the Live server should...more >>