The version is updated version? or I need to install Service pack ? Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2) ...more >>

Is it mandatory to install SQL Server under domain user, I can't install under local system account? When I tried to install under local system it gave me access error but I installed under a user which has administrative privileged it installed perfectly, now the question is if I want to inst...more >>

I am installing SQL Server 2005 side by side installation, I already have SQL Server 2000, it gave me an error when it reached to SQL Server Database Services. Here is the error --------------------------- Visual Studio Just-In-Time Debugger --------------------------- An unhandled win3...more >>

Can anyone provide me Step by Setp SQL Server 2005 installation url Thanks ...more >>

In Symmetric Keys which ALGORITHM is more secure like TRIPLE_DES..... Thanks ...more >>

Hi, I have a .Net 2.0 windows app that connects to a SQL Express DB. I have 2 Clients using it fine. It accesses stored procs to update data. The clients use integrated security. data source='SQLSERVER\SQLEXPRESS';initial catalog=tbrPData;integrated security=SSPI The problem is on...more >>

What I'd like to do is download Enterprise Manager or something close, to access and maniplate a remote SQL Server 2000 database. I'm familiar with those tools. but for the life of me I can't figure out what to download. I don't need to install a database on my PC. It seems like I can't ju...more >>

Dear Experts. I have a SQL Server 2000 on my production machine and contains 31 databases, one of the database contain most critical information, now our organization wants that database should be encrypted, just because of that I am going to installed SQL Server 2005 side by side installat...more >>

I installed SQL Server Experess edition initially. After I uninstalled Express I tried to install the Developer edition. The install is failing for Notification Services, Integration Services and Client Components (or Workstation Components). Each fails with the message: "A component that y...more >>

Hi, If SQL Server 2005 Express is running on Windows XP Home, it is limited to five simultaneous connections. If it is running on Windows 2000 or Windows XP Professional, it is limited to 10 simultaneous connections. However, these are limitations of the operating system and not of SQL Server...more >>

I have a really strange problem. I have an ASP.NET 2 c# application which on load access 2 stored procedures. All work OK (normally) The application has an ajax timer which every now and then calls the server. Then at one point in time I get an error. On refresh I see that the stored p...more >>

I have a table like that: Create table myTable ( Name varchar, Description Text ) The description column contains more than 300 characters. The sql limit is to show only 30,35 words. Is there any tool available which can export around 5000 characters or more data of a single column. Rega...more >>

Is there any harm if we delete Northwind and pubs database from SQL Server 2000? ...more >>

Is there any harm if we delete Northwind and msdb database from SQL Server 2000? ...more >>

I am just wanting to proactively have the SQL clients at the same version as the database server. Is SQL 2005 SP2 (v9.00.3042.00) meant to be applied on a workstation that has the SQL Native Client installed?...more >>

I am revoking all the privileges from public role from master and tempdb database, will that be any thing wrong after that? just want expert idea because I ran one tool and it gave me suggession to remove public rights from system objects on master database. LIke following are some of the c...more >>

Hi, I am trying to view the permssions for a stored proc in SSMS 2005 I go to programmibility, stored procedures, then right click on sp but there is n o properties in the context menu. please help?? rotsey ...more >>

Is there a way to check that an entered server name and instance actually exists, or can be contacted before opening a connection? ...more >>

Hello I'm not the sql guru but I have a strange problem. I hope I can describe it correct. We use Win2k and WinXP pc's. The server is a Win2k Server (all updates) and a SQL2005 installation. On the SQL2005 is an XAL application running. Sometimes we get strange error messages. After this th...more >>

Hi, I have an unexpected error while executing the query below If I run it in Management Studio it will work fine, but if I run it using my code in C# on the same machine it will fail with the following exception: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 1...more >>

ALTER VIEW [dbo].[VW_OutBreak] AS open symmetric key CIS_Symmetric_Key decryption by certificate = CISCertificate; SELECT=20 cast(DecryptByKey(OB_PersonCompleting)AS varchar(100)) AS = PersonCompleting, cast(DecryptByKey(OB_PersonTitle) AS varchar(100)) AS PersonTitle, cast(Decry...more >>

is it possible to change the columns that display in the Object Explorer Details Window? I'd like to be able see some Extended Properties in this window. TIA Dean ...more >>

Guys, this may seem like a really silly question but please bear with = me.=20 Context: We are attempting to run several tests on various SQL Server databases. = We are in the process of developing a test plan to determine what we = test and how we go about testing it.=20 We've written som...more >>

Does this part of the query look correct? It's formated so that it doesn't use the time feature and zero's it out to midnight... where datecreated between DATEADD(m,-1,CAST(CONVERT(CHAR(10),GETDATE(),120)as DATETIME)) and GETDATE() order by datecreated how would i create a query that ret...more >>

Hi Im converting our Act 6 database to Act9 and I keep getting this error right near the end of conversion. Converting Notes and Histories... The INSERT statement conflicted with the FOREIGN KEY constraint "NOTE_CREATEUSERID_FK". The conflict occurred in database "MTA2008", table "dbo.TBL_AC...more >>

Hi, I have a DB-based application, which has a UDF like this: CREATE FUNCTION fn_concat(@A varchar(255), @B varchar(255)) RETURNS varchar(255) AS BEGIN RETURN coalesce(@A,@B) END Using SQL-Server 2000 I execute the following statement: SELECT DISTINCT A.a, dbo.sp_concat(A.b, A.c) ...more >>