dbTalk Databases Forums  

Sponsored Links

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

Discuss in the microsoft.public.sqlserver.clients forum.

Post New Thread
Threads in Forum : microsoft.public.sqlserver.clients Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
You will have to eihter run the application using the runascommand or use the betwork password section in Windows to store the appropiate passwords...
01-25-2007 03:07 AM
Marcus Go to last post
1 130
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...
01-25-2007 01:39 AM
Jens Go to last post
1 193
i can't connect to MS SQL 2000 server. Please advice. I am running this from command line. Apache2, PHP5, Ubuntu Dapper. 0>...
01-23-2007 09:02 PM
Sue Hoegemeier Go to last post
1 343
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...
01-23-2007 02:52 PM
Joe Yong Go to last post
1 167
I am just wondering if I wanna upgrade my MCDBA 2000 certification to MCDBA 2005 then which exam I have to clear ? Thanks
01-22-2007 07:32 AM
Jens Go to last post
3 197
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] Go to last post
1 153
Hello: I just want to ask a quick question just for my future reference. There's no emergency or anything. Take this scenario. Client...
01-15-2007 08:03 PM
Sue Hoegemeier Go to last post
1 161
This may be a naive question. Since DB Transactions with higher isolation levels internally use locks, does it make sense to use Transactions...
01-15-2007 01:30 PM
Mary Chipman [MSFT] Go to last post
2 165
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
01-15-2007 12:28 PM
Rogers Go to last post
2 172
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...
01-14-2007 02:13 PM
Rich N Go to last post
13 366
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 Go to last post
5 223
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...
01-07-2007 11:18 AM
Andrew J. Kelly Go to last post
1 158
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...
01-07-2007 11:17 AM
Andrew J. Kelly Go to last post
1 195
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 Go to last post
2 194
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...
12-21-2006 08:11 PM
Central Washington Go to last post
7 268
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...
12-15-2006 01:51 PM
Rogers Go to last post
6 226
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 Go to last post
2 235
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 Go to last post
8 253
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 Go to last post
3 238
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 Go to last post
1 155
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...
12-07-2006 11:27 AM
sekhar Go to last post
3 244
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 Go to last post
1 194
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...
12-03-2006 07:52 AM
Gregor Stefka Go to last post
2 279
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...
12-01-2006 03:53 PM
Arnie Rowland Go to last post
3 185
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...
11-23-2006 05:33 PM
Hugo Kornelis Go to last post
4 248
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 01:22 PM
Marco A. Go to last post
2 260
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...
11-22-2006 06:11 PM
Arnie Rowland Go to last post
6 238
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...
11-22-2006 09:56 AM
Roger Wolter[MSFT] Go to last post
1 193
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...
11-22-2006 07:36 AM
Rogers Go to last post
2 212
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 12:11 AM
Roger Wolter[MSFT] Go to last post
1 189
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...
11-14-2006 09:30 PM
Hari Prasad Go to last post
2 258
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.
11-08-2006 09:19 PM
Sue Hoegemeier Go to last post
1 208
Hi, I have a SQLServer 2005 Enterprise Edition installed on a server running w2003. I'd like to install the Business Intelligence Development Studio...
11-08-2006 09:07 PM
Sue Hoegemeier Go to last post
1 179
I am using SQL Server 2005 Express Management Studio. I want to put in multiple filters for stored procedure. Example: where sp name...
11-08-2006 10:20 AM
Arnie Rowland Go to last post
6 209
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 01:35 AM
Arnie Rowland Go to last post
1 195
Presently dealing with the trial version and did not see one . Is there an authentic SQL 2005 Enterprise Screensaver? Please advise
11-06-2006 04:33 PM
Arnie Rowland Go to last post
1 166
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,...
11-06-2006 09:21 AM
AnikSol Go to last post
5 370
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...
11-06-2006 07:28 AM
Charles Wang[MSFT] Go to last post
4 224
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...
11-02-2006 08:51 PM
Peter Yang [MSFT] Go to last post
1 189
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...
11-01-2006 12:43 PM
Arnie Rowland Go to last post
3 227
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,...
10-30-2006 01:52 AM
Arnie Rowland Go to last post
1 142
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...
10-29-2006 09:29 AM
Arnie Rowland Go to last post
4 348
Fix your system clock, Leon!
Aaron Bertrand [SQL Server MVP]
10-26-2006 10:58 AM
Arnie Rowland Go to last post
1 152
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 08:34 PM
Sue Hoegemeier Go to last post
1 387
I found the article abount linking exchange server with Sql 2005 EXEC sp_addlinkedserver 'exchange', 'Exchange OLE DB...
10-19-2006 10:46 PM
Sue Hoegemeier Go to last post
3 302
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 12:59 PM
Arnie Rowland Go to last post
3 1,338
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...
10-15-2006 06:16 AM
samay Go to last post
4 284
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...
10-13-2006 09:18 AM
Amit Basu Go to last post
3 193
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...
10-13-2006 08:57 AM
Amit Basu Go to last post
2 212
Hello SQL 2000 SP3a run fine with an linked server query like select * from openquery( linkedOlapServer, .. here is the MDX ...') After installing...
10-12-2006 03:46 PM
Warren Brunk Go to last post
1 382
Post New Thread

Display Options
Showing threads 401 to 450 of 1968
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2015, Jelsoft Enterprises Ltd.