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-22-2007 11:00 PM
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 09: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 02: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 08: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 10: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 08: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 08: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 09: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 09: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 05: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 08: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 10: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 10: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 09: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 09: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-05-2007 11:14 PM
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 06: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 09: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 06: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 03: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 01: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 04: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 09: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 08: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 02: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 07: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 06: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 08: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 01: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 12: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 02: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 01: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 10: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 11:18 AM
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 11:17 AM
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 07: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 05: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 08: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 08:23 PM
Arnie Rowland

How I can change the tempdb location from C:\ to E:\ drive without any downtime. Please send me the query to implement this as I am getting this...

Rogers

12-15-2006 01:51 PM
Rogers

I want to run textcopy from one of my stored procedure but I don't want to see the message like successfully done, is there any way I can remove...

Rogers

12-15-2006 10:00 AM
Rogers

Hello, Just see if you insert NULL into Contact_ID field. Please take a look into table schema using SP_HELP <TableName> and verify the data you are...

Hari Prasad

12-14-2006 07:59 PM
Hari Prasad

Duh-O!!! What you are looking at is the OrderDate -which happens to be July 1st, 2001. If you add ShipDate to the SELECT columnlist, you will see...

Arnie Rowland

12-13-2006 01:18 PM
Arnie Rowland

Can any one help me in this.im working with java now.now i need to use all my reports which i have done in crystal report 9 in java ie i need to call...

samay

12-10-2006 08:53 PM
samay

I see that I have an instance of SQLSERVR.EXE in my task manager, and I certainly didn't start it, and can't think of any applications or...

Chris Shearer Cooper

12-09-2006 01:58 PM
Hari Prasad

Thanks John and Jasper. The SQL Manager looks good. Chris "John Bell" <jbellnewsposts (AT) hotmail (DOT) com> wrote

Chris Wood

12-08-2006 03:53 PM
Chris Wood

I need to transfer a tables data between a sql2000 server table and a sql2005 server table using the 2005 server management studio. I knew how to do...

Robert Dufour

12-08-2006 01:43 AM
sekhar

What are the steps to be able to add a 2005 server to a server group in the 2000 enterprise manager? Thanks for any help, Bob

Robert Dufour

12-07-2006 11:51 PM
Arnie Rowland

I have a user application that runs on MS Access 2000. On one client PC, the user's PC log in and got the following error: 17AQL Server does...

Sam

12-07-2006 11:27 AM
sekhar

I have a Client/Server application where the Client is MS-ACCESS 2000 and the Server is SQL SERVER 2000. The two entities reside on...

Hans Munkwitz

12-06-2006 01:23 PM
Arnie Rowland