|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
Admin password
Uncle Ben -
14 May 2005 6:55 PM - 2 messages
After I changed my admin password in Windows, my SQL Server Service Manager (i.e. the Agent) no longer starts up. How do I fix this? ...
Slow fetches and network buffer size
andsm -
14 May 2005 4:31 PM - 3 messages
I have SP which returns about 4.5 kb of data. Network buffer siize parameter on SQL Server is 4 kb. Fetch time for the SP is ~100-200 ms. If call same SP from same computer where located SQL Server, total execution time is 30 ms. ...
Corrupted table
Andrew Chalk -
14 May 2005 3:38 PM - 9 messages
When I try and examine a table in one of my MS SQL Server 2000 databases I get the following error from Enterprise Manager: [Microsoft][ODBC..] I/O error (bad page ID) detected during read at offset 0X00000000038000 in file ...MDF ...
Upgrading a W2K3 server with SP4 beta applied
Chris Wood -
14 May 2005 3:26 PM - 3 messages
Hi, I have been reading the installation info. It goes to great lengths to explain about MDAC 2.8 SP1 and MSXML 3.0 SP7. From my understanding on a W2K3 server, without SP1, it will not update MDAC 2.8 to SP1. Would I be ...
SQL Server 2005 Beta2 or Newer
Joe K. -
14 May 2005 2:46 PM - 2 messages
I downloaded SQL Server 2005 Beta2 approximately 3 months ago but I reformat the hard disk to my test server. What is the link to the download site? Thanks. ...
return all rows function
chunky -
14 May 2005 12:50 PM - 1 message
in sql 2000 when you right click a table you can see the option return all rows... where can i find that function in sql 2005 beta2? ...
return all rows function
chunky -
14 May 2005 12:46 PM - 1 message
in sql 2000 when you right click a table you could see the option return all rows... where can i find that function in sql 2005 beta2? ...
how do I delete messages that I posted to this newsgroup?
hsifelbmur -
14 May 2005 11:21 AM - 2 messages
how do I delete messages that I posted to this newsgroup? ...
linked server problem with @@SERVERNAME
The Gekkster via SQLMonster.com -
14 May 2005 7:33 AM - 4 messages
Hey all, In a stored procedure that retrieves data from a linked server, I want to do a simple 'test' for availability before attempting to carry out the SP's tasks: The linked server is 'defined' as its IP. DECLARE @serverUP varchar(100) ...
connecting to SQL Server 2000
Ansari -
14 May 2005 7:19 AM - 2 messages
hi all; I have a SQL server ent. edition installed on windows 2003, I want to register another SQL server instance installed on windows xp, in my enterprise manager. When I try to do that i get the following error message. ...
Regarging the Blank Field in SQL Server
Himanshu -
14 May 2005 5:20 AM - 3 messages
hi all, can anybody tell me that how will i prevent to store the blank fields in any table. if i uncheck the allow null property of a field in a table then it only bloks null values. bit through application ehwn i store values from a ...
Not able to connect to SQL Server after removing it from network
Vikas -
13 May 2005 10:44 PM - 2 messages
I have my application that is running against MS SQL 2000 database (both on the same machine). If I unplug the network cable from that machine then my application is not able to connect to SQL Server. If I take my machine and ...
SQL 2000 Install Fails with "setup Initialization error access den
thomas kobal -
13 May 2005 9:38 PM - 4 messages
I tried a sql server install and get: "setup Initialization error - access denied" Source: E:\x86\setup\sqlspre.ini Target: C:\Docume~1\Admini~1.domain\locals~1\Temp\Setupsql.ini Now it looks as though it wants to use a faulty directory, is there a way to ...
Null fields (username, host, etc) returned in a trace!?!
Dom -
13 May 2005 7:05 PM - 4 messages
I would be really grateful if someone would help me with this as I'm really stumped... I've written a stored procedure to enable me to kick off traces from the SQL Agent and they run just fine - the problem is that some of the fields ...
SQL server 2000 domain change
mcunningham -
13 May 2005 7:01 PM - 2 messages
I want to change the domain my sql 2000 server belongs to. What do I need to do to ensure proper execution of this process? This server is not part of a cluster and all accounts are local. There are no links either. ...
How to read (SQL SERVER Mini Dump) MDMP files ?
Raju -
13 May 2005 6:17 PM - 2 messages
Can some one let me know if there is any tool to read the MDMP files? Regards, Raju ...
Nonpaged pool ? What is it ?
Hassan -
13 May 2005 6:01 PM - 6 messages
The server was unable to allocate from the system nonpaged pool because the pool was empty . We keep seeing the above errors and our server crashes. I am trying to understand the basics here as to what is the nonpaged pool ? ...
forcing string value in table
Paul -
13 May 2005 6:01 PM - 3 messages
Hi just wondering if there is a way to have a script that creates a table write in a desired string for the first table entry? I have an application that I am allowing the de-activation of a record. I ...
Tutorials in SQL Server 2005 Beta 3
Greg@food family -
13 May 2005 5:30 PM - 2 messages
I am following the Customer List DTS tutorial in SQLServer Beta 3 and it tells me to launch BI Develpment Studio, then select File, New, Project. It says make sure Business Intelligence Projects is highlighted, the select DTS template. After trying to fully install EVERYTHING from my source disks, the ...
Newbie: HELP takes too long for ALTER TABLE!
steve -
13 May 2005 5:19 PM - 4 messages
Hi, I have a table with 16 million lines. After reading about data types and importing it from Access i decided to change some things to save space and make the querries more efficient. I entered the following in SQL Query Analyzer: ...
Unknow user name or bad password.
ChrisR -
13 May 2005 4:45 PM - 5 messages
sql2k sp3 I am boggled here. This isn't the typical scenario that normally generates this message from what I can tell. I have all the necessary permissions from what I know. 2 boxes. 1. All SQL Services run in the same Domain Administrator accout for both ...
Transactional Replication betwn 2 SQL 2000 Srvs w/ diff servicepac
Doug F. -
13 May 2005 4:36 PM - 2 messages
I have a Production SQL 2000 server that is SQL 2000 SP2. We have another server that is a DEV server that is running SQL 2000 SP3a. I need to set up either transactional replication between the Production server (SP2) and the ...
upgrade
Mintu -
13 May 2005 4:30 PM - 1 message
I was trying to to do online upgrade of sql server from 7.0 standard ed. to sql 2000 ent.ed. and I received the error couldn't run the script messages.sql and then installation stopped there. anyone has any idea about ...
Error trying to add full text index
c -
13 May 2005 4:28 PM - 1 message
I'm trying to add a full text index using the wizard however I receive the following error; "The name 'mydatabase' was not found in the Databases collection. If the name is a qualified name, use[] to seperate various parts of the ...
Download SQL Server 7.0
Dílson_Fernandes -
13 May 2005 3:36 PM - 2 messages
Hi, I need download SQL Server 7.0 urgentily. I´m going to install SMS 2.0, and especified this necessitily installation SQL Server 7.0 before. Thanks. Dílson Fernandes ...
dbcc trace flag 1807 for network files
Mangesh Deshpande -
13 May 2005 3:32 PM - 2 messages
Hi I am using in sql server 2000 DBCC TRACEON ( 1807 ) to create datafiles over network just for testing. Now i have to do the same test on "SQLServer 7" and I ran the same script. But I keep getting error. ...
Printing Text in Query Results
Lisa Farina via SQLMonster.com -
13 May 2005 3:24 PM - 6 messages
Hello, How can I print text next to a query result set in Query Analyzer? I have the following results: Foodservice Revenues --------------------- $16,077,196,215.00 $30,244,812,996.00 $177,835,953,607.00 I need it to look like this: ...
Dropping all connections to a database
Doug F. -
13 May 2005 3:03 PM - 4 messages
Is there an easy command I can use within a sql script that will drop all connections to a database, without having to go the SEM and dropping them via Management/Current Activity/Process info? Thanks. DF ...
upgrade to SQL 2000 Enterprise edition from STD edition
Mangesh Deshpande -
13 May 2005 2:45 PM - 5 messages
Hi Please share any doc or procedure or views or cautions to do upgrade from SQL server 2000 STD edition to SQL server enterprise edition 2000. Tks Mangesh ...
Why, Why? is tempdb being written to so much that my write queue is 30+??
Joe Otero via SQLMonster.com -
13 May 2005 2:44 PM - 4 messages
I have a stored procedure that takes 3 parameters. They can be null and the the logic is basically : create procedure a @cola nvarchar.., @colb nvarchar.., @colc nvarchar.. select cola, colb, colc, cold (etc) from tablea inner join tableb (on primary key) ...
restore question on sql2000
Mangesh Deshpande -
13 May 2005 2:44 PM - 3 messages
Hi I have a 60 GB sql 2000 STD edition database backup. I take backup on a remote machine A where I can restore it. But I have to restore the same database on another machine B where it can ...
SQL Server Syntax Enable/Disable/Execute Jobs
Joe K. -
13 May 2005 2:42 PM - 2 messages
I would like to create a script that can you to disable, enable, and execute my job call "daily backup". Please help me with this task. Thank You ...
Will Sql server 2005 Work with VB6 - ADO
Manish Sawjiani -
13 May 2005 1:58 PM - 1 message
Dear experts, i doing an application with sql server 7.0's MSDE and when it will be ready sql server 2005 will be lauched. My worry is will it work with VB 6.0 and ADO 2.5 or should i convince the client to buy Sql Server 2000? ...
Enterprise SQL move to Standard
Paul Bergson -
13 May 2005 1:51 PM - 7 messages
Is it possible to follow the steps of moving ALL db's from an Enterprise SQL Server to a Standard SQL Server? We would like to just stop the SQL services and move the DB's across, rename the server to match the old server and start the new SQL server. ...
Monitor MemToLeave usage
Jan Ahlbeck -
13 May 2005 1:47 PM - 2 messages
Hi, I am interested in detecting possible memory leaks in extended store procedures. Is there a way to monitor MemToLeave usage ? setup: win2k advanced server sp4 (cluster) sql server 2000 advanced server sp3a AWE + PEA Total mem 7Gb Mem for sql server 6Gb ...
repair_rebuild and the transaction log
J Jetson -
13 May 2005 1:21 PM - 4 messages
We have a large-ish database (160GB) which grew to over 300GB last weekend when the maintenance job failed. Half of it is unused but I can't shrink it due to index errors and when I run checkdb it also reports index errors. I ...
Awaiting DTC Message: UOW<tranID> -SQL Server 7.0
govind.mane -
13 May 2005 12:26 PM - 2 messages
Question : Are there any enhancements availbale on SQL Server 7.0 regarding this problem ?? What is the solution ? ...
Display Tabular Form from DBCC SHOWCONTIG Command
Robert Lie -
13 May 2005 9:29 AM - 2 messages
Dear all, I want to display information resulted by DBCC SHOWCONTIG Command in tabular form like below: (Pages Scanned) (Extents Scanned) (Avg. Pages per Extent).. TABLE A TABLE B TABLE C .... Is it possible? ...
Move existing table to another file or filegroup
ales vojacek -
13 May 2005 9:12 AM - 5 messages
Hi, is it possible to move existing table to another file or filegroup? Thanks Ales ...
Cannot start MSSQL Server 7
Water Cooler v2 -
13 May 2005 9:07 AM - 2 messages
I am not able to start the MSSQL Server service on my system ever since I shifted my house and got a new network provider. Earlier, I was on the local cable hub, now my computer is on a DSL network. I don't know ...
replication error - agent is suspect
maxzsim -
13 May 2005 8:25 AM - 3 messages
Hi, I have set up a replication and it was doing the bulk copy from SrvA to SrvB when it says "The agent is suspect as there's no response for the last 10 mins" or something like that ? what could be the problem here ? ...
Domain administrator password change
David Pounds -
13 May 2005 8:01 AM - 3 messages
Hi folks. Sorry if this one's a bit basic, but I'm a SQL 2000 novice. I've just taken over responsability for some servers and I need to change the domain administrator password. I was wondering if changing this will have any adverse affects on SQL. ...
Rights to watch diagrams
Michael Andy Poulsen -
13 May 2005 7:21 AM - 3 messages
In an environment with database designers and developers we would like to give the developers the rights to watch the diagrams created by the database designers. We prefere giving the developers a minimum of rights on the databases and the server. ...
execure store procedure from Query Analizer
Isambella via SQLMonster.com -
13 May 2005 5:56 AM - 5 messages
Hi, I am trying to execute a store procedure from the query analyzer, but I get following error "Could not find stored procedure 'GetSubscriptions'", my store procedure has 3 parameters. I wrote the following statements to the Query Analizer: Declare @Par1 as int, @Par2 as varchar , @Par3 as varchar ...
Can Triggers Help Me out
Manish Sawjiani -
13 May 2005 5:24 AM - 3 messages
Dear Experts, I am storing the rates in pricelist table and these rates are used in several tables. Is is possible to create a trigger that will change rates in all the tables wherever i have used the moment someone changes the rates in pricelist? ...
sqlservr.exe using high I/O
RK73 -
13 May 2005 5:08 AM - 6 messages
Once in a while sqlservr.exe shows a very high I/O. In task manager I/O reads are at 64 Million and I/O writes are at 58 million and I/O Other is at 408 million. The performance monitor shows %Disk time and Avg Disk Queue Length ...
Major Performace problem
Joe -
13 May 2005 4:00 AM - 12 messages
My server slows way down after a couple of days. I'm running an application (directly on the server) which calls a stored procedure several thousand times. This procedure in turn calls another one 6 times. Using the Profiler I see a 4 second delay between calls of the outer (or first) SP. If I reboot ...
Calling Oracle Stored Proc from SqlServer
rslewis232 -
13 May 2005 1:46 AM - 2 messages
I am trying to call an Oracle stored procedure from SqlServer. I have tried both the MS and Oracle OLE DB Providers. I can select records from Oracle and I can insert records to Oracle. The stored proc call dies. ...
VPN - SQL Connection Time OUt
DLS -
12 May 2005 11:34 PM - 4 messages
I'm trying to add a SQL server to my enterprise manager on XP SP2 so I can work off-site. I have named pipes and TCPIP enabled, but do not have port 1433 open on my ISA server. I keep getting a timed-out message. What ...
sql 2005 download
Mangesh Deshpande -
12 May 2005 11:07 PM - 2 messages
Hi I want to test sql 2005. I do not have any membership with MSDN. How can I download and test sql2005? Tks Mangesh ...
Commenets on Running Citrix on SQL Server? Anyone doing this?
Roger -
12 May 2005 9:21 PM - 4 messages
Our work is currently looking at getting a dual processor machine with 4GB Ram to run SQL Server 2000 and as a Citrix server? Is this possible? What gotcha's should I be looking out for? Any comments appreciated... ...
About reply to Combine 3 Queries into One
Lisa Farina via SQLMonster.com -
12 May 2005 8:59 PM - 1 message
Hey Josh, Something happened to your reply. The message got cut off. Could you please repost your answer. Thanks ...
stored procedure
gurvinder gill via SQLMonster.com -
12 May 2005 8:43 PM - 2 messages
Hi I want to create a stored procedure. I have 2 tables called orders and orderdetail.Now i want to move orders from these tables in to new tables called orders2 and orderdetail2.Perticularly those orders which r there more than 60 day(means ...
store procedure
gurvinder gill via SQLMonster.com -
12 May 2005 8:03 PM - 2 messages
Hi I want to create a stored procedure. I have 2 tables called orders and orderdetail.Now i want to move orders from these tables in to new tables called orders2 and orderdetail2.Perticularly those orders which r there more than 60 day(means ...
Errors when running DBCC CheckCatalog command
Sam -
12 May 2005 7:34 PM - 2 messages
One of my users reported an error when testing against one of our Development Servers, against a user databases. The error the application generated contained the following: Could not find row in sysindexes for database ID 9, object ID 1284406774, ...
DTS Error
Daniel -
12 May 2005 6:58 PM - 1 message
when I execute my DTS, I get this error. Does any one can help , Thanks Step Error Source: Microsoft Data Transformation Services (DTS) Data Pump Step Error Description:The number of failing rows exceeds the maximum specified. (Microsoft OLE DB Provider for SQL Server (80004005): ...
open table
Ilann -
12 May 2005 6:35 PM - 4 messages
when I right ona table in the object browser in query analyzer it opens the selected table, in some tables I can edit the content in some, I can't, do you have any idea? Thanks Ilann ...
Combine 3 Queries into One
Lisa Farina via SQLMonster.com -
12 May 2005 6:34 PM - 4 messages
Hello, I have a large database that contains info about several types of business industries. There is a table called Co_Ind_Sales which contains industry sales that I need to sum up for 3 separate industries. There is an Industry_Id in the Co_Ind_Sales table. I am using the following SQL in ...
stupid optimizer tricks
JRStern -
12 May 2005 6:31 PM - 2 messages
Where I'm hanging out these days, they seem to like to put "valid" flags on records in all sorts of tables. So, if I want to search where lastname like 'St%' and firstname like 'S%', even if I have separate indexes on lastname and firstname, the ...
Profiler SQL 2000 SP4 Problem
David Gugick -
12 May 2005 5:31 PM - 2 messages
We're seeing a problem with the Profiler SP4 client. This problem did not occur in the SP4 beta. We have trace tables stored in the database and can no longer open them up from Profiler using the File - Open - ...
Database Maintenance Plan Grief
H Lee -
12 May 2005 5:08 PM - 4 messages
I've been setting up database maintenance plans for years, but lately, I've been stumped by this particular database maintenance plan. All it contains are full backup routines for 2 databases in Simple Recovery Mode in a named instance to write out to a local drive. Every aspect of the ...
StoredProc Help...
j c via SQLMonster.com -
12 May 2005 4:41 PM - 10 messages
Hi all, I am trying to create a StoredProc to return an OUTPUT value. This output is the difference between 2 datetime fields. I have had success with some other OUTPUT StoredProcs, but were very straight forward computations -- ...
Alert & Cache Hit Ratio
C TO -
12 May 2005 4:26 PM - 3 messages
Hello World, How can I set up an alert when the Cache Hit Ratio has averaged lower than 60% for the past n number of hours (with 5 seconds interval) ? We are using Cache Hit Ratio to determine if we need to add more RAM to the ...
The SQL element of Veritas BackupExec 9
Maurice -
12 May 2005 3:41 PM - 3 messages
I have several servers on which I use Veritas BackupExec 9.1 for tape back ups. When I run the MS Baseline Security Advisor it identifies SQL Server 2000 SP3 installed and recommends SP4. Now it is not a full-blown install of ...
synonyms in SQL server 2000
Mangesh Deshpande -
12 May 2005 3:22 PM - 4 messages
Hi I am using linked servers a lot in application. I want to create small meaningfull table name for all these tables. Is there a concept called synonym like in oracle to create small names for these? Example: select * from [sql3].master.dbo.xx; ...
Question on Hardware failover of the MS SQL Server 2000 DB
Mangesh Deshpande -
12 May 2005 3:18 PM - 2 messages
Hi We are planning to purchase powervault 220 S which provides us a clustering mode. We can see the hard drives from both the machines hooked up to the powervault. I want to achieve machine level failovermachine hooked to the powervault ...
Question on the evacuate of the datafile
Mangesh Deshpande -
12 May 2005 3:10 PM - 4 messages
Hi I am using sqlserver 2000. I want to evacuate and drop a datafile. It is around 10gb. My question is Is it a online operation? and is there a performance impact on the database druing this. Are the tables available for DML during the time of evacuation? ...
Trying to make an RPC from Sql Server to Oracle9i
rslewis232 -
12 May 2005 2:45 PM - 1 message
I have tried both the Microsoft and Oracle OLE DB Providers. With both providers, I can SELECT/INSERT data from Sql Server to Oracle. I get the following error when I try to execute an Oracle procedure from Sql Server: ...
HOW CAN I LINK TWO SQL SERVER
Agnes -
12 May 2005 2:24 PM - 4 messages
I had connect another SQL server VIA VPN , the server name is IP e,g 123.123.123.123 I can read the data sucessfully, However, I want to insert some data from my local server. sp_addlinked server '123.123.123.123' ...
Hyperthreading: Negative impact on performance?
lovemyalpacas -
12 May 2005 2:08 PM - 5 messages
A former colleague recently notified me about some some 'benchmark' testing he'd conducted with SQL Server and Hyperthreading - with some interesting results. Basically the conclusion he reached was "HT gives performance increases some of the time but most of the time it really ...
XP_SENDMAIL as a scheduled job
Marcell -
12 May 2005 1:59 PM - 3 messages
Hi I'm having a problem using xp_sendmail as part of a scheduled job. The actual stored procedure is being called from within a DTS package. When the package is executed manually, everything works OK and the mail is sent. ...
Performance Monitor for Indexes
Joe K. -
12 May 2005 1:30 PM - 2 messages
I have a SQL Server 2000 database with numerous indexes. The database developers have reworked the indexes to increase database performance. This database has Windows 2003 as the operating system on this server. What are the performance monitor counters that I should add to my perfmon job ...
The server encountered a stack overflow during compile time.
steven.harris -
12 May 2005 1:28 PM - 6 messages
Hi, Can anyone help? Im trying to run a query and im getting an error. "the server encountered a stack overflow during compile time." The query is fairly large (300k) and in the form of; SELECT * FROM Drug WHERE ([DrugKey] = 1 AND Year = 1995) ...
Process 54 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION.
Plantador Ren via SQLMonster.com -
12 May 2005 1:17 PM - 4 messages
Hi I´m having this message when i execute this proc : spU_documentos_1 3, 4, '', 'Plano de Projeto', 'Este plano de projeto foi elaborado na fase 1 do projeto para cotação eletrônica.', '2005-03-04 09:10:38', 1.1, 1, 2, 12, ...
Database Maintenance plans log
fatp -
12 May 2005 12:15 PM - 3 messages
I receive every 30 min 5 event into my event viewer application log telling me something like this 18265 : Log backed up: Database: UserDatabases, creation date(time): 2003/05/31(08:14:32), first LSN: 27:167:1, last LSN: 27:167:1, number of dump ...
SQLServer:Locks(_Total)\Lock Requests/sec
SQLCatz -
12 May 2005 9:54 AM - 2 messages
For a certain performance related problem that we are examining, I captured the "SQLServer:Locks(_Total)\Lock Requests/sec" in PerfMon. Got very high values. Is it true that a large number of the requests will be for System related ...
byte manipulation for int
sandiyan -
12 May 2005 9:52 AM - 6 messages
I've got a column that is as type int(length=4). This column is getting changed to smallint. Obviously, some values in the column will not fit into smallint type. I've been told that as part of moving data over, I should ignore top two bytes and carry forward ...
Hiding instances on the n/w (Port 1434)
Pmcg -
12 May 2005 9:32 AM - 2 messages
Hi, I tried to hide an instance of MSSQL2000 SP3 on the n/w by first removing all the enabled protocols using the server network utility which worked fine, i then renabled the TCP/IP protocol and selected hide server which seemed to ...
SP4 reports queries blocking on themselves?
Jonathan Levine -
12 May 2005 8:30 AM - 30 messages
Greetings. I just installed SP4 yesterday. I've noticed that several heavy queries that worked fine in SP3a now have unusual behavior. The queries report that they are terminated as a deadlock victim; however, there aren't any DML operations running on the database at ...
Question...
Skc -
12 May 2005 7:50 AM - 6 messages
We are running SQL 2000 on a Dell PowerEdge server with an Internal Dell PowerVault LTO2 tape drive. We are using Brightstor ArcServe with BAOF and SQL Agent. We have a client who is to give us data.... The data is in a SQLServer 7.0 database. ...
Clustered/Non-clustered indexes column selection
Terence Leung -
12 May 2005 6:51 AM - 4 messages
From what I've read, clustered index is particularly good for returning a set of data, expecially if the result set requires a sort by on those columns. My company is running education services. Let's say our enrollment table ...
Bulk Insert Problem
Kitty -
12 May 2005 6:43 AM - 3 messages
I receive near about 50 text files every month each has near about 1lakh to 3 lakh rows. they come in various formats (few with , delimiters, few with field qualifiers, few with mix and match of both, and few files with fixed ...
Abnormal user connection increased on SQL server
JS -
12 May 2005 6:41 AM - 2 messages
The error which we are facing these days is related to the abnormal performance of SQL server, and sometimes also got the error ‘SQL Run-time error 2147217911(80040e09)’ sometimes on the client ends. As per our detailed observation it is observed that our SQL server database ...
SQL Server 2000 EE on Windows x64
Hans -
12 May 2005 6:28 AM - 3 messages
Hi all, I was wondering if anyone here has got any information on the advantages of running SQL Server 2000 EE on Windows 2003 x64 compared to Windos 2003 32 bit? Are the SQL Server memory limitiations the same as on 32 bit windows or can ...
MSDE (local machine) to process records downloaded from SQL Server 2000, upload when finished
L Mehl -
12 May 2005 5:22 AM - 3 messages
Hello -- If this question is more appropriate for another newsgroup, please tell me. Our application requires the following: - users planning travel or being at location without access to the server (SQLServer 2000) want to be able to review and/or process selected records ...
Database transfer
No One -
12 May 2005 2:17 AM - 8 messages
I needed to move some databases from one SQL server to another (SQL 2000 on both). I did this by doing a back up of the server on one, copy the file across and restore on the other. The data is there and so are the ...
Return a horizontal table for result
John -
12 May 2005 12:48 AM - 12 messages
Has any one had luck writing a query that returns a result as follows: CheckID Pay Amt Deduct Amt Tax Amt 1 Admin 200.00 401k 70.00 FUTA 13.00 ...
pLEASE HELP:URGENT please
nikila -
12 May 2005 12:41 AM - 4 messages
I am new to sql server . I have to write a trigger to insert the data into second table when there is any update in first table. Do I have to execute the trigger every time by some command or it automatically fires when first ...
sql server sp4
Ed -
11 May 2005 10:10 PM - 4 messages
Hi, Is it necessary to install Service Pack4 for SQL Server2000? Ed ...
dbcc completed messages
Koni Kogan -
11 May 2005 9:55 PM - 2 messages
How do you avoid them (from Qa and/or a VB program)? Thanks in advance! KOni. ...
Deleting extended stored procedures in master
Steve -
11 May 2005 9:35 PM - 4 messages
Hello Our Audit group is requiring us to delete many extended stored procedures in the master database. If you google something to that effect you will see the list all over the Net of the specific procedures that are recommended ...
System Log being filled quickly by this event
Lisa -
11 May 2005 8:18 PM - 2 messages
Recently in the last week the below error has been flooding the system event log. Does anyone know the fix for this? Event Type: Warning Event Source: MRxSmb Event Category: None ...
Good Data Modeling Book
Web Developer -
11 May 2005 8:14 PM - 5 messages
I'm looking for a data modeling book for one of the developers on my team. There are tons of them out there, so I'm hoping for a recommendation. Has anyone come across a book that does a particularly good job of teaching the ...
Problem with ODBC connection
Jerry -
11 May 2005 7:50 PM - 1 message
I have a SQL server on my LAN/domain and I also have a VPN tunnel to a network in another state and we have atrust set up between our networks. They are completely different domains. Now on my LAN I have a server that belongs ...
displaying database options
waltmallon@yahoo.com -
11 May 2005 6:04 PM - 4 messages
What tsql command can I use to display what database options are in affect? Such as ansi nulls, ansi warnings, etc. sp_dboption gives me a list, but doesn't tell me their values. Thanks, waltmal***@yahoo.com ...
Logon failure: unknown user name or bad password.
ChrisR -
11 May 2005 5:44 PM - 1 message
sql2k sp3 I am boggled here. This isn't the typical scenario that normally generates this message from what I can tell. I have all the necessary permissions from what I know. 2 boxes. 1. All SQL Services run in the same Domain Administrator accout for both ...
comparing text fields - Second try
helpful sql -
11 May 2005 5:38 PM - 12 messages
Hi all, What is the fastest and best way to compare two text fields(data type TEXT). I just need to know when the values are different. Are there any functions available to do this? Please provide any code if you have it or any links regarding this ...
How to move Distributor to another server
Arsen V. -
11 May 2005 5:33 PM - 2 messages
Hello, I have 10 machines: 1 - publisher (on machine A) 1 - remote distributore (on machine B) 9 - pull subscribers (on machines C1 through C9) I got a new machine D. I would like to move the distributor from machine B to machine D without ...
Issue with restore to new dbname on same server
MarkAurit -
11 May 2005 5:31 PM - 2 messages
I ran this script to backup to restore a backup onto a database with a new name - on the same server. USE master ...
Possible workarounds known bug 472098 for error when passing large text parameter (>64 MB) to stored
Next »
|
|||||||||||||||||||||||
