Dear Professional. I installed SQL Server 2000. I can registered SQL Server in Enterprise Manager as a but when I tried through IP it gave me an...

Rogers

09-03-2007 09:44 PM
Rogers

Hi All, I am running SQL Server 2005 SP2 (Without SP1) on Windows 2003 Machine. I am facing a very strange problem. Sometimes the database stops...

=?Utf-8?B?QWx0YWYgQWwtQW1pbiBOYWp3YW5p?=

09-03-2007 05:08 AM
=?utf-8?Q?Ekrem_=C3=96nsoy?=

Hi Ekrem, Thanks for your prompt reply, I am also looking for any guidelines for SQL Server 2005 certification. I would really appreciate if you can...

Rogers

09-02-2007 10:31 AM
kb

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...

=?Utf-8?B?R2FyeQ==?=

08-31-2007 04:24 PM
=?Utf-8?B?R2FyeQ==?=

I installed SQL Server Experess edition initially. After I uninstalled Express I tried to install the Developer edition. The install is failing...

=?Utf-8?B?U2NvdHQgTQ==?=

08-31-2007 04:04 PM
=?utf-8?Q?Ekrem_=C3=96nsoy?=

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...

Rogers

08-31-2007 11:24 AM
Rogers

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

Rogers

08-31-2007 08:52 AM
Jonathan Psaila-Depasquale

well it must be a windows group because the other clients work fine So how do I find out what windows group there are?? In the activity monitor it...

Rotsey

08-31-2007 02:10 AM
Rotsey

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...

Rogers

08-30-2007 03:56 PM
Rogers

Thanks.. "Ekrem Önsoy" <ekrem (AT) btegitim (DOT) com> wrote

Rogers

08-30-2007 03:12 PM
Rogers

Alright, I will go with AES128 as data is sensitive and we need strong encryption. Thanks "Ekrem Önsoy" <ekrem (AT) btegitim (DOT) com> wrote

Rogers

08-30-2007 01:21 PM
Rogers

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...

=?Utf-8?B?cnZhbmdlbGRyb3A=?=

08-30-2007 04:32 AM
=?Utf-8?B?cnZhbmdlbGRyb3A=?=

Yes I see where they are I click on the one I want but there is no "Properties" in the right click menu PLEASE HELP!!! "Ekrem Önsoy" <ekrem (AT)...

Rotsey

08-30-2007 01:02 AM
Rotsey

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...

=?Utf-8?B?TWFydGluIFNjaHdlaXplcg==?=

08-29-2007 06:03 PM
=?utf-8?Q?Ekrem_=C3=96nsoy?=

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...

=?Utf-8?B?a2lzaG9y?=

08-27-2007 04:57 PM
Paul Shapiro

I have a table like that: Create table myTable ( Name varchar, Description Text ) The description column contains more than 300 characters. The sql...

Muhammad Kashif Azeem

08-26-2007 11:32 PM
Peter YangMSFT]

I know this is a SQL forum, but I don't think there's another group for this question. Can I connect from a portable CE5, RF, to an access database...

tc

08-24-2007 11:07 AM
tc

I have sql server 2005 standard edition version 9.00.3054.00 (service pack 2 installed). Recently, I have run sql server hotfixes deliveres over...

=?Utf-8?B?QW1pciBTdGV0YQ==?=

08-22-2007 05:00 AM
=?Utf-8?B?TXVyYWxpa3Jpc2huYSBSZWRkeQ==?=

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...

=?Utf-8?B?Sm9obiBPYmVybGlu?=

08-20-2007 12:03 PM
Chris Wood

I think this link http://msdn2.microsoft.com/en-us/library/8xx3tyca.aspx has a solution for this problem, at least with me it is working. What I...

antleite2001@gmail.com

08-18-2007 06:03 AM
antleite2001@gmail.com

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

Rogers

08-17-2007 02:34 PM
Anith Sen

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

Rogers

08-17-2007 11:21 AM
Pawel Potasinski

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...

Rogers

08-16-2007 04:47 PM
Rogers

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

tc

08-15-2007 07:39 AM
tc

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...

Dean

08-13-2007 09:07 PM
Sue Hoegemeier

ALTER VIEW . AS open symmetric key CIS_Symmetric_Key decryption by certificate CISCertificate; SELECT cast(DecryptByKey(OB_PersonCompleting)AS...

Rogers

08-11-2007 04:11 AM
Tibor Karaszi

Hi, Can anyone please guide me in using using bcp from remote machine. Does bcp.exe needs to be installed/copied to the remote machine or any option...

richard.stephan@gmail.com

08-10-2007 06:13 AM
richard.stephan@gmail.com

Guys, this may seem like a really silly question but please bear with me. Context: We are attempting to run several tests on various SQL Server...

Cordell Lawrence

08-09-2007 03:34 AM
Tibor Karaszi

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...

Gabe Matteson

08-08-2007 02:35 PM
Gabe Matteson

I am running an enterprise application on a terminal server. The first time the app opens a windows, then at odd and sometimes frequent intervals...

=?Utf-8?B?UFJNb2xpbmE=?=

08-07-2007 12:26 PM
=?Utf-8?B?UFJNb2xpbmE=?=

Hi All , I have 3 sql servers located at different time zones. Say, CST,PST,EST. Now how can I get current time at EST,PST from the SQL server...

Ram

08-07-2007 11:40 AM
=?Utf-8?B?TmFtd2Fy?=

HI, I was trying to install SQL workgroup edition once the files are extracted it gives me an error "SQL server Setup unexpectedly failed" with log...

=?Utf-8?B?QXphbQ==?=

08-06-2007 01:38 AM
=?Utf-8?B?QXphbQ==?=

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...

Henning Eiben

08-03-2007 02:43 AM
Henning Eiben

Hi, When I try to open any table in Management studio in design mode I get the error message "The parameter is incorrect" Please Help Tarek Al-Jamal

Tarek Al-Jamal

07-31-2007 10:55 AM
JPD

I've installed the SQL Server 2005 client utilities on a laptop that's used for development. When I try to create an odbc connect to SQL Native...

=?Utf-8?B?Z3JhY2ll?=

07-31-2007 10:51 AM
rr1234@iwon.com

I am running SQL Server 2005 and trying to make a copy of a database from Management Studio. Using the Backup wizard I go through all the steps...

=?Utf-8?B?V29vZHk=?=

07-29-2007 07:55 PM
Sue Hoegemeier

Hi all. I have a PPC app which connects to an SQL server via RF. App is fine, but when out of range the connection timeout is too long. I don't...

tc

07-27-2007 01:46 PM
tc

I'm receiving ths following error message when I try to connect to my server: Cannot generate SSPI context. (.Net SqlClient Data Provider) An idea?

=?Utf-8?B?Sm9zZXBo?=

07-27-2007 11:17 AM
Ayad Shammout

I would really appreciate if anybody can correct me in the following query. In the following query, I am passing the database name and...

Roger

07-26-2007 04:32 PM
Ayad Shammout

1). I was trying to do bulk insert t temp tables, so because temdb has a Latin1_General_CI_AS collation, an my database has...

=?Utf-8?B?VW5jbGVTYW04OQ==?=

07-26-2007 10:38 AM
=?Utf-8?B?VW5jbGVTYW04OQ==?=

I guess this is the right forum. When I got at it from inside of Sql Server Communities, t-sql was an option. I am using SQL Server Management...

=?Utf-8?B?TWljcm9Db21wdXRlciBTb2x1dGlvbnM=?=

07-25-2007 09:57 AM
Andrew J. Kelly

Hi, Does any one have any experience with the Hibernate layer ? The factor which is bothering me is the absence of stored procedures. All...

Manoj Kumar

07-25-2007 05:50 AM
Pierpaolo Simoncini

I'm working heavily with query notifications in SQL Server 2005 and I'm now getting the following...

=?Utf-8?B?U2VlbiAiVGhlIEJlYW4i?=

07-23-2007 07:50 PM
=?Utf-8?B?U2VlbiAiVGhlIEJlYW4i?=

Hi, Can anyone suggest what is going wrong here? I have created a stored procedure in SQL2005 Express, which builds a temp table, messes with data...

Jason Speight

07-20-2007 04:08 AM
gregbanner@myway.com

I need an appropriate select statement for my case, the case is a table with two columns (row id ,col1) I want to retrieve a three columns RowId,...

Batool

07-19-2007 10:35 AM
JPD

Does anyone have an idea what could be wrong with the configuration of the Database?

Rob Jones

07-19-2007 07:01 AM
Rob Jones

Hi! I have tried to setup my SQL Server Browser to Network mode but I keep getting an error saying "WMI Provider Error", "Can't add or remove a...

Teo

07-18-2007 02:38 PM
Teo

Everything was working fine until suddenly this problem appeared from nowhere: Boot up the pc and go into SQL Server Management Studio. The...

DesCF

07-17-2007 09:54 AM
DesCF

Hi, I need to install SQL Server client components (as Symantec calls it) so as to access my SQL Server 2005. Where do I find the SQL Server...

Bob

07-17-2007 08:03 AM
Tibor Karaszi

Hi, I use an Access Project as a front end for my database, which is in SQL Server 2000. Everything is working fine in Access 2003. However, I...

=?Utf-8?B?SS4gS2luYWw=?=

07-16-2007 10:20 AM
Adams Qu [MSFT]