|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
Need URGENT help.
MZeeshan -
4 Jun 2005 10:27 PM - 6 messages
Hello- I am trying to restore a large sized database (100+ GB) on a machine that didn't have database in the beginning, so its a create DB + restore operation. Below is the machine configuration: Machine Configuration: quad processor (Pentium 3 Xeon) ...
Emergency - Please help!
Sasidhar N. -
4 Jun 2005 2:22 PM - 5 messages
Hi, I have a database on SQL 2000 server. I don't have backup of this database and till now, I didn't perform any backup operations. Today by mistake, I have dropped some of the tables. I want to recover all ...
Automatics restore script
tram -
4 Jun 2005 9:39 AM - 8 messages
I am setting up a job to automatically restore the standby database. This is to test our tape backups. I need to passon the latest full backup and log file names to the tape system to extract the files. How ...
Locking of Enterprise Manager
RK Joshi -
4 Jun 2005 7:22 AM - 3 messages
I want to lock SQL Server 2000 Enterprise Managaer with Windows Authentication. EM should open with SQL authentication only. Is it possible ? if yes, then please tell me how..? Thanks ...
transfer linked server definitions
Hassan -
4 Jun 2005 4:32 AM - 2 messages
Is there a way to transfer linked server definitions from one server to another ? ...
Sql2000 Memory & CPU gradually maxed by ASP.NET app
Dan English II -
4 Jun 2005 3:30 AM - 5 messages
Hi, I have a strange problem and cannot seem to find a resolution. I am running a busy ASP.NET site on Server2003sp1 & Sql2000sp4. The server has 2GB of RAM, and I have allowed Sql to have 1GB dynamic RAM. ...
Error 15457 in sql logs
fnguy -
4 Jun 2005 2:37 AM - 2 messages
Seeing an error 15457 in the error log. Anyone know what it means? Thanks ...
Viewing triggers
Ant -
4 Jun 2005 1:00 AM - 3 messages
Hello, I'm wondering what is the easiest way to know if any triggers are incorporated into a datatabase(table). How can you view triggers that may exist? Can they be viewed from Query analyzer or only Enterprise manager? Can ...
Problem with table locking
Poncho -
4 Jun 2005 12:10 AM - 2 messages
Hi, We have PeopleSoft HRMS installed with SQL Server 2000 Enterprise,we are having a problem with a table getting block every time we run a time and labor process; this process read a considerable amount of data of the table ...
2147467259 ongoing headache
Rod via SQLMonster.com -
3 Jun 2005 11:48 PM - 2 messages
I am receiving the -2147467259 error randomly when building a large temp table in a VB / SQL app. Sometimes it finishes...sometimes it makes it anywhere from 5 to 90% then bombs. This started when I installed XP Pro. ...
TOP 60000, Remaining rows
George -
3 Jun 2005 11:47 PM - 10 messages
Hi, I don't know how to approach this delima. I have a table with 140,000 records, I need to break this table up in to 60000, 60000, remaining rows in to three seperate text files. I currently ...
sp 4
Catelin Wang -
3 Jun 2005 9:23 PM - 4 messages
How to find sp installed on my computer? I have sql server client tools installed. ...
Performance Problem
DXC -
3 Jun 2005 9:22 PM - 4 messages
I have the following DDL/indexes and the following Stored procedure. I am getting 28 seconds for per user which is unexceptable. What will be the best way to index this table ? UserName column has 28000 rows for 1 user (User1) and TR column has mostly ...
/3Gb option set, but SQL Server use only 1.7Gb....
Jéjé -
3 Jun 2005 8:52 PM - 11 messages
Hi, I have setup the /3Gb option in the boot.ini file because my server has 4Gb of RAM. But SQL Server still use only 1.7Gb. on another server, there is no problems, the same parameters and SQL Server ...
Development - Test Environment Questions
Jerry Spivey -
3 Jun 2005 7:49 PM - 5 messages
Hi, I've been given the task of creating a dev/test environment. Currently we have several production applications using databases on a common SQL Server. If changes are required, the developers are performing the changes on the production system - yea I know BAD,BAD,BAD - but I didn't set this up but ...
SQL Server Help Error
box2003 -
3 Jun 2005 6:43 PM - 3 messages
Hello, I have recently installed SQL Server 2000 with sp3 on a workstation. When clicking help from SQL Query Analyzer, and clicking the "Index" tab the following error condition ocurrs. Clicking the Search, Contents, Favorites seems to work fine. Also loaded on the workstation is VS.NET 2003 and a ...
Oracle financials on SQL Server
fnguy -
3 Jun 2005 6:23 PM - 4 messages
Does anyone know if Oracle financials can run on SQL Server and what to look for? Thanks. ...
SQL Server job is not running on schedule
Demian -
3 Jun 2005 5:10 PM - 7 messages
I have come accross a bit of a mystery with an SQL Server 2000 job schedule. I have many jobs scheduled to run every night that run perfectly. However, there is one job that does not run. As far as I can tell, the job is set up ...
Unecessary update of secondary indexes?
Mark -
3 Jun 2005 5:00 PM - 11 messages
In tests that I have run, it appears that if I update a column to itself and there is a secondary index on the column, the secondary will also be updated (delete/insert). Is this true? If so why? Other ...
Third-Party Monitoring-Performance Tools
Jerry Spivey -
3 Jun 2005 4:46 PM - 3 messages
Hi, I'm new to being a DBA and I'm in the process of "best-practicing" our current SQL Server environment and laying the foundation for future SQL Server implementations. I've been evaluating several SQL Server Monitoring-Performance third-party tools (i.e, Spotlight (Quest Central), ...
Tooltips?
jacob -
3 Jun 2005 4:12 PM - 8 messages
I'm in Query Analyzer and there are no tooltips to tell you what the buttons are. I'm using SQL Server 2000. I'm just used to this Microsoft feature and was wondering if it might just be turned off or there weren't any. It makes ...
What is sp_MSShareFixed?
Do Park via SQLMonster.com -
3 Jun 2005 3:14 PM - 7 messages
Hi all, I got the following error message. Error 229:execute permission denied on object ‘sp_MSShareFixed” What is sp_ MSShareFixed? I think that sp_ MSShareFixed is a stored procedure, but I cannot find it in any manuals. Is there anyone who got the above error? How did you fix it? ...
Check who changed the table?
nick -
3 Jun 2005 2:40 PM - 6 messages
A table was changed several days ago. Is it possible to learn which user did that? ...
SQL Statements
KMD -
3 Jun 2005 2:34 PM - 3 messages
I am looking to find out how many contacts are in a database along with how much is in each table. I am running into a space problem and I need to drill it down to if it is notes, or activities or contacts that are causing the ...
Buffer Cache Hit Ratio vs Memory Manager Cache Hit ratio
Jeffrey K. Ericson -
3 Jun 2005 2:13 PM - 9 messages
We have a box that has 8GB of RAM but the OS only lets us see 3GB. We are trying ascertain whether or not upgrading to a OS that will see the full monty will help or redploying the assets would be a better option ...
Data File Management on SQL Server 2000
Shishir Viriyala -
3 Jun 2005 2:10 PM - 6 messages
Hi Guys, I have got some serious data management issues with my company's implementation of about 70 some odd databases on SQL Server 2000. The server where the databases are physically located has been partitioned into 5 drives, 4 of which are used to store our data files. I am running into some ...
SSPI Context Error Messages
Sean -
3 Jun 2005 1:24 PM - 7 messages
Hi All, I have recently installed SP3a for SQL 2000 and now on the local SQL server I cannot start the SQL Server Agent with a domain account, I cannot register the Local SQL server on the server itself with its host name and I cannot get ...
abt RTRIM/LTRIM ,Null values
krishna nellutla -
3 Jun 2005 8:21 AM - 3 messages
Hi can any one solve my problem; i could not get solution for following query I have two tables like tblOrg and tblorgchartreport so i need to update tblorg for newly inserted rows with tblorgchartreport, suppose there are firstname, lastname ...
Help me!!!
Thanh Hai -
3 Jun 2005 7:46 AM - 3 messages
Hi Master! I'm students in NIIT. I need info of Data management Strategies of SQL Server to write Project and I dont' know Find Topic where. Pls send to me Everything like i talk above. I speak Eng not good, beacause I'm VietNamese. So sorry!! ...
Shrink Transaction Log
Lalit Bhatia -
3 Jun 2005 4:39 AM - 4 messages
How can we shrink transaction log? ...
Moving Database Problem (Chinese)
Larry Richardson -
3 Jun 2005 2:10 AM - 4 messages
Here is the setup. I have a SQL Server 7 DB in China that I need to move to a SQL 2000 machine in US. I have tried several different methods, but the Chinese characters are always messed up. I have created the Server/Database with the CHinese_PRC_CI_AS collation, ...
Performance gain by switching from Win2000 to Win2003?
Peter Yao -
3 Jun 2005 1:15 AM - 3 messages
Currently have Win2000 Enterprise, 4 Xeon CPU, 4 GB memory. Spec for Win2003 mentions better use of hyperthreading for SQL Server and IO performance. Do you leave hyperthreading on at BIOS level for OS to use but prevent SQL Server from using it by unchecking the last few set of the processors in EM? ...
URGENT!!!! Server crashed!!
ChrisR -
2 Jun 2005 11:46 PM - 2 messages
All of my web sites quite responding a little while ago. Restarting SQL didnt fix it. I actually had to bounce the whole box. First error from the SQL Log: 17120: SQL Server could not spawn process_loginread thread. This error was displayed hundreds of times. Also from the Event Viewer: ...
Data File Used Space
Robert Richards via SQLMonster.com -
2 Jun 2005 11:30 PM - 3 messages
How is it, that when I delete records in my Test environment that the "data used" within the data file decreases, but not so when I delete records from my production environment? ...
Correct SELECT Statement via joins
Gav -
2 Jun 2005 11:03 PM - 6 messages
Hi all, I cannot quite get my head around these outer/inner joins (if this is what i need). Basically I have 2 tables ie TABLE ITEMS PRIMARYKEY ITEMNUMBER FOREIGNKEY LASTSUPPLIER FOREIGNKEY CURRENTSUPPLIER TABLE SUPPLIERS PRIMARYKEY SUPPLIERNUMBER SUPPLIERNAME Currently I can get the information I need by using this sort of statement: ...
Question related to recovery of SQL Server database..
Hanuman Mishra -
2 Jun 2005 10:53 PM - 2 messages
In the event of SQL Server recovery... I have listed the following steps (not detailed) as per reading SQL Server books online. Step1. Install the SQL Server and related Service Packs Step2. Restore the master database. Step3. Restore the msdb (to restore the DTS packages and job schedules.) ...
User Defined Functions allow parameters by reference???
Keener -
2 Jun 2005 10:25 PM - 3 messages
I have a stored procedure that returns 2 dates for me via OUTPUT paramaters as I call the sproc with these values by reference. Is there a way to do that with a UDF?? Here is my sample of my sproc: ...
Questions about SQL Server Logs under Management in EM
Do Park via SQLMonster.com -
2 Jun 2005 10:23 PM - 4 messages
Somehow my SQL server logs under Management in SQL server Enterprise Manager is too big, it takes long time to view all logs. I am not talking about Transactional LOG for a specific database. As my understanding, SQL server Logs can be empty (move old logs to Archive #1) after SQL Server ...
SQL Profiler Question....
Hanuman Mishra -
2 Jun 2005 9:56 PM - 2 messages
SQL Profiler is only human interactive? Is it possible to run the application through API? Will it send any notification when certain event happens? I am using SQL 2K. Hanuman. ...
Same Random order every time
Steve Z -
2 Jun 2005 8:56 PM - 24 messages
Let's say I have a table of students - and I want to process these students in random order - but the same order every time. I'm used to the way RND in mainframe basics would return the same order with ...
RESTORE LOG syntax
Leon Shargorodsky -
2 Jun 2005 8:48 PM - 2 messages
I'm getting errors while executing RESTORE LOG statement. Here is my exact statement: RESTORE LOG replication_db FROM DISK "E:\Microsoft SQL Server\MSSQL\BACKUP\replication_db_tlog_200506021345.TRN" WITH NORECOVERY I'm getting this error: Server: Msg 170, Level 15, State 1, Line 2 ...
SP4 for SQL2K....
Jessy Martin -
2 Jun 2005 8:04 PM - 4 messages
All my SQL Server 2K are running on 32 bit platform. Is it required to apply the SQL Server SP4. I am yet to read the fine prints. Thanks, Jessy ...
Waiting for type 0x4, current count 0x808, current owning EC 0x00000000.
GG -
2 Jun 2005 7:42 PM - 3 messages
Hi, We are running SQl server 2000 SP3a and AWE enabled and I believe PAE is enabled too. The server has 7GB of memory. 20GB of Paging space and 28GB of Virtual Memory. It's a 4 cpu 2.9GHZ. ...
Restore database file with difference name
toby one -
2 Jun 2005 7:39 PM - 4 messages
I have SQL 2000 SP3 running on Windows Server 2003, I've backup one of the database to a file and I'll like to copy that file to another SQL 2000 Server and restore it with a difference name. what is the procedures and ...
Alert error text
sonny -
2 Jun 2005 6:58 PM - 2 messages
Hi, I looking for a property or global variable that would give me the alret error text (like the one it sends in email response to an alert) . I need it in my job which runs as a response to an alert. ...
Trying to determine the correct database replication to use.
Wade -
2 Jun 2005 6:48 PM - 8 messages
Hello, I have been tasked with researching and determining the best type of replication to use in our environment. I know of four different types of replication: 1. Snapshot 2. Transactional 3. Merge ...
8.00.0977 how to download hotfixes?
Pari -
2 Jun 2005 6:45 PM - 2 messages
how to download hotfixes? like 8.00.0977 and later one's? are they cumulative of previous fixes? ...
Print in Trigger Statements.....
Jessy Martin -
2 Jun 2005 6:04 PM - 2 messages
SQL Server books online has 'print' statements in the trigger examples. Where exactly the print will happen? How to get benefit of this while debugging? Thanks, Jessy ...
Is possible?
Logan -
2 Jun 2005 5:45 PM - 9 messages
I have an vb4 application (i know it's old, but it's not my fault), and i need to change the used database (sybase) to sql (sql 2000). They are using VBSQL.VBX to access the sybase database, it's possible to use the sql 2000 ...
Server Performance Tunning
Jerame -
2 Jun 2005 5:45 PM - 4 messages
I've been monitoring my servers disk utiliazation, and I noticed the my Ave. Disk Queue Length jumps dramatically durring full or transaction log backups. It typically is less than one, abut jumps to 50 or greater durring the durration of the backup. I'm not sure if this is normal or not? ...
Data File size
Robert Richards via SQLMonster.com -
2 Jun 2005 5:25 PM - 29 messages
My datafile is at 80GB. The data used in the datafile is about 70GB and growing, with approximately 4,000,000 records in a table that contains a Text field. I have a weekly purge that deletes about 500,000 records. (Disk ...
Error Addiing a PK Constraint
Chuck Reif -
2 Jun 2005 5:24 PM - 5 messages
Here is a snippet from an upgrade script: ALTER TABLE dbo.T_APPEAL ADD CONSTRAINT PK_T_APPEAL PRIMARY KEY CLUSTERED ( appeal_no ) ON [PRIMARY] At the top of the script the statements Set ansi_nulls off Set quoted_identifier off are included for some backwards compatability issues. ...
Newbie Question - Edit data on SQL Server using Data access pages
Donald Watson -
2 Jun 2005 4:59 PM - 4 messages
I have been and SQL administrator for about 6 hours now. I grabbed a couple books and have been doing searches online and reading through some MSDN online stuff. Having never seen SQL but having done some Access it wasn't ...
3GB RAM in a server
Kate Smith -
2 Jun 2005 4:34 PM - 11 messages
Hello We've got a Windows 2003 server with 3GB RAM in it and SQL 2000 Standard Edition installed. Am I right in saying that this gives 2GB for SQL to use and then the other 1GB for the OS etc. ? ...
Error when starting SQLSERVER AGENT
Amaury Coria via SQLMonster.com -
2 Jun 2005 4:29 PM - 2 messages
Hello!, I have the following error message when I want to start the sqlserver agent: "The SQLSERVER AGENT SERVICE on local computer started and then stopped. Some services stop automatically if they have no work to do, for example the performance logs and alerts service" ...
Instalation of SP4 on MSDE RevA
Hilarion -
2 Jun 2005 4:20 PM - 10 messages
Hi I have problems with installing SP4 on MSDE Revision A (I'm using the SP4 for MSDE) which is a named instance with mixed mode authentication enabled. It's on Windows XP Professional OEM Polish version with SP2 installed. ...
locking down databases
Nick -
2 Jun 2005 4:01 PM - 3 messages
Hi Im about to install sql 2000. I will have different databases on there that clients will connect to using enterprise manager. I need to know how to lock it down so that when someone does connect into the sql server they can only ...
Enterprise Manager connection to Local server very sloooow.
Sosh123 -
2 Jun 2005 3:46 PM - 6 messages
Hi, I'm having a problem connecting to a local copy of SQL server 2000 using enterprise manager (on Win2k). Doing anything, connecting, refreshing list of tables etc. takes a very long time (>10secs) slower even than ...
SQL Server SP4 installation
Denis -
2 Jun 2005 3:18 PM - 2 messages
Platform: SQL Server 2000 (SP3) running on Win2003 Server RAM: 2GB I have an SQL Server 2000 (SP3) which i am trying to update to SP4. But when I try to install SP4, the installation crashes/freezes every time. Any ...
SQL Server 2000 performance issues
Denis -
2 Jun 2005 3:16 PM - 5 messages
Platform: SQL Server 2000 (SP3) running on Win2003 Server RAM: 2GB At the moment I am using an SQL Server with 2GB of RAM and have set the memory usage to dynamic (sql server decides how much to use) and set the ...
Upgrade Wizzard
Matt helm -
2 Jun 2005 3:00 PM - 2 messages
Hello again This is on a different server from the other question I just posted. I have SQL Server versions 6.5 and 2000 installed on a Windows 2000 server. I installed 6.5 first, coppied a backup of a database to the server and ...
dbreindex and change recovery model
The Gekkster via SQLMonster.com -
2 Jun 2005 2:59 PM - 5 messages
Borrowing from Example 'E' in BOL for DBCC SHOWCONTIG (and modified to use DBREINDEX), is there a way to programmtically change the db recovery model to bulk-logged before this process runs, and then change it back to full at ...
Missing Program group
Matt Helm -
2 Jun 2005 2:52 PM - 9 messages
Guys and Girls I have a server that was running SQL Server 2000 (on Windows 2000 server). In preperation for an upgrade from an old SQL Server 6.5 system. I un-installed 2000. I edited the registry to remove all references to SQL ...
trigger or stored procedure
UGH -
2 Jun 2005 2:19 PM - 7 messages
Can trigger or stored procedure launch an exe from c:\whatever? ...
Does SQL 7 server run well in Win Server 2k3 or do I have to upgra
kwizyu -
2 Jun 2005 2:17 PM - 4 messages
I currently have one machine running windows 2000 server that I promoted to a PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 20003, and I want to migrate the win2k pdc to win server 2k3, that I will promote to ...
Quotes
DXC -
2 Jun 2005 1:56 PM - 3 messages
What is the difference using the single or double quotes in a stored procedure ? Ex1: where username = @username AND status = "D" -- or 'D' Ex2: if @stringtype = "D" -- or 'D' Select ................... Thanks. ...
Nocount
Paperback Writer -
2 Jun 2005 12:59 PM - 7 messages
Hi, I'd like to know if i need to set Nocount On/Off in a proc only for SELECT... ...
SQLExpress 2005/Yukon documentation
Martijn Tonies -
2 Jun 2005 12:35 PM - 4 messages
Hi, I've been searching the MS website, but I cannot seem to find any Yukon/SQLExpress2005 documentation like the BOL for SQLServer 2000 with regard to available DDL and SQL statements... Anyone care for a little help? :-) ...
AutoGrow DB option
andrew bourne -
2 Jun 2005 12:33 PM - 2 messages
Hi all, what i really want to know is what actualy tells sql server to grow the database, file, i found a post that says something about xmb size, what can find no other impormation, So my question is what event promts sql to ...
index scan and seek help...
moash -
2 Jun 2005 8:57 AM - 7 messages
hi, I create a view within 3 tables unoin and every table has a cluster index (corgn ,cssym). create view vsc1 as (select * from tableA union select * from tableB union select * from tableC) select * from vsc1 where corgn = '2213' and cssym = '200502' ...
Error when creating new database user
blaairis -
2 Jun 2005 8:25 AM - 5 messages
When I try to create a new database user (on any database) I get this error message: Cannot resolve collation conflict for equal to operation. I Use SQL_Danish_Pref_CP1_CI_AS as the default collation. Only one user database has another collation: Danish_Norwegian_CI_AI and the tempdb ...
Questions about licensing
Geoffrey -
2 Jun 2005 8:08 AM - 3 messages
Hello, I want to buy SQL Server, but I don't know if I must install cal per users or per device, so my config and use : SQL Server have mixed control access - I have user that use sql server : at work, at house via TSE, at work on ...
Rename logical name of a datafile
Nano -
2 Jun 2005 7:17 AM - 3 messages
Hi all: How i can rename the logical name of a datafile? Best regards Fernando ...
Message pane in QA
Steen Persson -
2 Jun 2005 7:06 AM - 4 messages
Hi Is it possible to get the text from the Message tab in QA written to a log in some way? We are running a lot of scripts to convert and later merge 2 of our databases, and it would be helpful if I could get the results that are ...
Blocking issue in sql2000
Mangesh Deshpande -
2 Jun 2005 5:05 AM - 5 messages
Hi I have one user who uses SQL EM and run queries and modifies data. We see that when the main blocking SPID is SQLEM and command is "select" My question is 1. How can select command from EM be a blocking spid. ...
SQL Server 2000 procedures porting to SQL Server 2005
Subi -
2 Jun 2005 3:00 AM - 4 messages
Hello Newsgroup Mates, I have stored procedures in SQL 2000 database. They are using large no of parameters presently and a huge amount of logic updating multiple tables, using cursors, based on conditions and using transactions etc. What are the ...
backup log in sqlserver 2000
Mangesh Deshpande -
2 Jun 2005 2:04 AM - 3 messages
Hi I want to activate my standby database. My primary database is fine and I want to continue to use it for some other purpose. My question : Do I need to use no_truncate option during the remaining transactions backup? If I use NO_TRUNCATE option can I continue to use my primary database for ...
Removing Domain Controller status from a SQL server
Kahonu -
2 Jun 2005 2:03 AM - 4 messages
Aloha - I have a sick server (HOKU) which doubles as a domain controller and a SQL server. The plan is to move SQL to a new server (SQL1), demote HOKU to a member server, remove it from the domain then do away with it. ...
Multiple instances...
Jessy Martin -
2 Jun 2005 1:38 AM - 2 messages
Is it possible to run multiple instances of SQL server on the same computer? SQL 2K. Thanks, Jessy ...
how to find which line has error
Data Cruncher -
1 Jun 2005 11:15 PM - 3 messages
I am running a script which inserts large number of rows thru INSERT INTO VALUES statement. One of them is giving some error. While running it in Query Analyzer I am not able to know which line is giving the problem. How do I make QA show me the offending line. ...
How to replace first 5 digits of SSN(string) with XXXXX?
wchrimes -
1 Jun 2005 10:27 PM - 3 messages
I need to replace the first 5 digits of a string field that contains Social Security numbers with XXXXX's to preserve privacy. I've looked at the length and replace functions, and can't seem to get them to work together. Can ...
SQL Server backup to iSCSI tape device
Bill Murray -
1 Jun 2005 9:45 PM - 2 messages
Has anyone been able (or not able) to use the SQL Server backup feature to backup data to an iSCSI tape drive? For some reason is doesn't seem to recognize the Tape0 device as a valid tape device. Strange thing is - this worked find when we were using the IBM iSCSI ...
Log Shipping between 2 stand alon servers
MGeles -
1 Jun 2005 9:07 PM - 3 messages
Does Log shipping between 2 servers require that the 2 servers be on a domain? I've been asked to set up log shipping between 2 different servers that are each stand alone (they are not on a domain). I've set up log shipping ...
[TCP/IP Sockets]ConnectionCheckForData()) Error
davidhg -
1 Jun 2005 9:05 PM - 4 messages
Error was returned when we compiled a proc. The proc compiles under SP3a. We're using Standard Edition SP4. The offending statement is a sub-select in a where clause that uses a union: and mv.INSTR_ID in ...
MSDE vs SQL Server
Pavan Sabharwal -
1 Jun 2005 8:02 PM - 4 messages
I have a client who wants to move away from SQL Server 6.5. Their option is to migrate to SQL Server 2000/2005 or MSDE. The current database is abotu 1.7 GB and does not have more than 2-3 concurrent users. The application ...
Restoring master and msdb on a different server
Oskar -
1 Jun 2005 7:48 PM - 9 messages
Hi I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380 G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows ...
MS Access Query vs. SQL 7 Stored Procedure
Scott Elgram -
1 Jun 2005 6:54 PM - 12 messages
Hello, I herd somewhere that queries written in access that query a SQL database are run either partially or completely with the clients memory. I have 6 update queries that are in access that update tables in SQL. ...
SQLServer Agent
RG -
1 Jun 2005 6:09 PM - 3 messages
I have created a new job wich runs sp_help_revlogin script. Every output line of this script, and from what I understood any other script which produces output, is appended with [SQLCODE 100000] string. How can I prevent it from appearing? ...
MS PSS-What the heck is this?!
Anthony Thomas -
1 Jun 2005 6:03 PM - 8 messages
BUG: Not all memory is available when AWE is enabled on a computer that is running a 32-bit version of SQL Server 2000 SP4 [link] This seems to be a pretty significant issue missed by the "more rigorous ...
SQL Backup expire date....
Jessy Martin -
1 Jun 2005 5:55 PM - 3 messages
In the SQL Server backup documentation I am seeing some reference to expire date. Expire date has any impact on if we need to restore the database after two years or so. I am using SQL 2K. Thanks, Jessy ...
SQL Server Performance
DAL -
1 Jun 2005 4:40 PM - 2 messages
I've been running an application that pulls from a SQL Server 2000 sp3 database. About 2 weeks ago it started having problems. Did some checking on it, memory, etc and found that "Named Pipes" had been turned off. Turned ...
Basic question.... on Index....
Jessy Martin -
1 Jun 2005 4:33 PM - 8 messages
Why the name clustered is used in the clustered index? What is exactly clustered here? Thanks, Jessy ...
Problem (or bug) with waittime column in sysprocesses table
andsm -
1 Jun 2005 4:00 PM - 2 messages
I run two scripts. One do update of row, and next do waitfor delay '0:30'. Its in transaction. Second script try to update same row, so it waits. I run the scripts from Query Analyzer, so I see what one script really wait another ...
full drives full trans log version 7
M D -
1 Jun 2005 3:33 PM - 5 messages
What does one do? I tried "backup log mb with no_log" to truncate the file. I've now started a shrinkdatabase. I can't backup since the drive is full. I can't disconnect because it's 7. ...
alter table drop column and dbcc cleantable
Robert Klemme -
1 Jun 2005 3:23 PM - 4 messages
All, I just want to make sure my understanding is correct: 1) alter table drop column does not release space of varchar columns and other columns of variable length. 2) dbcc cleantable frees this space Open questions: 3) What about the space used by fixed size columns? Is it reclaimed ...
SQL7 2 DB files down to one???
J Hotch -
1 Jun 2005 3:15 PM - 4 messages
having moved 2 of our SQL servers onto new hardware, we now have no space issues. previously some of out DB's had to have multiple files spread across different disks due to disk size limits. now that we can locate a whole DB on a single disk again, is there any way ...
Problem with osql.exe -L
Gururaj Badam -
1 Jun 2005 2:45 PM - 7 messages
Hi Everyone, I'm facing a small problem. Whenever I execute osql.exe -L command it lists all the server on the network except my local server instance (not default instance) and other similar server instance names on the network. ...
Autonumber
John -
1 Jun 2005 2:30 PM - 4 messages
Hi How does one set an auto-number field in sql server 2005? Is this a good way to generate primary keys? If not, could I have some recommendations? Thanks Regards ...
server shut down by request
Dan D. -
1 Jun 2005 2:09 PM - 4 messages
Is there any way to tell who shut down the sql server services? All it says in the log file is "spid67 server shut down by request". Thanks, ...
varchar vs nvarchar
Ron -
1 Jun 2005 1:59 PM - 6 messages
I received a script from a developer that uses nvarchar in all the tables instead of varchar. My understanding is that will double the space needed for each of these columns and there are many. I've read through BOL and still can't decide whether or not nvarchar is ...
|
|||||||||||||||||||||||