|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
IIS for SQL Server - problem
sp -
8 Oct 2005 11:02 PM - 2 messages
I configured IIS Virtual Directory Management for SQL Server Utility as is described in Books Online, but I receive 404 error. I gave everywhere everyone full access where I can…. But I don’t know where to look for an error… ...
Develop in VS2005 and deployment to SQL 2000
ad -
8 Oct 2005 9:09 PM - 5 messages
I find I can use VS2005 to develop reports of Reporting Service and the datasource of reports is from SQL2000. Can I develop these report to SQL2000 after I developed? ...
Sql Server 2000 and 2005 Coexist?
JJ -
8 Oct 2005 5:18 PM - 3 messages
Hi, Iis it possible on a dev box to have Sql server 2000 and Sql server 2005 running on the same box? If so anything I should note as far as settings? Thanks, JJ ...
retrieving the number of rows o feach table of each DB?
Jéjé -
8 Oct 2005 4:45 PM - 3 messages
Hi, I want to monitor the number of rows of all my databases. any simple way to do this? also, if I can, I want the table size in bytes etc... the result will be stored in a table for historical monitoring and ...
Can errors occur while committing a tx?
Abdullah Kauchali -
8 Oct 2005 12:38 PM - 2 messages
Can an error occur /during/ the process of committing a transaction? BeginTraction(); try { UpdateTable1(); UpdateTable2(); CommitTransaction(); <-- error here??? } catch(Exception e){ RollbackTransaction(); } Also, what are the implications in such a situation where both the ...
Enable/Disable of Toogle
ad -
8 Oct 2005 12:08 PM - 2 messages
I we a matrix in my report, I can set the 'Visibility can be toggled by' to a item. and the toogled ability is enabled. .. Can I set if the group an can be toogled according some custom code? ...
0x800706BE. The remote procedure call failed
Kurlan -
8 Oct 2005 11:35 AM - 3 messages
Hi Champs I am trying to create an "Enterprise edition pool" on the SQL backend, to be used in an LiveCommunication Server -setup, and it fails with an error: "Action failed with error code 0x800706BE. The remote procedure call failed." ...
sql2k5 incompatibility: sp_fallback_MS_sel_fb_svr
Vikram Vamshi -
8 Oct 2005 3:42 AM - 3 messages
We were trying to test if our application would work with sql2k5 When connecting to the database our application now generates the following error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'sp_fallback_MS_sel_fb_svr'. This system proc exists in a sql2k master database but not in sql2k5. ...
deadlock - retrying the transaction
Zeng -
8 Oct 2005 12:17 AM - 19 messages
Hi, The bigger my C# web-application gets, the more places I need to put in the tedious retrying block of code to make sure operations that can run into database deadlocks are re-run (retried) 3-4 times and give up if after that ...
shrinking not really shrinking
Jiho Han -
7 Oct 2005 9:43 PM - 3 messages
I have a 2 gig database which I am cleaning up. After deleting almost all of the data from it, I went to EM and ran Shrink Database. Only it didn't really shrink it. I then ran BACKUP LOG mydb WITH TRUNCATE ONLY ...
SQL for absoloute Beginners?
DJT -
7 Oct 2005 8:10 PM - 4 messages
Does anyone know where there is any info, presentations or videos so that I can explain what SQL 2000/2005 is to my IT trainees? Everything that I find assumes that you are a top-level programmer or DBA. Where is the starting point to this secret society? ...
Help on migrating from SQL7 to SQL2K
SG -
7 Oct 2005 7:00 PM - 4 messages
Hi, We just installed a new server with SQL2k (OS win2k) on it. We have an old SQL7.0 server (OS NT4). It has a few databases, jobs, packages and etc. I like to transfer and convert all the data from SQL 7.0 to the new SQL 2k ...
SQL Replication
Gabe Matteson -
7 Oct 2005 6:56 PM - 5 messages
What is the purpose of setting the primary key to not for replication? thanks. ...
Query times out when executed from 1 server
Alex V -
7 Oct 2005 5:42 PM - 4 messages
I have a weird problem. It all started when one of our clients reported having an error accessing one of our pages. We found that the cause of the error resulted in a timed-out query. When we execute a certain query using Query analyser from our Web ...
Referential integrity constraints on indexed views
Bob -
7 Oct 2005 5:29 PM - 3 messages
Hi I was wondering whether we can create referential integrity constraints on indexed views in SQL Server 2000. We are trying to create a data model and would like to know whether we can enforce constraints on indexed views, otherwise we may have to go for tables. ...
MSSQL Diagram Problem
asantos -
7 Oct 2005 5:14 PM - 2 messages
Microsoft SQLServer Enterprise Manager is not able to show existing diagrams of tables. If I create a new diagram, the tables and relationships are shown ok, but previous diagrams show a blank page. I am migrating from my old computer (where all diagrams are shown ...
How should data files be allocated?
Snake -
7 Oct 2005 5:09 PM - 3 messages
Years ago when I studied database file layout, the prevailing wisdom was to separate data, index, and log files onto separate disks and controller channels if possible. Tempdb and master should be separated from user-databases as well. The "Sql Server 2000 Admin" book from MS Press both ...
Number of Concurrent Queries
Aravind Melatur -
7 Oct 2005 4:42 PM - 2 messages
Hi, I am developing an application that may required up to 68 concurrent connections to the database. I was using MSDE 2000 until now. Since MSDE has been optimized for 8 concurrent queries, I am planning to upgrade to SQL ...
2003
CLM -
7 Oct 2005 4:41 PM - 4 messages
Has Sql Server 2000 had good success with running on Win 2003 Server? ...
Execution plan compilation performance troubles
fourmi -
7 Oct 2005 4:21 PM - 5 messages
Hello all, Could anybody give me hints or links on what is affecting stored procedure execution plan compilation time ? I execute this statement on 2 different machines: EXEC MyProc WITH RECOMPILE On M1 I have 20s for compilation of the execution plan and 1s for proc ...
Astronomical database growth - Please help
Peter -
7 Oct 2005 3:51 PM - 7 messages
Please help! Sorry for the large post but hopefully it gives all the information needed for you experts to help me out. We recently migrated our SQL server databases to SQL Server 2000 SP4 from SQL Server 7.0 SP4 a couple of weeks ago by restoring the SQL 7.0 ...
Default Recovery Model
Rich -
7 Oct 2005 3:34 PM - 12 messages
Hello Group, why does the default install of SQL Server 2000 place the master db in the simple recover model? should I switch to the full model and then I can use trans logs for point in time recover. What is the normal setting for the ...
T-SQL Help
Mike Collins -
7 Oct 2005 2:43 PM - 3 messages
I need to create a report where each row shows information that I will get from four different records. How can I write a select statement that will combine the four rows from the table into one row for the report? ...
Nagios.
MZeeshan -
7 Oct 2005 2:30 PM - 2 messages
We use Nagios for our Unix monitoring and, in one of the meetings, it was also pointed out if we can consider using Nagios for monitoring SQL Server. So far, the information I have gathered from the web esp. Nagios.org is bit ...
Unknown ujser logons
Wingeronside -
7 Oct 2005 2:09 PM - 4 messages
Hi, Sorry if this issue has cme up before, but my searches have been fruitless. I'm using SQL 2000, on SBS 2003, Premium. At the moent it simply runs the sharepoint website, and project website. Since installing Project (or ...
BCP problem - help?
Corey Bunch -
7 Oct 2005 12:56 PM - 2 messages
I'm attempting to run bcp to copy some files into a database and receiving a format file error (below). I'm using someone else's format file that I know already works for them, and I don't know what the ...
Weird RESTORE problem
frankm -
7 Oct 2005 12:33 PM - 11 messages
Windows 2003 Enterprise Clustered (2 node). SQL Server 2000 sp3a, 2 Virtial servers with on SQL Server install on each virtual server. We tried to restore a 7GB database from backed up from one virtual server SQL Server (V1) to another virtual server SQL Server (V2) on the same ...
Splitting database into multiple databases - opinions?
Steve -
7 Oct 2005 11:56 AM - 3 messages
I am designing the database for a client-server enterprise application. The database contains tables which fall into four main categories: - Data Source - Data Results - User Management - Payments/Ledger Performance could potentially be a major issue with this system, with the ...
Database deployment
Gareth Sharp -
7 Oct 2005 8:32 AM - 9 messages
Hi there Firstly, apologies for the multi-post - I could not decide which group would be best to post this to. I have a simple (I think) question. We are about to roll out our first SQL server based application. The ...
SQL Server is freezing
jouj -
7 Oct 2005 6:27 AM - 2 messages
Dear All, I'm Using Windows Server 2000 SP4 SQL Server 2000 - 8.00.760 (database 1GB) HD 33GB ( 24 GB Free space) RAM 1GB The Server is freezing sometimes (frequently these days) especially after long Processes (data Integrity and some night calculations 2-3 Hours), and ...
Prbblems with a Process.
MariaGuzman -
6 Oct 2005 11:00 PM - 4 messages
Hi, i have a store procedure that takes about 20 minutes to execute. Today i want to execute the same process and it takes more than two hours and the process doesn´t finish. I restart the server twice, and the problem persist. ...
Creating New Indexes
Willie Bodger -
6 Oct 2005 10:43 PM - 5 messages
I have a table that I need to update and the update is killing everything else because the column I need to update appears to not be indexed. Now, I thought I could go into the Design Table screen and add an index, but that ...
backups
docsql -
6 Oct 2005 10:20 PM - 8 messages
I am unable to modify/delete a backup job for master database. Error 14274: Cannot add, update or delete a job that originated from MSX server. ??????? Help! ...
Setting up linked server between two Windows authenticated SQL ser
Cordelia -
6 Oct 2005 10:03 PM - 4 messages
How is it done? I created a linked server and took the default login setting with this command, exec sp_addlinkedserver 'GVPRDHD01','SQL Server' I tried exercising the linked server and got the following message, Server: Msg 18452, Level 14, State 1, Line 1 ...
SQL Scripting - Create New Column
Gabe Matteson -
6 Oct 2005 9:57 PM - 3 messages
SQL scripting... is there anyway to create a script that inserts a column into all the USER tables in a database that is a primary key column, doesn't allow nulls and identity is set to yes, the seed is 1 and the increment is 1 ...
Install of Client portion Unsuccessful
Steven Molen -
6 Oct 2005 9:20 PM - 3 messages
I get this error on both machines that I try to install the client tools on. One machine has the full environment installed on it. Here is the log paste that I have. Microsoft SQL Server 2005 CTP Setup beginning at Thu Oct 06 14:14:37 2005 ...
Memory resource Deadlocks
JTC ^..^ -
6 Oct 2005 9:16 PM - 3 messages
Is there such a thing as a Deadlocks that can occur on Memory Resources? ...
T-SQL Question
Mike Collins -
6 Oct 2005 8:36 PM - 2 messages
I need to create a report where each row shows information that I will get from four different records. The select can be ordered where the four records are sequential. There are over 3000 rows in this report. How can I write a ...
Query statement and Date Format
Paul Glickenhaus -
6 Oct 2005 8:28 PM - 10 messages
Hopefully someone can help. I have inherited a database for which I must get some data from. Where I do a select * the date format is returned as for example 2005-10-06 09:42:39.000 but when I go through enterprise manager and right click the table a choose ...
SQL Server 2005 Septermber CTP missing AdventureWorksDW and AS
AIM -
6 Oct 2005 8:21 PM - 7 messages
Hello all, I have installed the SQL Server 2005 September CTP (the DEV). The sample databases AdvenureWorksDW and AdvenureWorksAS are not in the SQLDEV nor SQL Standard install. In the installer, I have drilled down. I have selected both databases. ...
Full Text not working
Francis -
6 Oct 2005 8:17 PM - 4 messages
I cannot get fulltext indexing to work, nor can I get any error messages to indicate whats wrong. Here's what I did (for the pubs database) 1. From the top menu, select Tools, Full Text Indexing. 2. Click next on the opening screen. ...
Auto Grow/Shrink
CLM -
6 Oct 2005 7:09 PM - 9 messages
I've got a half terabyte 2000 server with 100 + databases on it. The larger databases I've taken off of auto shrink. But I am wondering if the 80-90 smaller databases are causing some performance issues with auto shrinks ...
SQL SP4 upgrade.
Marco -
6 Oct 2005 6:16 PM - 2 messages
When i try to upgrade my SQL 2000 SP3 to SP4 i receive a message that tells. " A former installation left some file operation undone. Is necessary to restart the computer before start the installation" (exscuse my translation from Italian) ...
"ORA-00905: missing keyword" when tuning the sql statement using join
jrefactors -
6 Oct 2005 6:10 PM - 3 messages
The following query yields the correct result, but the performance is extremely poor. When I run the explain plan in TOAD, it costs 167560 and it performs the full table scan on (SELECT MAX ...) statement. I try to tune the sql statement using join, but I got the error ...
detecting database access
Paul -
6 Oct 2005 5:48 PM - 7 messages
Hi just wondering if there is an easy way to tell the last time an application accessed a database? I have several databases and believe some may not be in use so would be nice if there was an easy way to tell the last ...
Hyper Threaded Processor Support
Chris Wood -
6 Oct 2005 4:53 PM - 5 messages
Hi, I know that this must have been answered many times before but looking at the supported processors for SQL 2000 or 2005 when it mentions maximum number of processors is this the maximum physical processors? If Standard edition supports 4 processors, is this 2 hyper threaded or 4 hyper threaded ...
Hardening SQL Accounts
cc900630 -
6 Oct 2005 4:35 PM - 4 messages
Hi I have some SQL accounts used by Word Mailmerge I would like to limit what these accounts can do as much as possible. I have granted them SELECT on the appropriate Views and Revoked SELECT on sysobjects but when I log into enterprise manager using one of the ...
"Invalid Object.." error when using Copy SQL Server Objects task
lindseyhansen -
6 Oct 2005 4:00 PM - 3 messages
SQL Server 2000. I have a production database, of which, I want to make a copy. I created a DTS with the Copy SQL Server Obj Task to copy all objects from MyDbName to MyDbName_Test (on the same instance of SQL ...
size of image data type
james -
6 Oct 2005 3:18 PM - 3 messages
Is there a way to find out size occupied by image datatype column in every row for a table? I tried running len() function but it doesn't work for image type column. Sql 2000 sp3a thanks in advance. ...
Need help with Deadlock Message
TJT -
6 Oct 2005 3:18 PM - 4 messages
I am seeing the following deadlock message in the ERRORLOG. I just want to make sure that I understand which SPID is holding which lock. Hoping to get some confirmation. Here's the message with some specifics on the SQL ...
Last login in sql server
Newbie -
6 Oct 2005 3:12 PM - 2 messages
Hello, Is there any way to tell when a user last logged into sql server/system without auditing set? Are there any system tables or sp that will give me that information? Thanks. ...
SQL Index
Sorcerer -
6 Oct 2005 2:08 PM - 2 messages
Hello, i would like to know what is more performant for sql server: a) table with all index not grouped (clustered) (so data is stored in heap) b) one primary index as clustered index thanks for answer. ...
How to optimize "Inserted Scan" in trigger code
Ryan -
6 Oct 2005 1:43 PM - 5 messages
Greetings, We're pulling values from a the "inserted" table that is created in an insert trigger. When we do an insert and view the execution plan in Query Analyzer, the "Inserted Scan" accounts for 98% of the entire ...
Ghost Views
Bart Steur -
6 Oct 2005 1:27 PM - 6 messages
Hi, I'm still trying to copy a SQL server database from one server to another, but now something strange happens. A view is created on the target server that doesn't exist on the source server. It did exists on the source server months ago, but I deleted ...
creating view as a parameter query
maxzsim -
6 Oct 2005 1:11 PM - 2 messages
Hi, I created a view in EM and when i right-click to go to the query designer it allows me to set some parameter but i seem not able to save this as part of a view ? how can i do that or is there other alternatives ? ...
Backup to NULL
CarloVino -
6 Oct 2005 12:53 PM - 3 messages
Hi, I have a database that was left with recovery set to full and receving a lot of updates. Log file has become huge but there were no transaction log backups being done. Until I needed to trim the transaction log file now ...
SQL MSDE instance access question (revised)
Greg -
6 Oct 2005 12:49 PM - 2 messages
I have a SQL MSDE instance running on a PC. Keep in mind that I do not have SQL Server installed. I installed SQL Enterprise Manager on the PC so I can manage the database. "SQL Enterprise Manager" and the SQL MSDE instance are ...
Copy Permissions
Bart Steur -
6 Oct 2005 12:07 PM - 2 messages
Hi, I've copied tables and views from one SQL Server to another, but the permissions for each user/role are not copied. How come. Thanks, B. ...
SQL Server statistics not updating.
fnguy -
6 Oct 2005 12:06 PM - 5 messages
I've got a procedure (SQL Magazine article by Umachandar Jayachandran) which tells me when the statistics were last updated on my tables and indexes. Some, however, have never had them created. Can someone tell me why? ...
Best Practices for Reducing Transaction Log Sizes?
theonlyrashid -
6 Oct 2005 12:05 PM - 2 messages
Hi All, I have a bunch of SQL servers that have a high volume of Bulk Inserts happening every day (Millions of records per insert) The most heavily used server has DBs in Simple Recovery Mode. However both for the database and log files which are set to autogrow 10%, I am ...
Cascading Updates / Delete Problem
Howard Carr -
6 Oct 2005 11:49 AM - 5 messages
I have 3 tables set up in the typical customer - order - order item setup. I have cascading updates & deletes on the customer and order tables. Primary & secondary keys are correct. When I delete, or update the customer table key field, it takes about 60 ...
err 823
janosikos -
6 Oct 2005 10:52 AM - 3 messages
hello, I have problem with this err 823. Today the Win2003 server restarted and when get up, the database "mydb" has no start. when I want to attach I get err 823. I check the disk and was ok, I copy files of database to another ...
SQL Server Service Manager does not show all services
NickN -
6 Oct 2005 10:47 AM - 2 messages
I have installed SQL2000 with Analysis on a W2k3SP1 machine and upgraded SQL & Analysis to SP4. I installed this under the local admin account. I then realized I wanted this box on our domain & so added the machine to our W2K3 ...
Copy Diagrams from One SQL Server to another
Bart Steur -
6 Oct 2005 10:39 AM - 3 messages
Hi, How can you copy diagrams from one SQL Server to another. Thanks. B. ...
MDF keeps growing, but has plenty of free space
hplu -
6 Oct 2005 9:29 AM - 5 messages
Observations (SQL2k SP3a active/passive cluster) -mdf allocated 28 749,56 Mb a month ago -the relationship between used and free space was 27 269,56 Mb and 1 480,00 Mb (94,85 % and 5,15 %) -despite of having nearly 1,5 Gb free space, the file has grown 6 times 50 ...
Foreign key implementation.
SQLCatz -
6 Oct 2005 9:20 AM - 6 messages
[Foreign key implementation] We have [vehicles] (master) and [inventory] (transaction) tables. A FK relationship exists between the two tables based on the vehicle_id. I want to know exactly what happens (behind the scenes) when (a) A new record is inserted into the [inventory] table with an existing ...
DBA's Job
Joel -
6 Oct 2005 9:18 AM - 5 messages
Hi! I just had a discussion with my boss and he thinks that a DBA (see bellow) should not have access to the server room, he thinks also that all Service packs and patches on the MS SQL 2000 application side should be done ...
Help: SQL Server 2000 failed to restart after NT Server reboot
pli@umn.edu -
6 Oct 2005 3:22 AM - 5 messages
Hi, We have a NT Server that's set to reboot every weekend. SQL server 2000 and SQL Server Agent were set to auto-restart after reboot. It's been working fine for a long time. But several weeks ago,both SQL server and SQL server agent didn't ...
Truncating useless log files
Nestor -
6 Oct 2005 2:44 AM - 4 messages
I'm currently facing a problem with my SQL2k server. I have a transaction log file that is closed to 40G in size and as far as the database is concerned, there is no need for any of the transactions to be logged this ...
New user in SQLServer 2000
Jason Huang -
6 Oct 2005 2:39 AM - 5 messages
Hi, I just created a new user MyUser in my SQLServer 2000. MyUser have the right of creating table, views, ..., etc in MyDataBase. However when I logon the SQL Query Analyzer using the MyUser account, I tried a select command to a table MyTable, the message showed me I have no ...
SQL Restore options....
Larry Smith -
6 Oct 2005 2:17 AM - 5 messages
I am currently writing the steps to follow to restore the production databases in the event of disaster recovery. I have listed the following options for recovery depending upon the level of damage. 1. Rebuilding the new server and installation of SQL Server and the ...
sa password after Rebuildm.exe run... ??
Larry Smith -
6 Oct 2005 1:49 AM - 3 messages
After rebuilding the corrupted SQL Server instance (using Rebuildm.exe) I am not able to connect to the SQL Server using sa and password. I connected through the mixed mode and later changed the sa password. What is the password for user id sa after SQL Server rebuild. SQL 2K. ...
How to reduce the data space allocated ?
kelvinweb -
6 Oct 2005 12:59 AM - 2 messages
Hi All, I don't know how to change data space allocated ? My SQL data have 10GB, but the "space allocated" was allocated 50GB. The usage of data storage is 79%. I want to restore 20GB space from the "space allocated". How to do that ? ...
full text search in sql server
jason -
5 Oct 2005 10:32 PM - 2 messages
looks like sharepoint requires i install this. i don't have much experience with full text search...anything i should watch out for? e.g. will is slow down my system as is indexes all the existing databases or something? ...
Urgent :-->Link server issue with FoxPro driver
Nik -
5 Oct 2005 9:04 PM - 3 messages
Hi All Gurus I am trying to import data from FoxPro Files. i get the files in.dbf format. now when i created a link server with that file, and tryed to import i keep on getting the below error. ...
Non-ANSI Outer Join in MSSQL2K5
bpdee -
5 Oct 2005 7:03 PM - 2 messages
Hi, When we ran upgrade advisor for 2005 against our existing database, we received the following error message. The query uses non-ANSI outer join operators ("*="or "=*"). to run this query without modification, please set the compatiblity level for current ...
SA password change
Bryan.S.Walker -
5 Oct 2005 6:31 PM - 3 messages
I have several SQL2K DB's and a few of them use SQL Server Authentication the others use Windows Authentication. My question is what can I expect if the SA password is changed other than the obvious SQL registration needing the new ...
Memory usage
natasa -
5 Oct 2005 6:19 PM - 4 messages
Why the memory usage in task manager shows significant difference before and after the restart of SQL Server service ? Is that due to the memory leak ? I am running SQL Server 2000 sp3a Thanks very much, natasa ...
dbTrace to find Index Non-Use - How To??
Chris -
5 Oct 2005 6:05 PM - 7 messages
I read somewhere or heard you can trace for activity on table indexes to ultimately find where indexes are NOT being used when users perform searches... Any idea how to set this up? I don't see events related to indexes... ...
PerfMon for Procedure Cache
Chris -
5 Oct 2005 6:01 PM - 5 messages
What is the PerfMon counter to use when analyzing SQL Procedure Cache? TIA, Chris ...
How many databases can i have in sql server 2000?
Carlos López. -
5 Oct 2005 5:46 PM - 7 messages
Hi, my name's Carlos and i have a question... I need to know if there is a limit in the number of databases that i an have in sql server 2000 and if there is a difference in sql server 2005. ...
memory bugs ? -- in SQL 2000 EE SP4 with hotfix 8.00.2040
Ziggy -
5 Oct 2005 5:38 PM - 3 messages
I recently migrated my SQL Server to a new box with the configuration lbelow:
----------------------------------------------------------------------------------------------- HP ProLiant DL380 G4 with 5GB RAM Windows Server 2003 EE -- SP1 Build 3790 SQL2K EE -- SP4 with hotfix in KB899761 (8.00.2040) ...
It IS Toy was: execute multiple queries over a single connection
Jack -
5 Oct 2005 4:29 PM - 3 messages
Well it is this BizTalk Orchestration [link] BTW, it is PowerToys in their own words ;) ----- Original Message ----- Newsgroups: microsoft.public.sqlserver.server Sent: Friday, September 30, 2005 5:51 PM Subject: Re: execute multiple queries over a single connection ...
Failed to generate SQL script
Kathy -
5 Oct 2005 4:23 PM - 3 messages
Hi, there, I received the following message while trying to generate a sql script on a table: [SQL-DMO] CreateFile error on ServerName.DbName.DP1 How to fix this problem? Thanks. ...
Fw: execute multiple queries over a single connection
Jack -
5 Oct 2005 4:21 PM - 2 messages
Well it is this BizTalk Orchestration [link] BTW, it is PowerToys in their own words ;) ----- Original Message ----- Newsgroups: microsoft.public.sqlserver.server Sent: Friday, September 30, 2005 5:51 PM Subject: Re: execute multiple queries over a single connection ...
access SQL instance issue
Greg -
5 Oct 2005 3:47 PM - 8 messages
I have a MSDE instance running on a server. I am able to start the services for the engine. But when I try to access the instance through "SQL Enterprise Manager" I get an error message. "[server name] - SQL Server does not exist or access is denied." ...
SQL Mail and Office 2000
Scott McNair -
5 Oct 2005 3:45 PM - 2 messages
Hi, I'm trying to set up SQL Mail. I've gotten it to work, by sending the following command from Query Analyzer: xp_sendmail 'my@email.address', 'Hello World' Unfortunately, the email goes to the inbox (!) of the Outlook client. If ...
transaction log monitoring
renhai -
5 Oct 2005 3:38 PM - 3 messages
Does anybody know if there is a script monitoring transaction on the server for all databases within one instance, if one of them grows beyond certain size, will do backup transaction log first, then shrink to some fixed size. ...
Unable to Shutdown Sql Server
Vaibhav -
5 Oct 2005 3:33 PM - 3 messages
I am trying to stop a SQL Server 2000 running on Windows2000 server. The SQL agent is not running and am not able to start it. I have tried to STOP sql server using all possible options --From Enterprise manager ...
Recovering data from truncated table.
Enkidu -
5 Oct 2005 3:31 PM - 4 messages
I have accidentally truncated a table, and would like to get the data back. Here are the parameters: 1. The database is using the full recovery model 2. A full backup has never been done. 3. A transaction log backup has never been done. ...
transaction log rotate on sql server 2000 ?
Thrax -
5 Oct 2005 3:07 PM - 2 messages
how we can do log rotate any idea ? ...
Record Count in User Tables
Robert R via SQLMonster.com -
5 Oct 2005 2:56 PM - 4 messages
I am attempting to write a sql statement with the goal of getting a record count for each user table in a database, in the format of two columns, Table_Name and Rec_Count. This is what I have written: select so.name as 'Table_Name', ...
losing data from tables
Bertil Morefalt -
5 Oct 2005 2:36 PM - 9 messages
Hi! Is there any known problem with MSSQL 7.0 losing data from tables? I have an application that is used by 150 seperate customer and each customer have about 10 users. The customers have theirs database at a server administrated by me. The application access its database through ...
Backup transaction logs when the database is damaged.
Felix -
5 Oct 2005 2:33 PM - 10 messages
Hi, Due to a disk failure, I lost my .mdf file of a database. Of course I have a backup, of the database and transactionlogs from last night, but I want to restore untill the time of failure. So I tried to follow the procedure ...
SQL Server domain change
smitto -
5 Oct 2005 2:31 PM - 3 messages
I want to move my SQL server from one domain to another. The catch is I do not want to reinstall SQL or have any down time. How can I do this and not have to reinstall SQL server in any way and have minimal down ...
SQL 2005 Upgrade questions
LC -
5 Oct 2005 2:30 PM - 3 messages
Since I can't get to the 2005 Newsgroups, I thought I'd post the questions here. When upgrading a server from sql 2000 to 2005 and the server acts as "Server A" in a log shipping set up, do I have to upgrade "Server B"? I read the ...
Error : insufficient system memory
LSolve -
5 Oct 2005 2:25 PM - 2 messages
Hi, We ran our application on Windows 2000 with SQL 2000 SP3a, and had no issues. As soon as we installed the Database on Windows 2003 we are getting the error saying that there is insufficient system memory. We get this at ...
concatnate multiple results into one field
Grant Merwitz -
5 Oct 2005 1:51 PM - 3 messages
Hi I am trying to query a table and return the results all in one field. My table basicly looks like this: tblBody: ID Body 1 This is body 1 ...
SQL Server 2000 Enterprise Manager on SP1 cannot browse domain
RK Street -
5 Oct 2005 1:45 PM - 3 messages
I see an error message from SQL Enterprise Manager 'Could not find domain controller for this domain'. This error is generated from the add user part of SQL Enterprise Manager whilst trying to browse the parent domain for groups and users. ...
Howto shrink transactionlog?
Floris van Haaster -
5 Oct 2005 1:38 PM - 4 messages
Hi, We have a database with an mdf of 40 mb... and a ldf of 20 GB! How can i shrink the ldf without losing data etc??? Best regards Floris ...
|
|||||||||||||||||||||||