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     
How can a DBCC shrinkfile of a datafile cause a deadlock ? I can never seem to make it work. Always results in deadlock
Hassan
08-16-2003 08:25 AM
Andrew J. Kelly Go to last post
1 103
Ohhh....Thanks Dinish
Allan Mitchell
08-15-2003 05:40 PM
george Go to last post
2 85
I am attempting to run SQL Server replication across the public Internet inside a SSL VPN Tunnel (Aventail). The SQL Client (an MSDE...
news.microsoft.com
08-15-2003 06:27 AM
news.microsoft.com Go to last post
0 83
Symptom: I insert a row into this particular table using my MS-ACCESS front end, and the table row poulates with another (already exisitng) table...
Mike
08-14-2003 11:42 AM
Mike Go to last post
0 79
The FindFirst function in Access doesn't even work all that well with a Jet database, much less with SQL Server. Most experienced Access developers...
Mary Chipman
08-14-2003 10:01 AM
Mary Chipman Go to last post
0 67
does this command return indexs in a database table i have tried sqlprimarykey and that works what odbc command get the indexs in a database...
Stephen Ryan
08-13-2003 10:46 PM
Stephen Ryan Go to last post
0 92
After I update SP3 with sql2ksp3a, I found I am having the following problem: Query is running extremely slow for a simple query like "select * from...
susie
08-13-2003 01:47 PM
susie Go to last post
0 80
How can I convert datepart(week,getdate()) back to the last date of the week? Example, 8/13/2003 is week 33. How I get the first and last date of the...
Emma
08-13-2003 12:54 PM
J O Holloway Go to last post
2 61
I am trying to register a SQL server in Enterprise Manager 2000 and getting this error. I am on a LAN behind a Linksys BEFSR41 router and attempting...
Gerald Moore
08-12-2003 07:37 PM
Gerald Moore Go to last post
3 96
hello all, I have the .sql script file that I need to run to update the SQL 2000 database. How do I run the script file? thanks.
ken
08-12-2003 03:22 PM
Erland Sommarskog Go to last post
1 69
Sounds like you need to change the configuration of the server not just the client. There is a tool in the SQL Server programs menu that is...
bigufo8
08-12-2003 07:25 AM
Andrew J. Kelly Go to last post
6 137
Hi, I have MSDE 2000 installed on a laptop and I am able to connect to it by using SQL Sever 2000 client tolls installed on the same machine but not...
Srini
08-11-2003 12:31 PM
Andrew J. Kelly Go to last post
3 84
Hello, I am trying to use Enterprise Manager on XP Pro to connect to a remote MS SQL server. When I try to run the Enterprise Manager I see the...
james
08-11-2003 10:59 AM
James Go to last post
1 80
Hello I am a novice in using SQL Server 2000 enterprise edition I am trying to copy a Database (through scripting) which has relationships...
ItsMe
08-10-2003 07:28 PM
Dinesh.T.K Go to last post
2 83
Hi! In our company we want to build our dedicated server to put it in a collocation company. I'm very unclear with the licensing programs...
Daniel Harel
08-09-2003 12:20 PM
Andrew J. Kelly Go to last post
3 78
While in the past Analysis Manager had no problem viewing cubes, building mining models, and running in pivot table services, it started missbehaving...
Jim
08-08-2003 12:36 PM
Shawn Aebi [MSFT] Go to last post
1 83
My company is in the process of migrating a FoxPro Application's data to SQLServer2000. We have recompiled the FP code with VFP 8.0. I have tried...
mgorman30
08-07-2003 10:46 PM
Cindy Winegarden Go to last post
1 86
SQL Expert, FYI: SQL Analyzer Hang! I am running SQL 2000 Personal Edition with SQL2K Service Pack# 3a on a Windows XP 2000 Professional OS Service...
TM
08-07-2003 06:50 PM
Nigel Rivett Go to last post
1 90
i am trying to install SQL Server 2000 client tools on my computer. I get all of the way through the setup and then when i click the finish button...
mrsparky
08-07-2003 11:40 AM
Sue Hoegemeier Go to last post
1 84
I don't have full admin rights. The server is a remote server and I only have rigthts to 2 of the databases on the server. I can see all of the...
Hutchma
08-07-2003 08:23 AM
Keith Kratochvil Go to last post
2 87
We have a VB based client that works with a remote SQL Server through internet. Often the the application hangs in spite of the fact that the...
Radu
08-07-2003 02:50 AM
Radu Go to last post
0 69
You might want to check out the DTS wizard in BooksOnLine. Here is a link that may be of interest as well. www.sqldts.com -- Andrew J. Kelly SQL...
Andrew J. Kelly
08-06-2003 06:27 PM
Andrew J. Kelly Go to last post
0 67
This worked for me: DoCmd.OutputTo acOutputStoredProcedure, "EXEC myproc prm1, prm2", acFormatXLS, filename, False It appears that Mary's...
mikestorms
08-06-2003 03:22 PM
mikestorms Go to last post
0 261
Font's don't get stored in the database, just the text. How you display it is up to your front end tool and not the database. Anon Unicode ...
Andrew J. Kelly
08-05-2003 05:44 PM
Andrew J. Kelly Go to last post
0 72
I am new to SQL Server and have a question. I am using SQL server 2000. When, in diagrams, you create a l link between two tables are you...
Woody Splawn
08-05-2003 04:02 PM
Dinesh.T.K Go to last post
1 91
Can someone tell me how to add licenses so that I can add users to my server. Your response will be greatly appreciated. Thank you, Thaddis Creamer
Thaddis Creamer
08-05-2003 08:26 AM
Dinesh.T.K Go to last post
1 80
I don't know the specifics on checking to make sure that the server is listening. I have to imagine that there is a way to determine that...
Keith Kratochvil
08-04-2003 04:33 PM
Keith Kratochvil Go to last post
1 85
"Tonya Tubbs" <tonya.tubbs (AT) crossplainsbank (DOT) com> wrote It looks like you need to call Microsoft support to get this utility. Here are...
Steve Thompson
08-04-2003 02:40 PM
Steve Thompson Go to last post
0 72
Hi Paul, I used the following code: Dim sql As SQLDMO.SQLServer = New SQLDMO.SQLServerClass sql.Connect(<servername>) sql.QueryTimeout = 600 Dim...
Paul Welbourn
08-04-2003 11:15 AM
Bill Cheng [MSFT] Go to last post
3 161
Ok, I finally figured out SQL somewhat. I cannot upsize all of my databases using the upsize wizard provided with Access 2000. I can upsize some...
aaronshover
08-04-2003 06:41 AM
Ragnar Midtskogen Go to last post
2 85
I need to know what is the period of time after wich the SQLServer is closing an idle connection with a client (no activity from the...
Razvan
08-04-2003 03:54 AM
Razvan Go to last post
0 85
Does anyone know of a technique/tool for backing up a database on a remote machine. My ISP provides me with s SQL Database within their SQL...
Alan Roberts
08-01-2003 06:17 PM
DonD Go to last post
3 112
I have linked a server called OSERV in enterprise manager. The following works fine in Query Analyzer Select * From OSERV..OSERV.EAME_PRODUCTS_COSTS...
K Burns
08-01-2003 05:59 PM
DonD Go to last post
1 80
We have a need to connect Oracle 8.1.7 running on Solaris Unix to AS400 Data residing on a V5R1M0. I know we can use a gateway product, but can we...
petemacmahon
08-01-2003 05:42 PM
DonD Go to last post
2 77
equivalent to the autonumber function you are talking about. If you drill down to the tables under enterprise manager, and open the table in design...
DonD
08-01-2003 05:22 PM
DonD Go to last post
0 77
Good morning everyone, Using C# I create a bog-standard System.Data.DataTable which I then Add to a System.Data.Dataset. At the moment I'm in the ...
Plumer
08-01-2003 03:08 PM
Plumer Go to last post
0 74
I am using SQL Server 2000 Client (Personal Edition) with Service Pack# 3a. My OS is Windows XP Pro. SP1a. In the Sql Analyzer, previous...
TM
08-01-2003 09:03 AM
TM Go to last post
1 78
we just re-did our server a few days ago, and ever since, i keep getting this error: Server: Msg11004, Level 16, State 1 Cannot generate SSPI...
Patricia Kline
08-01-2003 08:27 AM
Dinesh.T.K Go to last post
2 74
We have several remote users connecting through Terminal Services getting following error: System Message 6024: Error opening data base with...
B
07-31-2003 06:50 PM
Ray Higdon Go to last post
2 99
I used the link table wizard to link to some SQL server tables. Everything works fine if I am viewing the data, but when I try to edit or delete...
Sara
07-31-2003 04:54 PM
Sara Go to last post
0 56
For MS SQL Server 2000 and Delphi 5, I would like to access and change global variables within a DTS package. I can access the package and execute...
J O Holloway
07-31-2003 02:05 PM
J O Holloway Go to last post
1 103
Thank you Scott, I had seem some of those posts, but none of them describe the apparent unpredictable behavior that I see and therefore does not...
Ragnar Midtskogen
07-31-2003 12:27 PM
Ragnar Midtskogen Go to last post
3 82
Good day.. There is one question... I do select* from "any_table_name" option(fast 50) This all I write in Enterprise Manager's SQl Query Analyser,...
Tigran
07-31-2003 01:22 AM
Allan Mitchell Go to last post
1 83
I get the following error when connecting to Analysis Services Server as a client. My machine the client's Operating system is Win 2000 Professional....
Ramesh
07-30-2003 03:15 PM
ramesh Go to last post
1 112
hi all, I writes the following procedure which is update the specific table according to given parameters. But I have no idea why it is giving...
Farhan Iqbal
07-30-2003 05:26 AM
Farhan Iqbal Go to last post
2 420
Is there a way to install the SQL client on a windows XP Pro workstation? Thanks
Rob
07-29-2003 11:18 AM
Dinesh.T.K Go to last post
1 87
It kind of depends on your application I believe... I mean, if you are opening several datasets then by all means, open one connection, open all of...
Scot Rose [MSFT]
07-29-2003 08:50 AM
Scot Rose [MSFT] Go to last post
0 78
I got the following interview question which beats me: How to insert rows into a table without triggering the active insert trigger of this...
Bruce
07-29-2003 08:07 AM
Scott Morris Go to last post
1 105
Hello All Can any one help me out to create Jobs and Run Jobs on Sql- server Agent which is in the Management Folder. Thanks
irs
07-28-2003 09:34 PM
John Alford Go to last post
1 91
Clients can access the database but when they try to print a report, get a "cannot open SQL Server EXECUTE <PEStartPrintJob> message. Any ideas?
Connie
07-28-2003 11:35 AM
Connie Go to last post
0 393
Post New Thread

Display Options
Showing threads 2401 to 2450 of 2530
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 - 2012, Jelsoft Enterprises Ltd.