Hi, Can you connect to SQL 2005 if you're not part of the domain the server is installed in? I installed the client and it can see my SQL 2000...

Simon Renshaw

03-12-2007 12:13 PM
Simon Renshaw

I have a question concerning a SQL Server 2005 Native Client Installation. I have a Windows 2003 Server running SQL Server 2005, and I'm trying to...

SafetyLabel

03-12-2007 10:23 AM
SafetyLabel

I have an application using an Access 2003 project connecting through ADO which must refer to a table in a SQLServer 2000 database other than the...

TLD

03-12-2007 10:21 AM
TLD

If I have sql 2005 express installed with a data in it, how can i upgrade that to SQL standard 2005 without bringing the database down? Thanks

Chanaka

03-09-2007 10:16 AM
Chanaka

Hi On a new PC I've installed Win XP Pro with SP2 and SQL Express 2005. According to the registry (and Microsoft) this should include the...

Peter Hemmingsen

03-08-2007 04:47 AM
Peter Hemmingsen

I'm trying to automate opening the firewall for an instance of SQL. For a given instance of SQL how do I find the path to the executable ?

Michael Tissington

03-03-2007 11:16 PM
Linchi Shea

I have a large application that currently uses SQLOLEDB as the provider. The application needs to connect to SQL 7 thru SQL 2005. I have tested...

Michael Tissington

03-02-2007 09:52 PM
William \(Bill\) Vaughn

Today I had to upgrade my version of ACT Premium for Workgroups to the 2007 version, which includes SQL Server 2005. After 6 hours on the phone with...

ACTing Out

02-28-2007 09:05 PM
ACTing Out

I have a Text(datatype) column in one of my table and it contains word document in binary format and I wanna search text in that column, Can I...

Rogers

02-27-2007 03:58 PM
Russell Fields

During form Load, I want to fill in the dataset and the close the connection at once. However, In SQL Server, I still find that the connection exists...

Agnes

02-25-2007 04:31 PM
Sue Hoegemeier

I have two servers ServerA and ServerB, both are on the workgroup, I don't wanna install domain controller, I have installed SQL Server 2000 on...

Rogers

02-23-2007 12:07 AM
Sue Hoegemeier

I am running into a problem where we have an SQL Server in a workgroup that I'll call WG1, and a client running Windows XP SP2 in a workgroup that...

Queue

02-23-2007 12:00 AM
Sue Hoegemeier

i couldn't log on to sql server from the client. i then looked at the database and there was a single user description next to the database...

ae

02-22-2007 10:07 AM
Eralper

Dear All, I have here one of my clients, he have a SOLOMON SOFTWARE, on NOVEL Operating system & he wants to take out the All the Data, which is on...

UPGRADE FROM NOVEL TO SQL SERVER

02-22-2007 03:55 AM
UPGRADE FROM NOVEL TO SQL SERVER

Dear Professional, One quick question, is there any way we can shrink tempdb database and don't need to restart SQL Server services? Thanks in...

Rogers

02-20-2007 09:56 AM
Mark Broadbent

Ron, I am having an identical issue. I can modify plans when running Management Studio on the server, but not from my client computer. I have 2005...

jkiefer580

02-19-2007 11:17 AM
Ron

I am running an application on MS SQL2000 SP4. I have 5 clients connecting to the SQL server. Almost every night between 5:oopm and 6:30pm, I lose...

Fini2549

02-17-2007 09:20 AM
Andrew J. Kelly

We have SQL 2000 server. And our DBA clients connect to the various databases on their using SQL Enterprise Manager installed on each of...

Rich L

02-15-2007 09:06 PM
SQL apprentice

I started with a CSV file which I imported into SQL to create a table. My initial table is employees (ID, LastName, FirstName, Department, Division,...

el

02-15-2007 10:26 AM
el

Hi Our MS-SQL Server 2005 database server runs with American English language setting. I want to make imports from remote client. Local settings on...

ondra

02-15-2007 10:14 AM
ondra

Hi NG, I have two problems with MSDE 2000 installed without any parameter (default). 1 - The default installation is a SP2 and I cannot upgrade to...

Gigit

02-12-2007 06:25 AM
Andrea Montanari

Hello All, I am not sure whether this is the right group, but still would like to get some ideas. I am a DBA and I have a PocketPC with Windows...

Saravanan

02-11-2007 09:48 AM
Andrew J. Kelly

I am trying to create user in SQL Server 2005 Express Edition but I was failed to do so. here is the error. TITLE: Microsoft SQL Server Management...

Rogers

02-07-2007 11:14 PM
makrand g

Hi all We have a server in our DMZ which need to talk (SECURLEY) with SQL 2000 i have done this....by configuring a really tight rule on our...

PK

02-07-2007 11:08 PM
Sue Hoegemeier

What should I be looking for when 1/2 the Windows 2000 clients connect via ODBC yet the other half do not? The error being returned is: SQL State...

Chris

02-07-2007 10:22 PM
Sue Hoegemeier

Is there a way to tell if a SQL database is currently being accessed by any clients? Is it possible to see which clients/users are currently...

Scott

02-07-2007 10:13 PM
Sue Hoegemeier

The sort performance of my Access form is very slow. The datasource is a stored procedure. The sort is changed by setting the OrderBy...

TLD

02-06-2007 12:14 AM
Mike C#

Hi all My Access Application uses a MS SQL 2000 Server as back-End DB. Question: Is it possible through VBA Code to set following attributes within...

Marcel Stoop

02-05-2007 07:20 AM
Marcel Stoop

Hello, I installed the Enterprise evaluation edition on a virtual windows 2003 server I can connect to SQL Server from the management studio when i...

Ishan Bhalla

02-01-2007 10:11 PM
Kyle Hanrahan

have a look in BooksOnLine for ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/toolref9/html/469ea8e2-79b9-44c8-bb6f-f0e1c5dbf0f2.htm -- Andrew J. Kelly SQL...

Andrew J. Kelly

01-28-2007 07:55 AM
Wayne

You will have to eihter run the application using the runascommand or use the betwork password section in Windows to store the appropiate passwords...

Jens

01-25-2007 04:07 AM
Marcus

I want to add login in SQL Server 2005 through Query Analyzer and grant him System Administrative Role through query analyzer, can any one help me...

Rogers

01-25-2007 02:39 AM
Jens

I would appreciate if any one can recommend me SQL Server 2005 administration book that would helpful for administration as well as helpful for...

Rogers

01-24-2007 05:42 PM
Rogers

i can't connect to MS SQL 2000 server. Please advice. I am running this from command line. Apache2, PHP5, Ubuntu Dapper. 0>...

samir

01-23-2007 10:02 PM
Sue Hoegemeier

Do you mean access SQL Server from Microsoft Access? Linked tables isn't the only way. You can use pass through queries, ADO code - probably some...

Sue Hoegemeier

01-23-2007 09:46 PM
Sue Hoegemeier

Hi, I have a job that execute a stored proc. It was running fine like 3 minutes to finish but a week ago it started to take 4 hours. Its using ad hoc...

DARR

01-23-2007 03:52 PM
Joe Yong

I am just wondering if I wanna upgrade my MCDBA 2000 certification to MCDBA 2005 then which exam I have to clear ? Thanks

Rogers

01-22-2007 08:32 AM
Jens

I need to create my own SQL Client and am looking for resources on the protocol used to communicate to the Server via port 1433. Any info would be...

Scott Townsend

01-19-2007 07:57 AM
Michael Epprecht [MSFT]

Hello: I just want to ask a quick question just for my future reference. There's no emergency or anything. Take this scenario. Client...

childofthe1980s

01-15-2007 09:03 PM
Sue Hoegemeier

This may be a naive question. Since DB Transactions with higher isolation levels internally use locks, does it make sense to use Transactions...

Chakravarthy

01-15-2007 02:30 PM
Mary Chipman [MSFT]

Can I Alter any of the table through stored procedure. I tried but it didn't work, if any one guide then I would really appreciated. Thanks

Rogers

01-15-2007 01:28 PM
Rogers

We recently moved our main application from a work group environment, to a server environment. What are the trade offs in having our users becoming...

Mernick

01-14-2007 03:13 PM
Rich N

Obviously, you have unknown (NULL) values in source column, and your destination column does not allow NULL values. You can alter the...

Dejan Sarka

01-12-2007 02:04 AM
Dejan Sarka

I will try to keep this as concise as possible. I am trying to set up a new SQL Server 2005 Express server. The OS is Windows XP Pro SP2. SQL...

William Downey

01-10-2007 11:16 PM
Greg

When i try to replicate a production database as a new development database by creating an empty DB called, say 'AppDev' in Enterprise Manager, and...

Chakravarthy

01-07-2007 12:18 PM
Andrew J. Kelly

hi everybody well im trying to create a linked server were the source is a database on SQL server 2000 and the destination is an SQL server 2005 and...

alcatraz

01-07-2007 12:17 PM
Andrew J. Kelly

You could use Global ##Temp tables. But then again, you will still be using a table on the server, and the clients will have to poll that table for...

Arnie Rowland

12-30-2006 08:31 PM
msgroup

Hi, I don't know if anyone can help with this. When I open a table in the management console and try to edit data I usually get an error...

Andy

12-22-2006 06:39 AM
Andy

On my workstation I need SQL 2000 EntMgr for ongoing support. I installed MSVS .Net 2005 and it installed SQL 2005 Express. I know I have a set...

doug

12-21-2006 09:11 PM
Central Washington

You 'could' go to , , , , and add a 'hot-key' combination for that string. However, it is widely considered outside the scope of 'Best Practices'...

Arnie Rowland

12-18-2006 09:23 PM
Arnie Rowland