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 03: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 12: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 05: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 03: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 10: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 10: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 04: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 11:03 AM
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 05:03 AM
antleite2001@gmail.com

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

Rogers

08-17-2007 01:34 PM
Anith Sen

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

Rogers

08-17-2007 10: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 03: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 06: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 08: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 03: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 05: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 02: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 01: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 11:26 AM
=?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 10: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 12: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 01: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 09: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 09: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 06: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 12: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 10: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 03: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 09: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 08: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 04: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 06: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 03: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 09:35 AM
JPD

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

Rob Jones

07-19-2007 06: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 01: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 08: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 07: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 09:20 AM
Adams Qu [MSFT]

I try to invoke Connection Properties dialog box that Visual Studio 2005 use. The dialog that I said is used in many places such as when developers...

=?Utf-8?B?VGVlcmF2ZWU=?=

07-16-2007 12:10 AM
=?Utf-8?B?VGVlcmF2ZWU=?=

When creating an ODBC connection to a SQL server, a handful of PC's do not show a list of drivers to create a connection. To create the connection,...

=?Utf-8?B?Q3V6emk=?=

07-13-2007 02:36 PM
=?Utf-8?B?TW9oaXQgSy4gR3VwdGE=?=

Ok..this is a weird one. When I open up SQL Server Management Studio Express my menubar has multiple instances of the File, Edit, View...menu...

=?Utf-8?B?Sm9obiBTY290dA==?=

07-12-2007 05:30 PM
=?Utf-8?B?TW9oaXQgSy4gR3VwdGE=?=

Hi, A client is having some issues with software (Progress) conflicting with Visual Studio 2005 (related to debugging). As I understand it, Visual...

koenraad@willems.com

07-12-2007 04:31 AM
JPD

Hi, We have 4 workstations that connect to remote SQL servers (2000 & 2005) using SQL Server Management Studio 2005. Whenever we first launch...

EightBall

07-11-2007 08:45 PM
EightBall

Hi, I'm looking for a way to enumerate SQL Server instances on a given server. I've seen the GetDataSources() method of the SqlDataSourceEnumerator...

Arild Bakken

07-11-2007 07:01 AM
Arild Bakken

Is there a function that I can use to multiply all of the values of a column from a result set together? Much like SUM() adds all the values...

Christoph Boget

07-09-2007 01:46 PM
Hugo Kornelis

Hello, Does anyone know how to configure a SQL 2005 Alias where SQL 2000 Clients can access it by name? I migrated a db over to a new server and...

Stewart

07-08-2007 05:25 PM
Roman Rehak

Sure...read up on the subject in books online under the help topic for DBCC SHOWCONTIG. You want to be doing some type of index maintenance on a...

Sue Hoegemeier

07-06-2007 09:46 PM
Sue Hoegemeier

Hi, I have a Access 2003 talking to SQL 2005 express DB via linked tables. I also have .NET forms application that also talks to the SQL DB. I...

Rotsey

07-05-2007 10:24 PM
Sue Hoegemeier

We have an application that requires a different version of .net framework (not 2.0). Can the SQL Server 2005 client tools be installed with a...

=?Utf-8?B?RXN0ZWJhbiBBcnR1cm8=?=

07-05-2007 07:42 PM
Roman Rehak