|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
A few compilations/sec
Hassan -
4 Feb 2006 9:24 PM - 5 messages
Im seeing an average of 4-5 compilations/sec with max at 60s and 70s at times. But the recompilations/sec could average around 0 or 1.. How can i find out what sprocs are triggering the compiles ?And why would ...
Database Name
George Schneider -
4 Feb 2006 8:59 PM - 7 messages
Can you have Databse names that contain spaces such as Intanet Content Databse? Will this cause any issues in SQL 2000? ...
SQL Server 7.0 to SQl Server 2005
Srikanth -
4 Feb 2006 8:22 PM - 2 messages
We just upgraded SQL Server 7.0 databases to 2005. Backed up 7.0 database and restored in 2005 Server. when we migrating the data from new sql server 2005 database(that is just converted) to spred sheet we are getiing an error messages ...
SQL Server 7.0 to 2005
Srikanth -
4 Feb 2006 8:06 PM - 2 messages
We just migrated SQL Servver 7.0 tables to SQL Server 2005. When we try to export the data of one table to spred sheet we are getting these error messages "can not convert nicode and nonunicode string datatypes. I verified the sort order in 7.0 is 52 ...
Linked server connection to SQL Server 2005
KTN -
4 Feb 2006 5:57 PM - 3 messages
I have an error message of connecting to a SQL Server 2005 from SQL Server 7.0. I tried to set up a linked server connection from SQL Server 2000 and it works fine. It not working on SQL Server 7.0. Is there a restriction of ...
debug via Enterprise Manager
Dariusz Tomon -
4 Feb 2006 5:24 PM - 2 messages
Hi I wonder if there is a trick I can use to debug what was changed in my database (mssql2000). The idea maybe sound stupid but my boss have got old console application which is doing some changes in database (only in data in tables rather:). I ...
Deadlock Issue - Cannot pinpoint resource causing contention
John -
4 Feb 2006 2:19 PM - 4 messages
All, Have a deadlock issue - see 1204 trace info below. After reviewing BOL I cannot ascertain the exact resource (table, page, index, etc) that is causing the deadlock. I believe it might be a row in a table (ie - RID: 2:1:81:0 and RID: 2:1:81:1) but I am suspicious about this ...
SSIS Fails on Create Package (2005)
Alex Clark -
4 Feb 2006 1:54 PM - 5 messages
Hi, I have SQL 2000 and SQL 2005 both installed on the same machine. I'm trying to migrate a SQL2K database to my SQL2005 server using the Copy Database Wizard. Every time, it fails on the Create Package step with a message that ...
Last iserted ID - MsQL
Tom -
4 Feb 2006 1:41 PM - 5 messages
Is there any solution? Do you know some and would like to share? Please Tom ...
Renaming warm standby server to assume role of primary.
vic -
4 Feb 2006 1:40 PM - 3 messages
I've been shipping logs to a warm standby server and now wish to switch to this server in order to perform maintenance on the primary server. (Both are running SQL Server 2000 Standard Edition). I intend to take the primary ...
SQL Server hangs when Server reboots
VM -
4 Feb 2006 11:36 AM - 5 messages
Hi All, I am having this strange behaviour on couple of our database servers. Our system crashed and it got rebooted, but SQLServer hangs forever and its status of service is always "Starting". After seeing this we try to reboot ...
Isolation levels and SELECT's (even when using SERIALIZABLE!)
JBilger -
3 Feb 2006 11:54 PM - 4 messages
I thought that it would be interesting to point out some very subtle issues that can occur when using SELECT's inside a transaction that also includes INSERTS/UPDATES or DELETES.). The issues really arise when concurrency occurs (ie many users trying to execute this ...
question about using various DBs
sklett -
3 Feb 2006 11:31 PM - 5 messages
Hi, I'm designing our suite of new applications (sigh) and we're going to be storing all the data in SqlServer 2005. I'm hardly a "DBA", I have used access in the past, but never designed a full system. The issue I'm hung up ...
SQL jobs
mecn -
3 Feb 2006 9:48 PM - 4 messages
hi, Can I create a job like this in sql 2k? exec EVO_SP_CUSTReindex go SP_updatestats go Does the second step will run? Thnaks ...
Urgent - Slow join across SQL Linked Server to InterSystems Cache
steven -
3 Feb 2006 9:12 PM - 3 messages
Hi Everyone, I am a newbie to this discussion forum. If I'm bending/breaking any of the rules, please let me know. I need some major help with a linked server I setup. I have a cache database that we can only access through ODBC (no mumps). I have a SQL ...
Table Hierarchy is SQL Server 2000
Ganesh Muthuvelu -
3 Feb 2006 7:51 PM - 2 messages
Hello, If in a database, "table3" depends on "table2" and "table2" depends on "table1" - how would I write a query (on the system tables) which will take "table3" as a parameter and return me this result as below in a hierarchy? ...
Rowsize exceeded error, but rows already exist that exceed the size..?
Nate -
3 Feb 2006 7:06 PM - 4 messages
Hi All, I am trying to add a new table and foreign key relationship to an existing SQL Server 7.0 database. When I try to save in EM, I get a rowsize exceeded error... [Unable to create relationship 'FK_existingTable1_newTable1'. ...
SQL 2000 Discontinued?
Dragon -
3 Feb 2006 6:59 PM - 3 messages
Hi, I heard that SQL 2000 Server has been discontinued. Is this true? If yes, any official advisories on the web? Thank you. ...
Search tool for SQL
BA -
3 Feb 2006 6:32 PM - 6 messages
There are a few people at my company that are not familiar with SQL, but it would be benificial if they were able to search for text within a database and report on tables. Is there a freeware tool out there that will connect ...
unexpected log growth during bulk inserts
me -
3 Feb 2006 6:30 PM - 3 messages
Hi, We're performing bulk inserts into a database with the bulk_logged recover model and seeing the log file grow by 3x the size of the data file as a result of the bulk insert. This is not expected at all. ...
DTSRUN.exe Fails to Initialize
lutzdw -
3 Feb 2006 5:21 PM - 3 messages
I have been seeing these intermittently in our event logs... Event Type: Information Event Source: Application Popup Event Category: None Event ID: 26 ...
cursors
Diane -
3 Feb 2006 5:09 PM - 3 messages
I am not sure if this is a stupid question, but here goes ... What does "improper use of cursors" mean? I mean, I know what a cursor is ... i just don't understand what its relevance is to SQL ... I would be grateful for any ...
Restrictions x64 SQL?
Michael Roedeske -
3 Feb 2006 4:16 PM - 2 messages
Hello together, some months ago, I saw a website stating the restrictions of the x64 SQL implementations. Now I need them for a decision, but cant find them anymore. Can someone help me out? Thanks, Michael ...
TEMPDB is growing
Ali Grey -
3 Feb 2006 3:56 PM - 3 messages
Hi, We have a fairly large SQL Server installation and we have noticed recenlty that the TEBMPDB is growing. Can someone tell me why this would be the case? What makes TEMPDB grow? We are using SQL Server 2000. Yours ...
Tunning SQLServer
The One -
3 Feb 2006 3:54 PM - 3 messages
Hi All, are there any good articles on tunning SQLServer 2000. I am new to SQLServer DBA work, but I have a lot of DBA experience with Oracle and others. TIA. John The One ...
Problem with Collation on SQL 2000
robin9876 -
3 Feb 2006 3:34 PM - 5 messages
On a live SQL Server 2000 in the last week I have noticed a problem with collation with the Model and tempdb both changing from 'Latin1_General_CI_AS' to 'SQL_Latin1_General_CP1_CI_AS'. I am not aware of anybody changing these settings. Do the any of the ...
identifing what DB I've got
gerryR -
3 Feb 2006 3:27 PM - 3 messages
Hi all apologies for the question but we run ePO (anti virus management software) and are moving everything to a new server so I need to back up the ePO database and import it to the new server. Problem I'm having is identifing ...
Log restore : There are no back up files in the set
bluefish -
3 Feb 2006 3:14 PM - 5 messages
Hi, I am fairly new to the log shipping, and trouble shooting our log shipping operation. We are using SQL Lite to back up, and some log backups are visible, but fail to apply with the following message. There are no back up files in the set, check for cancelled backup operations. ...
Schema permissions doubt (SQL Server 2005)
Alex -
3 Feb 2006 2:48 PM - 8 messages
Hi everyone, Maybe I have a very simple question ... I have a requirement that is very apropriate to use schemas. I understand that one of the advantages is to simplify the permission management and that I could assign a kind of 'dbo' permission inside a ...
SQL2K Backup
Mica Cooper -
3 Feb 2006 2:46 PM - 5 messages
Hi, I set up several backups in individual databases to back up on a weekly basis. Later, I set up a maintenance plan to back up all the databases nightly. I am now trying to find where I can delete the weekly backup ...
Call Stored Procedure AS400 From SQL Server
Portekoi -
3 Feb 2006 2:02 PM - 3 messages
Hi, I have SQL Server 7 with a link server. When i try to execute a SP from SQL Server, i have this error : [ OLE/DB provider returned message: [ IBM][Pilote ODBC iSeries Access][DB2 UDB]SQL0107 - "pack14rexe" is too long. 10 characters ...
slow triggers with lots of rows?
sethpurcell -
3 Feb 2006 1:52 PM - 7 messages
Hi there - I'm experiencing slow inserts on tables with AFTER INSERT triggers on them. I think it's because I'm joining to the [inserted] table to determine which rows in the trigger table were just inserted, and there ...
requete SQL select d'une SP
Ch. -
3 Feb 2006 1:03 PM - 3 messages
Comment faire ce genre de requete ? select top(10) T.* from ( exec SEL_MODELES 767 ) T WHERE T.ID > 50 ...
Enterprise manager error in SQL 2000
Rowland Costin -
3 Feb 2006 12:56 PM - 5 messages
Hi Hope someone can help me as I am having major problems. I have seen this before but none of the usual fixes seem to work. Problem. Had a serious crash on my Win XP Pro SP2 PC causing a permanent reboot ...
how to specify sender when using xp_sendmail
foru123 -
3 Feb 2006 12:24 PM - 2 messages
When execute xp_sendmail as below: EXEC xp_sendmail @recipients = 'yam***@yahoo.com' The recipient will see the mail sent from sql server. Is there a way to specify my email address when execute xp_sendmail so that the recipient will see the email address sent from me not from sql server? ...
2 questions
Rob -
3 Feb 2006 11:20 AM - 2 messages
Hi... two questions: 1. When adding an additional data and/or log file, does SQL Server accept these changes dynamically or would one have to restart SQL services for the changes to take effect? 2. When using the BULK INSERT command with the BATCHSIZE option, if the task ...
Multiple Active Result Sets (MARS)
Griff -
3 Feb 2006 10:22 AM - 15 messages
Two questions relating to this: 1 - Do I require SQL Server 2005 or can this work with SQL Server 2000? 2 - My ASP.NET book says that I require MDAC 9.0. My registry setting says that I'm using 2.8 but I can't find where I can download an update from. ...
Is it any functions similar to "START WITH" and "CONNECT BY" in MS SQL?
delolwai -
3 Feb 2006 10:05 AM - 5 messages
Hi all, I am looking for some functions which are used as "Start with" and "Connect By" in Oracle. Please help! Thx a lot. Regards, Thomas ...
SQL query..
ch.funke@googlemail.com -
3 Feb 2006 8:24 AM - 2 messages
Hello, I have a table with text-items in different languages. There are columns TextID, TextItem and LanguageID (and one more ID with primary key). sample: TextID says "I am at home" in 10 languages, each with it's own ...
change instance name?
wcccj -
3 Feb 2006 6:07 AM - 4 messages
Is it easy to rename an instance, or change an instance to default instance? Basically I have an SQL 2000 Standard and MSDE installed on same machine, and I would like to swap around their instances. Thanks cj ...
Native error 11 (Connecting via ADO)
Gaspar -
3 Feb 2006 1:35 AM - 2 messages
What is SQL native error 11? I can't find info in BOL. Thanks. ...
Deadlock problem
Frank Rizzo -
3 Feb 2006 12:49 AM - 2 messages
Hello, I am battling various deadlocks on our system and have the trace flag 1204 turned on so that I get information on what was involved in the deadlock. Today, however, I saw something that I've never seen before ...
How the hell do you install SQL Server Management Studio for 2k5
Chris -
2 Feb 2006 11:20 PM - 4 messages
I have downloaded the full version standard SQL 2k5 server DVD from MSDN. I have installed it. I can find no what possible to get it to install the SQL Server Management Studio. I have googled this and still haven't found the answer. I can't believe it ...
Logs
hershel -
2 Feb 2006 10:56 PM - 2 messages
Hi I have a database In SQL server and I want to keep a log of all the activity’s that that the end user did I want to know who did and what he did and when he did what is the bet way to keep track on that. In my previews ...
Backup and Restore
LaEsmeralda -
2 Feb 2006 10:26 PM - 3 messages
I need to backup 10 GB of data on the west coast and send over a dedicated T1 to restore on the east coast nightly. What is the best method? Thanks. LaEsmeralda ...
Deadlocks & Transaction Isolation Level
Amos Soma -
2 Feb 2006 10:09 PM - 3 messages
If I understand correctly, when using a Read Committed isolation level, the most common reason for a deadlock is because two processes update a set of tables in different order. However, it seems that when using a Repeatable Read isolation level, the odds of a deadlock increase significantly. ...
Can I trap or log FATAL ERROR in a stored procedure?
Allan -
2 Feb 2006 9:14 PM - 4 messages
Hi, We have a stored procedure (sp1) calling another stored procedure (sp2). Sp2 contains an insert statement following by a standard error checking using @@ERROR (i.e. if @@ERROR <> 0, rollback...). However, when the insert statement encounters a FATAL ERROR, the whole stored procedure crashed and ...
performance issue....help!!!!
Tim Harvey -
2 Feb 2006 8:07 PM - 5 messages
When I run a stored procedure on database (A) which is the same schema as database(B) but with different data. The procedure takes painfully longer that if I ran it on B which has more data. Does anyone have an idea as to ...
error handling flow
arthur -
2 Feb 2006 7:51 PM - 3 messages
i've got a stored procedure (a) that calls another stored procedure (b). inside b i become a deadlock victim and i die. how can i "catch" this in a? using if @@error <> 0 in a doesn't seem to work. also, i'm ...
Sql service pack 4. ( Very Slow...............)
Jazzman -
2 Feb 2006 7:09 PM - 3 messages
Strange situation: Server1: has SP3 and everything is running fine. I have a third party application that access this server and everything is moving fast. Server2: Much better Server. Top of the line. Has SP4 installed. I moved a few database for the third party application thinking that since ...
SQL backup to disk across the network failure
DB -
2 Feb 2006 5:46 PM - 4 messages
Firstly I am not a DBA. I am a systems guy trying to figure out why SQL backups to disk across the network are failing. The errors posted on the source server are attached below. The problem is DEFINITELY NOT the network. We are absolutely 100% sure that ...
SQL Server 2000 crash and error
spoons -
2 Feb 2006 5:40 PM - 2 messages
SQL Server went down without any information in the log. When it came back up, I was not able to connect using windows authentication. Instead, I have to use SQL authentication. I have gone though the recommendations made by ...
Alert Response Execute Job
Thom -
2 Feb 2006 5:37 PM - 2 messages
I would like to have an alert execute a job as a response, but I also need to have the error text passed into the job. Is this possible or is there another way? ...
Restoring Files and Filesgroups
spoons -
2 Feb 2006 4:41 PM - 2 messages
I have a database with with two filegroups - the primary and one other. Each filegroup has its own data file. I want to restore the database to a different database server but restore only the primary filegroup. ...
Logshipping out of sync
megabyte -
2 Feb 2006 4:40 PM - 4 messages
Every once in a while, my logshipping gets out of sync, the backup server cannot restore. I found out that each time this happens, it is because on the primary server about 17 tlog files get deleted, rather than the usual 1 ...
Performance and data structure question
ibiza -
2 Feb 2006 4:36 PM - 3 messages
Hi SQL gurus, I have a table structure question. I will have a table 'Models' that has one to many 'incomes' and one to many 'costs'. These 2 entities have exactly the same structure, which is 7 smallmoney and a name. Is ...
how to: stored procedure with dynamic sql??
lai3288 -
2 Feb 2006 4:33 PM - 2 messages
will it be possible wirte a stored procedure with 2 input parameters: sourceDB, destinationDB include sql statement , insert into @destinationDB.dbo.tableA select from @sourceDB.dbo.tableA?? Regards, Jackie ...
Enterprise Manager Problem
neeju -
2 Feb 2006 4:18 PM - 2 messages
Suddenly one of my user started seeing one problem.. Whenever he tries to connect to database and see tables through enterprise manager. Gets error as shown below. "An unexpected error happened during this operation. [MS Design Tools] - You might not have permission to perform this ...
difference between sql2k and sql2005
dk -
2 Feb 2006 3:29 PM - 4 messages
is there a good article or book or faq which highlights the differences between sql2k and sql2005? tia, dk ...
How check if constraint is enabled/disabled?
Mikael Be -
2 Feb 2006 3:28 PM - 5 messages
How do I check if a constraint is disabled or enabled? Constraints have been enabled and disabled by ALTER TABLE x NOCHECK/CHECK CONSTRAINTS ALL but I like to see the status of the constraints. ...
could not find table error message
Dan D. -
2 Feb 2006 3:28 PM - 3 messages
I run a script that tells me what tables need to be defragged. This query gets a list of the tables: SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' and then this query checks to see how fragmented the table is: ...
Using Case in Where Clause
mgx -
2 Feb 2006 2:58 PM - 4 messages
This is kind of an unusual problem that I am having. I am missing something obvious. I just cannot figure out what it is. Basically, here is what I am trying to do. This is a VB application tapping into a SQL Server database. There is a table which contains 3 ...
Concatenating two floats with a comma in the middle
arun.hallan -
2 Feb 2006 2:07 PM - 4 messages
i am using the following code to try and get the following results: convert(varchar,r.LowerStrike)+ ',' + convert(varchar,r.UpperStrike) to get: (for example) "100.22,44.5" But i get the following error: Error converting data type varchar to ...
Not enough storage is available to complete this operation
Heinrich -
2 Feb 2006 1:14 PM - 3 messages
Not enough storage is available to complete this operation" error message when you run a Data Transformation Services package in SQL Server 2000 Any Ideas what to do or what the fix is HH ...
Ruling out OS - SQL Server Performance.
Meher -
2 Feb 2006 12:17 PM - 7 messages
Hi: I have a question hopefully the SQL Server Pros and MVPs would have an answer for. Most of the time like any normal DBA to find performance issues with SQL Server I make use of the performance counters through performance ...
SQL 2005 - Unable to start service
mgale1 -
2 Feb 2006 12:15 PM - 4 messages
All, I am trying to run SQL Server 2005 Evaluation Edition on Windows Server 2003 Entreprise Edition SP1. Until yesterday everything was running fine but today I am unable to start the MSSQLSERVER service. The Analysis Services Service and the Integration ...
Insert - indentity column - rollback
mfsumption -
2 Feb 2006 6:04 AM - 2 messages
When inserting a record (i.e. in the midst of a transaction) and an error occurs and the transaction is rolled back, will the identity column increment to the next value? ...
Xp_dirtree crashs as it seems to have a file limit
Rog -
2 Feb 2006 4:27 AM - 2 messages
Hi folks, We are using a Window's written 3rd party payroll product called Meridian here in Australia that uses SQL Server 2000 SP4 (v8.00.20.39). One of the calls is to the extended stored procedure xp_dirtree (which has the ...
Cannot copy indexes w 2005 Import/Export Wizard
MarkGsch -
1 Feb 2006 11:48 PM - 2 messages
In SQL 2000, the 'Copy SQL Server Objects' task allows 'copy indexes' under 'Advanced Copy Options' when transferring tables. But I cannot see where the SQL 2005 Import and Export Wizard allows this option. Is there an easy way ...
Pause Log Shipping for Server Maintenace
John Oberlin -
1 Feb 2006 10:59 PM - 2 messages
Is there a graceful best practice to temporarily pause log shipping so that unrelated Windows maintenance can be carried out on the servers? ...
Moving tables to new schema
Chuck P -
1 Feb 2006 9:57 PM - 3 messages
I am using sql05 and need to move some tables/data/keys to a new schema (same database). Any easy way to do that? thanks, Chuck ...
Database Maintenance Plan - Can't select Remove Files Older Than .
DHood -
1 Feb 2006 9:36 PM - 9 messages
Hello, Having a strange problem and hoping that someone else has seen this before. Have an up and running SQL Server 2000 (no problems that I can detect). Trying to create a maintenance plan to backup the databases each night. ...
Change Lincense Key
Andrew -
1 Feb 2006 9:25 PM - 2 messages
We currently have a SQL cluster which was built on pirated license keys. This was a managerial mistake let me point out.~ Can we change the license key to legal copy without re-installing SQL? I see that they license key is stored in the registry, but it appears that the ...
Determine when a Service Pack was applied?
Randy K -
1 Feb 2006 9:21 PM - 3 messages
We are running SQL Server 2000 with SP3. Is there a way to determine the date the last service pack was applied? Thanks ...
I need documentation re: dedicated SQL Server
mkerrigan -
1 Feb 2006 8:09 PM - 4 messages
I am searching for some reliable-source documentation regarding why SQL Server should be run on a dedicated server. Can anyone provide me with links to such documentation? ...
DataBase Space
Juliano H via SQLMonster.com -
1 Feb 2006 6:43 PM - 4 messages
Hello, All! I'm creating a script to collect DataBase Space used and DataBase space Total and after that I will store this information in a table in my SQL Server. I've tryed using sp_spaceused but I don't know how to use the result of this ...
TPC-C Benchmark
Talha -
1 Feb 2006 6:04 PM - 10 messages
I am a PhD student at UIC and I am stuyding the performance of TPC-C benchmark over SQL Server. I would appreciate if someone could tell me how I could obtain the TPC-C benchmark application from Mircosoft? Thanks. ...
temp db grows in 5 minutes
hongo32 -
1 Feb 2006 6:03 PM - 2 messages
hello, i have a problem, we are made test of stress over an application and the tempdb grow up to 800mb in les than 5 min. exists a form that i can identify what stored procedure make that this occurs? ...
Figuring out which databases are the most active.
UJ -
1 Feb 2006 5:50 PM - 2 messages
Is there a way to see which databases are getting the most activity? TIA - Jeff. ...
SQL Server Network Utility - No protocols listed SQL 2005
Bababooey -
1 Feb 2006 5:23 PM - 3 messages
Have been trying to figure out a reason for a third party program being unable to connect to one of our SQL Server 2005 databases. Here is the situation. Windows 2003 Standard Box. Initially had installed Windows SharePoint and everything worked fine ...
Differential data backup sql2k
mecn -
1 Feb 2006 4:45 PM - 2 messages
Hi, all I am trying to do the data differential databackup daily and full backup during the weekend. Log shipping remain the same as usual. There is anything that I should be aware of before I chnage the backup method. ...
SQL gurus, please help
Raj -
1 Feb 2006 4:40 PM - 4 messages
Hi, We have SQL Server whose data is being accessed through crystal reports and excel spreadsheets (using ODBC driver). I am trying to find all the crsytal reports ad excel spreadsheets that are hitting a particular database. I thought SQL Profiler will help me with that. It did to some ...
Degraded performance after applying SP4 on SQL 2000 -- repost for no response
Quentin Ran -
1 Feb 2006 4:14 PM - 6 messages
Hi group, I am seeing degraded performance after applying SP4 on SQL 2000. My specific queries (they are in stored proc) access linked server. When the process is run, I keep seeing blocks on the linked server side among ...
Changing Compatibility Level on an Upgraded SQL Server 2000 db to 2005 causing delete to be VERY SLO
blam -
1 Feb 2006 4:07 PM - 6 messages
I have just upgraded my SQL Server 2000 to SQL Server 2005 and from what I understand the upgrade will do the database conversions for you. After the install I tried to delete a row from my Item table which is a ...
msdb marked as suspect
Kallu -
1 Feb 2006 4:01 PM - 2 messages
Hi All, Following error message is displayed whenever i open the Sql Server Management Studio Database 'msdb' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information. (.Net SqlClient Data Provider) ...
Backup Strategy : Microsoft Backup or Veritas
Chris -
1 Feb 2006 3:15 PM - 3 messages
I am trying to decide if we should use Microsoft Backup (Database Maintenance Plans) or use Veritas. We already own Veritas, and the SQL clients. Option 1. Do Not use Veritas SQL client. Use Microsoft Backup to produce a ..BAK file on the SAN. Use the Network install of Veritas (not on SQL svr) to ...
sql2000 backup to samba share
j.goines -
1 Feb 2006 3:14 PM - 2 messages
hi all, 1st of all i have to tell that there is NO active directory and NO windows domain! i try to do a backup from a database to a samba-share on linux over network. first i map the samba share with "net use" command to a drive letter. ...
URGENT: alternative to log file being full
Rob -
1 Feb 2006 3:02 PM - 5 messages
I have posted the following in the 'SQL Server Programming' discussion group; not sure if it belongs there... so I'm reposting it in this group as well: I have a 540 million row table; in it, there is a column whose datatype that ...
Database connection/Access help
JP Bless -
1 Feb 2006 2:43 PM - 3 messages
My app needs to be installed in 3 locations A,B and C. All three locations will use either MSDE or SSQL and have Broadband Internet with static IPs. I want to design the app so user will be able ...
Linked Server Between Domains
David -
1 Feb 2006 1:47 PM - 2 messages
All How do I go about setting up a linked server between a SQL Server 2000 instance in Domain1 to a SQL Server 2000 instance in Domain2. There is a trust between the two domains and when I log onto the server in Domain1 I can ...
moving transaction logs in sql 2000
Fazz -
1 Feb 2006 11:51 AM - 3 messages
Hi We have a mission critical database above which we have a crm application that sits on top of it. In trying to improve the performance of the sql database I have added another logical disk which is in actual fact another ...
Restoration (Database in use!)
Leila -
1 Feb 2006 11:34 AM - 5 messages
Hi, When I want to restore my database, there might be some users browsing the web site and therefore they have connection to SQL Server. I need a quick way to kill all of users and perform the restoration. I think I must use ...
Bug in indexed view??
Space_AD -
1 Feb 2006 10:03 AM - 10 messages
We use SQL server 2000 sp3 database server in Windows 2000 Advanced server OS. In production environment, one of the fact tables in our datamart has over 150 mil rows. A indexed view is built upon this fact table for reporting ...
Identify databases that are not used
Gary -
1 Feb 2006 10:00 AM - 7 messages
Hello, Does anybody know the process of identifying databases what are not used? This can really help me since in our environment we have numerous databases. Thanks, Gary ...
unable to allocate minimum server memory
Franky -
1 Feb 2006 9:43 AM - 4 messages
Hello All, I have a cluster of two nodes running Windows 2003 Enterprise Edition with SQL Server 2000 Enterprise. Each node has 32 GB. And I set the max server memory and min server memory to 28 GB, but the maximum memory was shown only ...
Backup and restore
Harish Mohanbabu -
1 Feb 2006 9:40 AM - 6 messages
Hi, When I tried to restore a database backup that was created by SQL Server 2000 / SP3a installation into a SQL Server 2000 / SP4, I got the following error message - --------------------------- Microsoft SQL-DMO (ODBC SQLState: 42000) --------------------------- The file on device 'D:\Program Files\Microsoft SQL ...
SQL Server Logins - urgent
sc_simsl -
1 Feb 2006 8:38 AM - 4 messages
My SQL server log is flooded with "Login Failed" messages. SQL profiler trace shows application name = "Microsoft SQL Server". What are these connections? Why would a SQL Server initiate connections to another server? Urgent - please help! Audit issue! thanks in advance. ...
SQL for starters.
jithu.m -
1 Feb 2006 8:26 AM - 4 messages
Dear All, I am new into database.Can you please help me in getting my queries solved.I am currently learning oracle basic and looking more into SQL. Can you please telll what is the difference between oracle and sql.Both ...
RE: Optimal Physical Layer config SQL Server on IBM xSeries 345 server
Ruski -
1 Feb 2006 3:06 AM - 3 messages
Hi all, I am building a new IBM xSeries 345 server and we plan consolidate most of the SQL Servers databases on it (~40). I am trying to figure out the best configuration for the disk subsystem for both reasonable performance and ...
Wassup with Sybase?
JXStern -
1 Feb 2006 3:04 AM - 9 messages
Got a call for a job working on (current?) Sybase system, they seem willing to accept SQLServer expertise. Anybody have any words of wisdom on the differences in the current products? (as I understand it, the other tiers are dotnet! Let me guess the ...
|
|||||||||||||||||||||||