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 02: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 11: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 08: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 02: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 09: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 02: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 04: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 02: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-08-2006 12:51 AM
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 12:27 PM
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 02:23 PM
Arnie Rowland

I have spent the best part of 4 days trying to connect to SQL 2005 express from an winforms app! Yes , I have checked surface config and TCP/IP blah...

gregory.white@ntlworld.com

12-03-2006 08:52 AM
Gregor Stefka

I'm hosting a number of Web sites and web servers for my and a user inquired about SQL Reporting services. We don't host SQL btw another group does...

noone

12-02-2006 05:59 AM
noone

Hi, I want to develop a code generator for our Data-Access Layer and I'd like to know if there are queries I can make to have the table and...

ThunderMusic

12-01-2006 04:53 PM
Arnie Rowland

SELECT serverproperty( 'ProductLevel' ) -- Arnie Rowland, Ph.D. Westwood Consulting, Inc Most good judgment comes from experience. Most experience...

Arnie Rowland

12-01-2006 04:00 PM
Arnie Rowland

Can any one give me any URL where I can find the locking Hint with example. I have a two query in one my stored procedure and in the that its...

Rogers

11-23-2006 06:33 PM
Hugo Kornelis

Hi, I have a VB6 application that connects to a sql server 2000. The installation process worked fine for several years (I use visual...

Leo Leys

11-23-2006 02:37 PM
Leo Leys

preciso fazer uma consulta que me retorne a soma de valores dos meses e anos como segue abaixo independente de ter valores ou nao campos q tenho....

Marco A.

11-23-2006 02:22 PM
Marco A.

hi! to all thankyou to shashi EggHeadCafe.com - .NET Developer Portal of Choice http://www.eggheadcafe.com

how to increase the access speed sqlserver to sqlclientcontrol

11-23-2006 01:08 AM
how to increase the access speed sqlserver to sqlc

hi! to all thankyou to shashi EggHeadCafe.com - .NET Developer Portal of Choice http://www.eggheadcafe.com

how to increase the access speed sqlserver to sqlclientcontrol

11-23-2006 01:08 AM
how to increase the access speed sqlserver to sqlc

Dear Professional, I am using one extended stored procedure to send email from SQL Server. Now the question is how can I email my self from SQL...

Rogers

11-22-2006 07:11 PM
Arnie Rowland

Hi, I inserted data with whitespace in XML column and the space is stored as entitized string "& # x 2 0 ;". MSSQL seems to entitize some characters...

KM

11-22-2006 10:56 AM
Roger Wolter[MSFT]

I am using extended stored procedure xp_sendmail to send the email now my question is, is there any way in can write the out of following query...

Rogers

11-22-2006 08:36 AM
Rogers

I have a script for my database that works wonderfully in SQL Manager Express. I'd like to feed it to sqlclient.executenonquery. But as a mimimum...

Al Christoph

11-21-2006 01:11 AM
Roger Wolter[MSFT]

Hi, I have installed MS SQL 2000 with only the connectivity tools. I discovered that there is not entry of the MS SQL in the Add/Remove...

Daniel

11-14-2006 10:30 PM
Hari Prasad

Hello! I would like to connect to an offsite SQL server (using SQL Server Management studio) using a different set of domain credentials (its on a...

dmoney

11-13-2006 02:37 AM
dmoney

Hi All, Is there any way to import a text file into a table in sql server 2005 prefarabley in its gui (MS SQL Server Management Studio)? Thanks.

sara

11-08-2006 10:19 PM
Sue Hoegemeier

Hi, I have a SQLServer 2005 Enterprise Edition installed on a server running w2003. I'd like to install the Business Intelligence Development Studio...

Ana_T

11-08-2006 10:07 PM
Sue Hoegemeier

I am using SQL Server 2005 Express Management Studio. I want to put in multiple filters for stored procedure. Example: where sp name...

Todd

11-08-2006 11:20 AM
Arnie Rowland

I have query from SQL server 2000 which returns from database very large. However I show client only 20 records per page. I need to find way...

Aleks Kleyn

11-07-2006 02:35 AM
Arnie Rowland

Presently dealing with the trial version and did not see one . Is there an authentic SQL 2005 Enterprise Screensaver? Please advise

Maurice

11-06-2006 05:33 PM
Arnie Rowland

Hi All, Not sure if this is the right forum to post this! VB 2005 Prof, SQL server 2005, Windows application Scenario: In a winform application,...

AnikSol

11-06-2006 10:21 AM
AnikSol

Hi, VB 2005 Prof, SQL server 2005, Windows application - I am using transaction scope and within this scope I am passing multiple SQL statements to...

AnikSol

11-06-2006 08:28 AM
Charles Wang[MSFT]

Hi, I'm confused with one task. I'm working with sql server mobile. I've created a database (sdf) and now I want to create sql script that will...

Tom

11-06-2006 06:14 AM
Tom

I have three tables imported from Access that had relationships with eachother and had Cascading Deletes set to TRUE. The tables related in a simple...

Greg

11-02-2006 09:51 PM
Peter Yang [MSFT]

I am a novice SQL guy so you all take it easy on me. I am trying to run a query and one of the columns of my has values that is referenced in...

Aaron

11-01-2006 01:43 PM
Arnie Rowland

Scenario: 1. Virtual Directory set up on SQL_Server 2000 running server 2003. 2. User account created on this server and access set up to the...

Bill

11-01-2006 04:20 AM
Bill

Hi, We are in search of beta testers for our new SQL Comparison and migration tool. Basically, you download, test it, send us bug you've found or...

yoni@nobhillsoft.com

10-31-2006 09:28 AM
yoni@nobhillsoft.com

Hi, When detaching my db a msg came back skating that I have over 300 connections to it. I know at the moment I was the only one connected so,...

Mike_T

10-30-2006 02:52 AM
Arnie Rowland

I have a column named "ID" and its type is "uniqueidentifier" in SQL Server 2005 Express. this column is the primary key and its default value is...

Leon_Amirreza

10-29-2006 10:29 AM
Arnie Rowland

Must have strong stored procedure, trigger, and user-defined function skills. Must understand SQL transaction model and deadlocks. Must...

Richard Douglass

10-27-2006 12:56 PM
Richard Douglass

Fix your system clock, Leon!

Aaron Bertrand [SQL Server MVP]

10-26-2006 11:58 AM
Arnie Rowland

I have a workstation running SQL Server 2005 with mixed mode. I have enabled remote access and allowed access through the firewall. All of the...

Matt Soukup

10-25-2006 09:34 PM
Sue Hoegemeier

I am having some difficulty understanding the MSDN documentation on the useinternaltransaction option of the sqlbulkcopy class. It seems to say...

mikeL

10-20-2006 02:12 PM
mikeL

I found the article abount linking exchange server with Sql 2005 EXEC sp_addlinkedserver 'exchange', 'Exchange OLE DB...

BMW

10-19-2006 11:46 PM
Sue Hoegemeier

Hi; I installed the dev version of SqlServer 2005 and can access it fine on the server it is on. And the properties say it allows remote...

David Thielen

10-16-2006 01:59 PM
Arnie Rowland

Hi; I installed the dev version of SqlServer 2005 and can access it fine on the server it is on. And the properties say it allows remote...

David Thielen

10-15-2006 04:05 PM
David Thielen

I am using DateDiff format like DATEDIFF(hour,Start,End) and it gave me the result 12 hours. Start:- 22 Sep 2006 09:30:00 End:- 22 Sep 2006...

Rogers

10-15-2006 07:16 AM
samay

Is there any way I can comapre the new value of text, ntext and image with the existing text, ntext and image column value. I have to do validation...

Rogers

10-13-2006 10:18 AM
Amit Basu

I am using visual studio 2005 and trying to upload image / binary data from the application side and trying to save into SQL Server 2000 - image...

Rogers

10-13-2006 09:57 AM
Amit Basu