| | Rating Thread /
Thread Starter | Last Post | 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 | 1 | 103 |
|  | Ohhh....Thanks Dinish
Allan Mitchell
|
08-15-2003 05:40 PM
george | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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] | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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] | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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] | 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 | 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 | 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 | 0 | 393 |