|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
sp_who2 shows three spids 59
jxstern -
29 Apr 2006 11:00 PM - 9 messages
I have an SP that hangs. The code seems to work fine when run from QA outside of an SP. SP_who2 shows three copies of the same SPID#. 59 RUNNABLE BTHREE\sternj 3S0BATCH001 . ...
SSIS and Users
vbnetdev -
29 Apr 2006 10:49 PM - 3 messages
Ok under the old setup in SQL 2000 customers who host their databases with a provider coudl use DTS to transfer data, perform tasks and such as needed. The information to perform the task was stored on teh server so they could ...
Nesting views?
Tim Greenwood -
29 Apr 2006 3:15 PM - 3 messages
OK say a user creates a view "A".... Now another user comes along and creates a view "B" which joins view "A" plus other tables. Now yet another user creates a view "C" which uses "B".... Supported yes but is this really wise? It really begins to be convoluded ...
SP 1 / My Jobs no longer work
Amos Soma -
29 Apr 2006 11:02 AM - 3 messages
We installed SP 1 yesterday and now none of our Jobs work. The error we're getting is the following: "Unable to start execution of step 1 (reason: The job step contains one or more tokens. For SQL Server 2005 Service Pack 1 or later, all job steps with ...
Indexed View: _hypmv_4
Pieter Coucke -
29 Apr 2006 11:01 AM - 2 messages
Hi, When Tuning my DataBase with the Index tuning Wizard, it proposed me an index view, calles _hypmv_4. I added it, and I saw an enormous perfomance gain. But how does this work exactly? How does SQL Server now that it should use this indexed view when running a ...
Indexed View: _hypmv_4
Pieter Coucke -
29 Apr 2006 11:00 AM - 3 messages
Hi, When Tuning my DataBase with the Index tuning Wizard, it proposed me an index view, calles _hypmv_4. I added it, and I saw an enormous perfomance gain. But how does this work exactly? How does SQL Server now that it should use this indexed view when running a ...
Multiple Filegroups.
Sezgin Rafet -
29 Apr 2006 7:17 AM - 5 messages
Hi Everyone, I added a secondary filegroup to a production database and moved some tables to it from the Primary Filegroup.In the process I changed the database recovery model to Simple and back to Full,backed up the Transaction Log and ...
JOB Scheduling
Agnes -
29 Apr 2006 2:37 AM - 2 messages
I create my first job schedule to remove some unused data at mid-night. As I want to do some modification in that job schedule, I don't know how to retrieve that Job , Please help. and thanks ...
SQL 2005 SP1 - Autogrow problem.
Javier -
29 Apr 2006 1:02 AM - 3 messages
Hi, I am having problems with autogrow after install SP1. I have a big DB (20 GB) and autogrow is set to grow by 100 MB. I found that after SP1, the autogrow changes from 100 MB to (A random big number. ex ...
SQL Server Express and JDBC
RyanS -
28 Apr 2006 10:45 PM - 2 messages
I'm attempting to setup a uPortal instance on a laptop which has SQL Server Express. To build uPortal, I need to know several parameters about the DB Name, DB Version, Driver Name, and Driver Version. The documentation states ...
Move TempDB data/trans From C: to E:
Joe K. -
28 Apr 2006 10:28 PM - 6 messages
I have a SQL Server 2000 database server on Windows 2000 Advanced Server. What is the best way to move the TempDB data and transaction log files from the C: to E: drive? Thank You, ...
CPU usage
David -
28 Apr 2006 9:59 PM - 2 messages
I want to know what is the %CPU used by a process in SQL Server. In other words, I got the CPUTime from the sysprocesses table and the number is say 10,000. How can I relate this CPU time with NT processor percentage? A user called ...
Performance Issue with SQL 2005 and Linked server
Eric -
28 Apr 2006 9:47 PM - 8 messages
Hello, We are migrating an application to a new server Old server: Windows 2000 IIS 5.0 SQL 2000 New server Windows 2003 IIS 6.0 SQL 2005 Even if the new server is much faster, we have some performance issues with ...
SQL Server 2005 Express Edition and SQL Server 2000
Josh -
28 Apr 2006 9:27 PM - 3 messages
I use SQL Server 2000 at my place of business. I need to create a linked server so I can run queries against a DB2 database. I created the ODBC connection and can get at the database tables in Microsoft Access but cannot ...
Unspecified Error in DTS
ChrisR -
28 Apr 2006 6:57 PM - 3 messages
sql2k sp4 Howdy all. All of a sudden, my DTS Package is totally unusable. If I try to run it or design it, I get "unspecified error". I have verified that there is no corruption in both MSDB and Master. Ideas? ...
moving dts package
Johnfli -
28 Apr 2006 6:35 PM - 2 messages
I am moving databases from SQL7.0 to SQL 2003. I have exported teh data and tables from the old one to teh new one. How can I move, or copy the DTS packages? ...
Optimizing Clustered Index Scan
cbrichards -
28 Apr 2006 5:17 PM - 10 messages
I am trying to tune a query that has as its execution output as a Clustered Index Scan. There is a Clustered Index on field [dt], which is a datetime field. The query is structured as such: IF @date < '1/1/1901' ...
IS this true?
Tim Greenwood -
28 Apr 2006 5:05 PM - 26 messages
We've been experiencing some performance degradation recently. We are a small company partnered with a MUCH larger one. Someone from the other company said they had experienced some of what we are seeing and recommended that stored procedures which only return one row of data should use output ...
Database timeout errors - apparently while growing database
GL -
28 Apr 2006 4:13 PM - 4 messages
I am occasionally experiencing timeouts while connecting to a database. Attempts to insert even a small record cause the system to max the disk usage and keep it there. I have experienced the problem on two different servers, with different size ...
How to encrypt MS SQL Server 2000
Michel -
28 Apr 2006 3:37 PM - 2 messages
How could i encrypt a ms sql 2000 database. what is when i do a backup of the db. will i recieve a certificade with the key. Does somebody have some experiences about the best way for encrypting an sql ...
Database corruption problem?
GregC -
28 Apr 2006 3:25 PM - 3 messages
We have a strange problem with an SQL SERVER 2000 database, it doesn't seem like a corruption problem but I can't identify what's happening. I'd appreciate any ideas. On Wednesday we noticed that 85 records in a person table had been ...
SQL 2005 Capabilities question
Richard Yeo -
28 Apr 2006 3:21 PM - 2 messages
In SQL Server 2005 is it possible to drop and create a stored procedure whilst it is in use? If not how do you recommend upgrading stored procedures that are called multiple times every second? Is it possible in SQL Server 2005 to drop an index on the fly on a table ...
sql server profiler filtering question
Pedja -
28 Apr 2006 2:34 PM - 3 messages
Hi, I am trying to catch only table scans on some specific large tables in very active database. I choose scan:started, and tsql:started events, and textdata, objectid columns. I also set the filter on object id for the tables ...
DESIGN FLAWS IN MANAGEMENT STUDIO ????
mike.mcneer@gmail.com -
28 Apr 2006 2:20 PM - 8 messages
Greetings, Please tell me we don't have to live with this annoying thing where if you try to open multiple .sql files it opens a new instance of Management Studio and prompts you to connect to a server?? I JUST want to modify some sql scripts dangitt. ...
Intermittent query slowdowns and corresponding high CPU utilization
McGeeky -
28 Apr 2006 1:55 PM - 6 messages
Hi. We are experiencing an issue on SQL Server that sounds very simlar to the hotifx detailed here: [link] Only trouble is we are running on a single CPU server when the article ...
DTS running on EM but failing as ascheduled job
Shyam Madhavan -
28 Apr 2006 1:34 PM - 2 messages
Hi All, I have local Package DTS which logged in as the user runs Dandy. But when Scheduled gives me this error: MESSAGES: The job failed. Unable to determine if the owner (XXXX\YYYY) of job Copy from 2005 to SQL 2000 Server has server access (reason: ...
Restore History
Piku -
28 Apr 2006 1:33 PM - 5 messages
What is best place to look / check for a database Backup / Restore history, I am mostly interested for RESTORE, like who did it and when ...etc. ...
SQL2000 to 2005
JFB -
28 Apr 2006 1:28 PM - 3 messages
Hi All, I have a SQL2000 box and I would like to start using SQL 2005. Can I restore data from sql2000 in sql2005? If I can, the SQL2005 will be my main server, do I need to change anything ...
Conventional rename mdf techniques failed not sure why
Mike -
28 Apr 2006 12:29 PM - 3 messages
I'm trying to rename my mdf files and I have tried 1. Detach db, rename files and attach from Enterprise Manager. I direct it to the rename MDF file and it lists the original filename then lists the current file location with the old names and two red X's indicating a ...
SQL Server on UNIX/Linux
schw -
28 Apr 2006 11:03 AM - 2 messages
is it available for other than Windows platforms? thanks best regards, schw ...
Identity increament field?
tienlx -
28 Apr 2006 8:37 AM - 3 messages
Hi all, I have a Identity increament column name "ID" (int). Now i have values in that column : +-------------+ In which situation that the value of ID column will be 3 to 99, 103 ?( Or it's values will increase up to MAX INT and never re-use 3-99, 103 ...
permissions for sp_OASetProperty
Meenal Dhody -
28 Apr 2006 7:21 AM - 2 messages
We have a request to be able to execute the following from an application: declare @languageValue varchar(1000) exec sp_OASetProperty @languageValue, 'CharSet', 'Shift-JIS' Currently the developer is unable to because they get an "EXECUTE permission denied on object 'sp_OASetProperty', database 'master', owner 'dbo'." when ...
sub-select with composite key? How better performance? Daring!
Pieter Coucke -
28 Apr 2006 7:15 AM - 6 messages
Hi, I want this query (with a sub-select) to have a better performance. I trimmed it down from 3 minuts and 30 seconds to 9 seconds, by rewriting the query (originally they used a view that consumed a lot, added some indexes ...
Sql Server 2005 2 instances with the same name
Bill Heckle -
28 Apr 2006 6:14 AM - 3 messages
My server is running both sql 2000 and 2005. When 2005 was installed there was some issue -- I didn't do the install so that is all I know. When I looked at the server there was 1 named instance named NEW. I went to an ...
books needed
hidevraj@gmail.com -
28 Apr 2006 5:50 AM - 3 messages
All, For my project, I need to get familiar with sqlserver2005 in a few days.But I do not have any books or links, so please provide any links or books to learn about sqlserver205. Thanks in advance, ...
Error in sql log when restarting SQL server
Meenal Dhody -
28 Apr 2006 4:59 AM - 4 messages
Whenever we restart sql server the following error appears: 2005-12-20 12:34:22.28 server Attempting to initialize Distributed Transaction Coordinator. 2005-12-20 12:34:22.31 server Failed to obtain ...
sql mirroring & front-end web app.
Hammer -
28 Apr 2006 4:41 AM - 5 messages
Hi, I have successfully implemented SQL db mirroring on 2 - Win 2K3 Ent. servers. (haven't implemented witness server yet) I am able to manual failover the required databases. Principal server IP: 192.168.0.1 mirror server IP: 192.168.0.2 ...
How to migrating SQL Database and Security?
TA -
28 Apr 2006 3:57 AM - 4 messages
Hi there, I am planning to migrate SBS 2000 from one domain to another domain with a new server SBS 2003 SP1. This includes migrating SQL database, secuirty and all packages in SQL. Is there a Microsoft KB for this process? or Can someone please point me in ...
Inconsistent Linked Server Execution Plans
person -
28 Apr 2006 3:45 AM - 11 messages
I am witnessing something odd with regard to execution plans and a linked server. I have a restore of a production database in two different environments, one DEV the other QA. This database resides on the linked server in our setup. The other database -- the local database -- has ...
Reference a file name
FJC -
28 Apr 2006 12:35 AM - 3 messages
Hi, How can I reference the ldf or mdf (using the logical names) file of a particular database when I'm in a diferent context, for instance, I've got two databases PG and PG1 and being in PG1 I want to do the following ...
Mirror database, what about logins?
Olav -
27 Apr 2006 11:23 PM - 8 messages
I have setup SQL Server 2005 SP1 with mirror of a database to another server. How am I supposed to duplicate the logins between the two servers and map the logins defined at the server level to the database level? ...
Naming selected tables for ADO.net
jw56578@gmail.com -
27 Apr 2006 11:07 PM - 4 messages
if you do mulitple selects such as select * from table1 select * from table2 Is there a way to desginate the name of the tables (in sql, not ado code) so that an ADO.net dataset will have those names ...
How to specify failover partner name?
Olav -
27 Apr 2006 10:50 PM - 3 messages
I have setup SQL Server 2005 SP1 with database mirroring. I have a client application connecting to the database via ODBC and I define the connection under the System DSN tab in the ODBC Data Source Administrator (launched from Administrative Tools). ...
SQL Server 2005 - 80 compatibility mode
smoss -
27 Apr 2006 9:24 PM - 2 messages
3 Questions about 80 compatibility mode: - Are there any problems associated with staying in 80 compatibility mode after upgrading. - Do we need to run Update Statistics with Full Scan if we upgrade but stay in 80 compatibility mode? - Will some of the following database engine /index features work in 80 ...
primary keys have gotten out of sequence
Timothy Ross -
27 Apr 2006 8:33 PM - 11 messages
In Enterprise Manager, my primary keys used to be all in sequence. After deleting a few pk and adding new ones, they are no longer in sequence. In Enterprise Manager, I would like to be able to view "Return all rows" with the primary keys in numerical order. ...
SQL problem for GURUS
rlueneberg -
27 Apr 2006 8:09 PM - 6 messages
the SQL bellow is going to discard all products that do not have an exact match from the restriction table. I struggling to extend the keyword restriction to item_desc which does not work exactly as an exact match (The keyword can be in different position within the text ...
SQL Server agent job
dundis -
27 Apr 2006 7:54 PM - 4 messages
Hi, I would like to move a SQL server agent job from a prod. server onto a test server to do some research for new enhancements. So, generated the SQL Script and tried to run the sql query on the target test server but ...
Question on Changing Jobs in SQL Server 2000
shub -
27 Apr 2006 7:32 PM - 7 messages
We have a bunch of databases on this SQL Server 2000 and for each database we pretty much have the same kind of job running daily and weekly. We are running out of disk space where we used to normally ...
list of tables without indexes
Dan D. -
27 Apr 2006 7:25 PM - 3 messages
Using SS2000 SP4. I found this code: USE SMCLMS_Dev; GO SELECT* FROM sys.tables WHERE OBJECTPROPERTY(object_id,'IsIndexed') = 0 ORDER BY table_name; GO but when I run it I get "Invalid object name 'sys.tables'." Thanks, ...
Memory question
michaelg via SQLMonster.com -
27 Apr 2006 7:13 PM - 3 messages
Hi, I just started at a new company and have been tasked with reviewing the configurations on some troubled servers. One thing I noticed that seems odd in the sp_configure output is that the min memory per query (1024 MB) is ...
SQL Server Express Advanced and SSIS
vbnetdev -
27 Apr 2006 6:58 PM - 4 messages
Anyone with this set of client tools, are you able to create SSIS packages (and at least save them locally if not to SQL Server) when importing data to a remote database and be able to execute them? ...
SQL 2000 restore
Dave B -
27 Apr 2006 6:28 PM - 2 messages
For some reason, my backup production server / restore to reporting server decided to stop working today. Currently, I am taking a SQL2000 backup and restoring it to 3 servers, 2 are 2005 and one is 2000. All 3 are giving me ...
Measuring index usage
MGeles -
27 Apr 2006 6:16 PM - 4 messages
I'm looking for a way to monitor index usage, over time, on all user tables in a db, in order to determine which ones are getting hit the most and which may not be getting used at all. Any suggestions? ...
Rename of stored proc in EM/Manage Studio does not work as expecte
Byron -
27 Apr 2006 5:52 PM - 2 messages
I normally rename stored procedures through script, so I never noticed this before, but if you use EM (2000) or Server Management Studio (2005) to rename a stored procedure the name changes in the GUI, but the actually name used to ...
datetime default value
Paul -
27 Apr 2006 5:12 PM - 3 messages
Hi I am designing a table with vs.net 2003 and have a column that has a datetime datatype. Just wondering if anyone knows if there is a way to set its' default value to the current system time, like Now(). ...
OLAP Questions
Sanjay -
27 Apr 2006 5:05 PM - 4 messages
Hi As of today we create & modify cubes & dimensions with Analysis Manager tool and nedd OLAP Admin access to do that. We are facing issues with getting OLAP Admin access on our production box Question 1. Is it possible to create & modify cubes & dimensions via scripts like we ...
Output column size limit on query analyzer
Wingman -
27 Apr 2006 5:00 PM - 6 messages
We are using SQL 2K with Sp4. I am doing a Select statement where it contains a column that composes of a concatenation of various strings and many fields. At time, the output of this column will contain a very very long output string that part the output data ...
INSERT not inserting?
pepethecow -
27 Apr 2006 4:33 PM - 5 messages
I have an application that is inserting many rows into a table. Supposedly, the inserts are working. I'm getting back rowsAffected = 1. But when I query the table, the information I supposedly just inserted isn't there. I've printed out the exact queries--and if I run them ...
Underlying table changes affecting View
Wingman -
27 Apr 2006 4:10 PM - 2 messages
We are using SQL 2K with sp4. We have a view using a 'Select * from tableA'. This view is made this way because tableA exists in another database where the calling stored procedure is in a different database. ...
how to close results window in 2005 query analyzer?
Walter Mallon -
27 Apr 2006 3:15 PM - 3 messages
Other than ctr-R, is there a way to close the results window after running a query in 2005's query analyzer? In 2000 there was a "Show results Pane" button. I can't find this button in 2005. ...
SQL Server Optimization
slylos -
27 Apr 2006 2:54 PM - 11 messages
Hey All, We've got Sql Server 2000, with 11 databases storing about 70 gigs of data. Things are moving way slow right now; running queries causes Sql Server to use 1+ GB of RAM and 90%+ CPU time. Anyone have any insight into ...
BACKUP WITH RETAINDAYS
Sorin Sandu -
27 Apr 2006 2:47 PM - 5 messages
How can I delete from a bakup all expired backups. I am using BACKUP WITH RETAINDAYS=5 but all expired backups are still there and the backup file grows very fast. Sorin Sandu ...
2005 SP 1 Install Failure Solution - Unable to install Windows Installer MSP file
vbnetdev -
27 Apr 2006 2:18 PM - 3 messages
This is posted for others who have If this error occurs here is what worked for me. I hope it may work for you but am not sure. In my case I had SQL Express 2005 Installer on my system as well as I run ...
incorrect information in syscolumns
yoni -
27 Apr 2006 2:11 PM - 10 messages
Hi, using sql server 2000 enterprise manager i altered some column's length. however, the information was not updated in syscolumns (neither sp_help shows the right information... it shows the old information before my update). anybody seen this problem before? following comments ...
DTS from 2005 to 2000
Shyam Madhavan -
27 Apr 2006 1:41 PM - 2 messages
Hi All, I am trying to move data (nightly) from a SQL Server 2005 machine to a SQL Server 2000 box. Since the backup/restore solution is not an option. I had only the choice of DTS. So the problem that I am facing is : ...
SQL2000 SP4 BOx has no response
mecn -
27 Apr 2006 1:35 PM - 2 messages
Hi, I have job runs from serverA at night every 5 min to check the server B is up running-------------- osql -b -t 5 -E -SServerB -Q"select count(*) from msdb.dbo.sysobjects" For past 3 days, around 7:16-8:28pm the serverB has had no responses by ...
Scripting database structure
mecn -
27 Apr 2006 1:05 PM - 2 messages
Hi,, IS there a way that I could script the entire database structure (not data) ---tables, views, triggers, indexes, SPs, Logins and user defined functions...... etc.. I know I could get general script for all tables, views..... but not index ...
Allow a user to alter views.
Sezgin Rafet -
27 Apr 2006 11:42 AM - 6 messages
Hi everyone, Is it possible to allow a plain user(not a member of any roles) to alter views created by dbo ? Regards. ...
Open Table Query's Capabilities
Delf -
27 Apr 2006 10:01 AM - 4 messages
I'm using the Client Tools installation. The Open Table Query feature on a table (by right clicking on the table) is rather userful for non-technical people as it is visual and one can easily set up some queries without actually key in the SQL code. ...
SQL 2000 Cluster install steps help
kunalap -
27 Apr 2006 9:45 AM - 2 messages
Hi I have a doubt. I have installed SQL 2000 clusters (active/passive) but have not always installed MS DTC using comclust.exe on each node. Even without MSDTC setup....SQL clusters have operated fine. So, what determines the need for setting up MS DTC on the cluster prior to ...
DTS "Can Not Insert Null Value"
Matt.Mawdsley@gmail.com -
27 Apr 2006 8:58 AM - 3 messages
Hi, I'm using a DTS package to import data from csv files, the destiantion table however has a unique primary key field that can not be null, this data is not in the CSV file. I'm using an ActiveX transformation, and I've used the following code ...
trimming leading spaces from a column
luna -
27 Apr 2006 8:26 AM - 3 messages
is there a quick way to delete leading spaces from a column with an update ? database has a lot of data in a column with leading whitespace cheers mark ...
Performance testing - tips
Per Schjetne -
27 Apr 2006 8:19 AM - 3 messages
I'm suspecting our new Dell 2850/ SQL Server 2005 machine is not performing like it should. What we expericence is ok performance running single long running queries. But running 2-3 long running queries at the same time really makes the whole server very slow. Imagine this: ...
Unable to delete a user created in SQL Server 2000
ilZoro -
27 Apr 2006 8:10 AM - 3 messages
I backed-up a database in SQL Server 2000 and restored it into SQL Server 2005. Strangely, users imported with the database are now 'stuck' - I cannot edit or delete them. Can you help? Thanks, ilZoro. ...
Mirroring
Per Schjetne -
27 Apr 2006 7:45 AM - 4 messages
Is there a way to detect if the principal or mirror is running the database? I want build my own altert system, sending an SMS whenever a automatic failover/failback happens. Per Schjetne ...
Mirroring Failover/Failback
Per Schjetne -
27 Apr 2006 7:42 AM - 8 messages
I have been using Mirroring now for a while and put the system into production now after applying SQL sp 1. We have a setup with a witness, principal and mirror with certificates (the witness is on a webserver in a different domain, so we can't use integrated ...
Error trying to backup database in SQL 2005
Kim Ellis -
27 Apr 2006 5:56 AM - 11 messages
Can someone please tell me what this gibberish is about? Trying to backup database in SQL 2005. Life used to be simple under 2000 :) Thanks. TITLE: Microsoft SQL Server Management Studio ------------------------------ Backup failed for Server 'MENGYUAN6'. (Microsoft.SqlServer.Smo) ...
About Trace Flag 1204 report
Iter -
27 Apr 2006 4:36 AM - 2 messages
Hi Guys, I want to ask a simple question,where can I get Trace Flag 1204 report, from event view or somewhere else? Thanks ...
ALTER TABLE ALTER COLUMN and IDENTITY
Linchi Shea -
27 Apr 2006 3:22 AM - 4 messages
SQL2005 BOL shows the following syntax (ms-help://MS.SQLCC.v9/MS.SQLMobile.v3.en/SSMProg3/html/5719d3e4-14db-4073-bed7-d08f39416a39.htm): ALTER TABLE table_name { [ ALTER COLUMN column_name {DROP DEFAULT for ALTER TABLE (SQL Server Mobile). Is this a BOL bug? I mean IDENTITY is ...
What is wrong with this??
Tim Greenwood -
27 Apr 2006 1:04 AM - 8 messages
ALTER TABLE [dbo].[tblBEventStatus] ALTER COLUMN [lngEventStatusPK] [int] IDENTITY(1,1) NOT NULL; SQL Server says error near IDENTITY.... BOL says you can use IDENTITY in an ALTER statement..... ...
MS ODBC Text File Driver
fuzz_ball -
26 Apr 2006 11:59 PM - 7 messages
I'm working with this little beast for the first time <grrrr>. After figuring out that the creation of the DSN doesn't actually create a valid schema.ini, and you have to manually tweak it to work, well let's ...
Backup to USB drive failing
Duane -
26 Apr 2006 11:33 PM - 4 messages
We have a SQL Server (2000, Win2K) that used to backup to a tape drive. The tape drive was connected through our Domain Controller. DC crashed. As emergency solution, a 256GB external USB drive was attached to the SQL ...
DTS/ SQL Agent question
Blasting Cap -
26 Apr 2006 9:15 PM - 2 messages
We're having to install new SQL servers on a new naming convention. We know the changes we have to make on the applications that hit the SQL boxes. However, we are not sure what DTS or SQL Agent jobs would need to be ...
sqlserver 2005 mirroring
Edi -
26 Apr 2006 9:08 PM - 3 messages
Hi i have installed mirroring and i have two questions 1: princibal server and mirror server in sync. modus. the client have to wait for 2 comit.what is if the mirror server is down ??? 2:if i have two databases on my instance . Can I use the same endpoint ?? ...
!! Something seriously wrong
Tim Greenwood -
26 Apr 2006 8:22 PM - 3 messages
We have one database that is actually quite small, about 1.8GB. Upon moving this db to SQL2K5 we get an error everytime we attempt to view the "Views" folder. The error is: Value cannot be null. Parameter name: context (ObjectExplorer) ...
sql server 2000 windows 2000 AV along with error 17883
Paige -
26 Apr 2006 7:16 PM - 2 messages
This is a sql server 2000 with ms03-031, sp3a on windows 2000 sp4, clustered server. It received an error 17883 with a Access Violation. The database then became corrupt and data was lost. Trying to help find root cause. Can ...
intermittent connectivity issues in virtual server images
ben.usenet.alias -
26 Apr 2006 7:02 PM - 4 messages
Hello, I have a few virtual server images running for development purposes and have been experiencing intermittent connectivity issues for quite a while. First of all my configuration... VPC image 1: Windows Server 2003 Enterprise Edition SP1 Being used as domain controller and DNS server for all other images ...
SQL Backup to Network Drive
mark -
26 Apr 2006 7:02 PM - 2 messages
Hello I'm trying to use SQL backup to run backup to an drive which is connected to the network via Ethernet. I've mapped this drive on SQL box , but everytime I try to set it up as a new Backup Device I'm getting an error saying that ...
Nolock
Rect -
26 Apr 2006 6:24 PM - 2 messages
Will nolock on queries on the concerning tables will reduce blocking in DB ? Assumption- I am ready to do dirty reads as I am just checking counts. ...
Schedule for Backing up logs
Tim Greenwood -
26 Apr 2006 6:16 PM - 5 messages
How does one determine a reasonable interval for backing up transaction logs? For example, we have one small db that is only 1.8GB and the transaction log is consistently around 1GB even after backup. I suppose I'd ...
Can't load dll xpstar.dll
LRWilson -
26 Apr 2006 5:55 PM - 2 messages
Has anyone encountered this error with SQL 2000? It appears to be causing connectivity issues with SRS and other applications which talk to the database. ...
Compare BULK INSERT vs INSERT
Lawrence -
26 Apr 2006 5:53 PM - 4 messages
Hello, I am wondering is the Transaction Log logged differently between BULK INSERT vs INSERT? Performance speaking, which operations is generally faster given the same amout of data inserted. Sincerely, -Lawrence ...
Backing Up Sys Databases
Chris -
26 Apr 2006 5:13 PM - 2 messages
I currently back up the Master and MSDB sys databases, why do some people say to back up Model as well? I though this was a standard non enhanceable database. What are the reprocussions of not backing this database up? ...
Cant connect to SQL server 2000 instance from domain machines
karwalr -
26 Apr 2006 5:10 PM - 3 messages
Hi We currently have installed sql2005 (installed first as default instance) and sql 2000 with a named instance. When developing sites and using connection strings, we can access the sql2000 db fine by using SERVERNAME\INSTANCENAME. However, if we try to connect via enterprise manager from any other ...
SQLServer 2005 XML DataType is (almost) useless!!! (Please correct me if I am wrong)
John -
26 Apr 2006 4:53 PM - 6 messages
The XML Datatype does not support the case-insensitive search makes the XML DataType (almost) useless, if I stored the xml in the XML column, I certainly want to search it, if I could not performance case-insensitive search, why do I need store the data in the XML ...
SAN
Sas -
26 Apr 2006 2:57 PM - 3 messages
Hi, Planning to put a SANs in each of our data centers and have the D:\ and E:\ drives of a sql server replicating to the remote data center. HP guaranties the proper replication of the drives with their asynchronous repliaction. I ...
SQL Server maximum memory
fniles -
26 Apr 2006 2:37 PM - 2 messages
We adjusted the SQL Server maximum memory to be less than 2 gig (the max memory in the machine) and click OK. But, it keeps going back to the maximum memory (to 2 gig). How can our change stick ? Also, after doing this, do we ...
Query Analyzer and Enterprise Manager Admin alternatives
foxj77 -
26 Apr 2006 2:21 PM - 6 messages
Hi There, I'm bit of a newbie to SQL Server and I'm looking for some help and suggestions. I am network engineer and I am currently review all of our software licencing. A lot of the developers have full installations of SQL 2000 (10+) on ...
stored procedure parser
k0mput3r -
26 Apr 2006 1:14 PM - 3 messages
Hi, Is there a program out there or a parser that comes with SQL Server 2000 that can parse a stored procedure or a TSQL statement into a fully qualified version. A parser that would take ...
No backup
gdf1903@hotmail.com -
26 Apr 2006 12:41 PM - 7 messages
Hi, Is there any way of restoring a MSSQL 2000 database if there has been no backup? Possibly from the log files? Thanks. ...
|
|||||||||||||||||||||||