|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
deleting rows from one table when they exist in another
bob -
12 Aug 2006 8:50 PM - 2 messages
A project I'm working on has a daily update of a table and then reapplies each day a table of updates called EditHistory. What's the best way to do this while avoiding duplicate rows. I want to copy all rows from the table that's been updated, then remove any ...
Functionality of SQL Server Errorlog
Joe K. -
12 Aug 2006 5:01 PM - 2 messages
What is the functionality of SQL Server 2000 Enterprise Manager Errorlog? Thanks, ...
Applying SP4 on an active/passive 2 way cluster
Shiva -
12 Aug 2006 3:31 PM - 5 messages
I have a 2 way cluster and I want to apply SP4 on it. Basically, I have 2 servers. Server A runs a default instance and another instance. While the default services is disabled and the other ...
Protecting Data Models inside SQL Server
Peter Nolan -
12 Aug 2006 3:14 PM - 4 messages
Hi All, I was talking with a colleague the other day and he made an interestinc comment..... He said he thought there was some way to protect the data model in an SQL Server database from the prying eyes of a client whom the ...
SQL 2005 change collaction
Langer -
12 Aug 2006 12:06 PM - 4 messages
Is it possible to change the collaction on a database during backup/restore when we move a database from test to production. the test environment has wrong collaction and we like to have Finnish_Swedish_CI_AS in the production. The backup/restore is a step ...
database disappeared from SQL 2005
JohnZing -
12 Aug 2006 10:33 AM - 2 messages
Hi One of my database disappeared from SQL 2005. Maybe my mistake (i dont remember) or some SQL problem... or.. something else. Is there a way (logs, etc..) to see when database was deleted? Thank You ...
Please guide me to change password of win. user account use for sql server services in SQL Server.
csajid -
12 Aug 2006 8:02 AM - 3 messages
Hi, I have Active / Passive cluster with following configuration. O.S. - windows 2003 Enterprise Edition SP1. H/W - 4 Processor (Xeon) + 3 GB RAM. SQL - SQL Server 2000 ED + SP3 the password of windows account use for running SQL Server services has ...
SQL Server Help Needed
gold.study@gmail.com -
12 Aug 2006 7:06 AM - 3 messages
Hi everybody. I have 2 tables named daily, executive Structure of Executive : exe_code - nvarchar(20) exe_name - nvarchar(100) Structures of Daily: fileno - int identity(1,1) name - nvarchar(20) resiexecode - nvarchar(20) offexecode - nvarchar(20) Records in Executive : exe01 - Ram ...
How to analyze SQLProfiler trace result ?
krislioe -
12 Aug 2006 3:37 AM - 3 messages
Hi All, I plan to run SQL Profiler because my SQL Server 2000 get the users timed out after running some time, and happen every day. (see [link]) ...
SQL Server 2005 Maintenance plan
Peter Afonin -
11 Aug 2006 11:19 PM - 9 messages
Hello, When i create a Maintenance plan in SQL Server 2000 and include backup of all my databases, I can specify the number of days after which the backups are automatically deleted. For instance, I setup a backup to the folder and ...
Restoring SQL2000 DB to SQLExpress on different machine
DGardner -
11 Aug 2006 11:11 PM - 3 messages
Really having a problem... I have a full backup in a file where RESTORE FILELISTONLY FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\DeviceTest_db_200608060200' shows the results... DeviceTest E:\Microsoft SQL ...
ntext and select distinct
Katie -
11 Aug 2006 9:40 PM - 3 messages
hi, i have a table with columns A,B,C,and D where D is ntext i want to do a select distinct on A B and D. I dont care if the values in column D are not distinct, i just care about the values in column A ...
DTS MAPI profile
Leon Shargorodsky -
11 Aug 2006 8:54 PM - 4 messages
I get "Unable to load MAPI profiles" error message in DTS Designer trying to add "Send Mail" task. SQLMail has been installed and configured (and tested, it works) on the same server. Please help, thank you in advance ...
Error Creating Maintenance Plan
Mark Miller -
11 Aug 2006 8:49 PM - 5 messages
I have a new installation of SQL 2005 x64 SP 1 Standard Edition installed on Windows 2003 x64 SP 1 Standard Edition. I installed using unattended install. In the ini file for unattended install I specified ADDLOCAL and amoung other features I specified SQL_Tools90, which according to the ...
Logshipping
Manoj Kumar -
11 Aug 2006 8:09 PM - 2 messages
All- I have typical the log shipping enabled between a prod server and another server. If I restore the log sipping source[production] say with a 6 hours back full db backup + diff [1 hour], what will be effect of this on the log shipping? ...
Triggers Rollback?
Katie -
11 Aug 2006 7:45 PM - 2 messages
Hi, I am using several triggers on delete on insert etc. I was wondering do the triggers get "rolledback" if the main process is interupted Thanks ...
q; two difefrent database
JIM.H. -
11 Aug 2006 7:42 PM - 2 messages
Hello, I have two application running on two different database, and I have only one Windows 2003 server. Which way is best to go: two instances on the same server or two different databases under one instance? ...
SQl 2000 vs. 2005 creating a user
SteveS -
11 Aug 2006 5:21 PM - 4 messages
Here are two queries I have (top one is for SQL 2005, the bottom is for SQL 2000): I know SQL 2000 likes the sp_addlogin, and I can use that in SQL 2005, but SQL 2005 likes the CREATE LOGIN. My query below for 2005 works great in ...
Trigger through firewall
Eugene -
11 Aug 2006 4:39 PM - 9 messages
Hi everyone, I am new to this so any help will be much appreciated. I have a problem running triggers between two linked SQL servers. I am running Windows Server 2003 and SQL server 2000 SP4. Both Allow Outbound and ...
Order by owner match variable and then alphabetical
Colin -
11 Aug 2006 4:26 PM - 2 messages
Below is a subset of some returned data I'm getting from a query. Through reporting services the user is choosing which team's projects he wants to view. Here is the projects for "SE -Platform Services", but I'd like to ...
SQL Log Shipping
Rustom -
11 Aug 2006 4:14 PM - 3 messages
I am having issues with SQL Server 2005 logshipping. Everytime the secondary server restores the logs my users are kicked out of the database. Is this a comman issue? I was under the impression that SQL Server 2005 ...
Connection Issue
Brandon Owensby -
11 Aug 2006 4:02 PM - 2 messages
The computer I work on has Sql Server on it. We also have a main server in the office with sql server on it. The sql server on my computer has test data that I do my development with but part of the data needs to be kept up ...
Identity column
robken -
11 Aug 2006 3:43 PM - 5 messages
Hi all, Does anyone know if you can put an identity column into a table that has been created by SELECT...INTO query, either at the same time as your creating it or after? Thanks alot! Rob ...
Index FillFactor's
cbrichards via SQLMonster.com -
11 Aug 2006 3:19 PM - 10 messages
I have a table in a database that has six indexes. Four of those indexes have a FillFactor = 90. Two of those indexes have a FillFactor = 0. My Reads in relation to Writes are approximately 100:1. Does it make sense that some indexes would be set at 90 and other indexes set ...
Can't shrink a database
Steven Berkovitz -
11 Aug 2006 2:04 PM - 3 messages
Hi there, I am running SQL2005 SP1 Standard. I have a database that was originally a SQL2K db that was rolled up to 2K5. Everything was fine with it until I truncated a few tables and dropped a large column & index on a few tables. Since then the following symptoms are ...
Normalization - help me understand
Learner -
11 Aug 2006 12:43 PM - 5 messages
Hello, I guess this is a good brief definition for Normalization. I am trying to understand what is the sentence "and are not and are not dependent on any non-key ATTRIBUTEs." in the definition. "Normalization is the process of designing database tables to ensure ...
Unattended Installation of SQL 2005 from two disks
shub -
11 Aug 2006 12:39 PM - 2 messages
I am trying to run a unattended installation for SQL 2005 in quiet mode (qn). I will be using a ini file to run the installation however the question I have for the group is how do I copy both the installation ...
Performance and Large Data
Hamed -
11 Aug 2006 9:50 AM - 4 messages
Hi *.* I've a table with 14 columns and 640.000 rows, a simple select (* from table ) is very slow (about 16 seconds on my P4 2800, 750 MB of Ram), Is it normal? How can I reduce this time? With some reports that use ...
Database Engine Worker thread pool : Queue length
Olivier Matrot -
11 Aug 2006 8:11 AM - 6 messages
Hello, When the "Max Worker Threads" parameter is lower than the number of client connections, SQL Server pools the worker threads. Is there a performance counter to see the worker thread pool queue length (connections waiting a thread to handle requests)? ...
Wrong User UID in the table
Tomasz -
11 Aug 2006 7:20 AM - 3 messages
Hello, I'm not experienced user of ms sql, but i have stupid problem. I restored database from my backups. This database is used by one old application and this application uses sql user to authetificate (not AD). Problem is my server has no such user in users section (it appears ...
DTS Vs BCP/Bulk Insert - What to use?
Karthik -
11 Aug 2006 6:37 AM - 5 messages
Hi, I have around 13 million records in a table on Server A. I need to port this data to Server B over the network (LAN). Would it be better for me to BCP out the tables first in Server A and then ...
Interaction between SQL2k, SQL2k5, and SQLExpress
Earl -
11 Aug 2006 5:09 AM - 2 messages
I've got both SQL2000 and SQL2005 running side-by-side and now I want to test a ClickOnce deployment of my app with SQLExpress. Anyone been down this road and know whether I will step on the toes of the installed servers? ...
SQL2000 Multi Instance Problem
Ivan -
11 Aug 2006 4:30 AM - 6 messages
Dear all, We have a server with 2 SQL2000 Instance, A & B. Some of our clients need use IP to connect to the SQL2000 Instance. If the Server IP is 192.168.1.200, how can I set the client to use IP to ...
SQL Server 2000 Online Backup
Tane M. Baum -
11 Aug 2006 4:23 AM - 3 messages
We have a size able database files in the production. In order to minimize the time to do a full backup, is it possible to take a snapshot of all the database files while the database is online with the ...
dynamic SQL versus a huge IF structure
ibiza -
11 Aug 2006 1:36 AM - 12 messages
Hi, I have a stored proc intented to search a table on different fields, depending on the search type. Up until now, I have implemented 3 options, which is by kanji, kana and english. I'll add many others, like strokes count, radical # and so on. ...
Locking problem (Urgent)
Farrukh -
11 Aug 2006 12:53 AM - 3 messages
hello we have a Stock report. this report use to take 15 mins few years and now it takes 3 hours. I am wondering if anyone look at my store Procedure. When i also run this report, it locks automatically the user who runs this report. ...
Error - Event ID 3633
Seok Bee -
11 Aug 2006 12:42 AM - 3 messages
Hi, My server is currently installed with SQL Server 2005. I checked in the Event Viewer log file I noticed that I get the error message which the source is MSSQL$SQLEXPRESS, following is the detail of the error message: ...
SQL 2000 Database suddenly unstable.
Ryan W. -
11 Aug 2006 12:34 AM - 4 messages
I work for a small analytical laboratory. I'm mostly the net admin guy, but I do the db stuff (poorly) and other things. Last night right before closing my users started experiencing bigtime slowdown. This morning it was magically better for a short duration. ...
parameter in DTS
JIM.H. -
11 Aug 2006 12:09 AM - 2 messages
How can I get a DTS ask a parameter to use it in the where clause of the query before it runs? ...
Stored Procedure Multiple Parameter Question
Isaac Alexander -
10 Aug 2006 11:51 PM - 8 messages
I am using SQL Server 7, 2000 and 2005. I want to create a stored procedure for my query. My query is as follows: select column1, column2, column3, column4 from table where date1 >= 'Jan 1, 2006' and date1 M 'Jan 2, 2006' ...
ADO Integrated Security Pass Through Again
Isaac Alexander -
10 Aug 2006 11:45 PM - 3 messages
The previous thread died so I'm sorry for the repost. I am working on making my application inherit the workstation login user information so that users aren't presented with multiple logins. Does anyone have any experience linking internal application user management ...
Partitioned View, constant versus variable
Anatoli Dontsov -
10 Aug 2006 11:36 PM - 6 messages
Hi, All! I have some tables and partitioned view. Tables defined as required, with PK and check constraint CREATE VIEW MyView AS SELECT * FROM Table1 UNION ALL SELECT * FROM Table2 UNION ALL SELECT * FROM Table3 If I select something [in Query Analyzer] using constant ...
DTS and handling dates
robboll -
10 Aug 2006 9:09 PM - 5 messages
I am trying to DTS some data from delimited source and some of the dates have the value 99999999. This naturally makes the DTS job fail. Is there a method to make it ignore these values and append only those ...
Backups
Rockn -
10 Aug 2006 9:09 PM - 3 messages
Our current SAN capacity has just hit the wall and I need some advice. The SAN stores our current production SQL db and the backups on another volume. The volume that the backups for TL's and the database is on is completely ...
"Know Issue" not in KB. COLID continues to rise.
sqldba -
10 Aug 2006 8:44 PM - 2 messages
I use transactional replication on several very "wide" table. One has 254 columns. After finding that was my limit for replication to work I removed an unused columns and added a new needed column. Since the COLID in the SYSCOLUMNS did not reset replication failed. I'm down to ...
Fixed Memory = 3Gb sqlserver.exe uses 1.7Gb
David Morgan -
10 Aug 2006 7:59 PM - 4 messages
Hello We are trying to enhance the performance of our server. We recently noticed that despite having 4Gb of RAM in the server, sqlserver.exe was only using 1.7Gb. There are 4 databases on the server, one of which is at 9Gb and in ...
Do CLR DLLs use more memory / slow SQL server?
Kyle Jedrusiak -
10 Aug 2006 7:52 PM - 4 messages
We has some response issue with minor schema changes. Except we're using some C# DLLs now. Kyle Jedrusiak ...
Complex Query (atleast I think so)
Preacher Man -
10 Aug 2006 7:43 PM - 5 messages
We have a couple of Bill of Material tables in our SQL 2000 database and I need to extract information. The first table is the master table and the only relevant field is fpartno. Table two is the child table, and it contains all of the parts that make up ...
SQL Server 2000 Errors
Joe K. -
10 Aug 2006 7:15 PM - 2 messages
What kind of warning, critical, errors messages are stored within SQL Server error log? ...
How To Downgrade SQL Server 2000 Enterprise Edition to Standard Ed
JonMoss -
10 Aug 2006 7:14 PM - 2 messages
Two years ago, when I upgraded all my SQL Servers in our various branch offices, I apparently took the wrong CD with me and installed Enterprise edition when I meant to install Stanard. Is there a procedure to downgrade an existing production SQL Server from ...
Website Links SQL Server Support WebSites
Joe K. -
10 Aug 2006 6:50 PM - 3 messages
Looking to obtain website links to Microsoft SQL Server Support Sites? Thanks, ...
"Invalid command option D."
WANNABE -
10 Aug 2006 6:34 PM - 7 messages
When trying to start SQL 2000 from dos prompt. I changed the start up locations -D -L -E for my server from EM server properties, Moved the Data and log files (MDF and LDFs), then tried to restart the server and it failed. I duplicated all files to their original ...
SQL performance bench marks...
Mrpush -
10 Aug 2006 6:32 PM - 3 messages
Hello, Just finished running SQLIO and SQLIOstress to test my SQL server hardware in a RAID 5 and RAID 10 configuration. I question what exactly is the best criteria to key off of for performance. Do I look at the IOS, MB/sec, or Latency to get the best feel of performance? ...
Duplicate instances
coenzyme -
10 Aug 2006 5:21 PM - 3 messages
On one box Enterprise Manager is indicating a second instance “ . (Windows NT)†, in addition to the default instance, “ (local) (Windows NT)â€. This second instance was not installed, It just appeared. The MSSQL directory ...
SQL2005 running slow after schema and SP updates
Kyle Jedrusiak -
10 Aug 2006 4:47 PM - 10 messages
We make changes on our dev server and test them. Then we move those changes over to production. The largest real change is we've added some c#/dll to the database (mainly for string manipulation). A search that takes 3.XX minutes on the dev server takes over 56.XX minutes ...
restore from a read only database
Luis Ernesto Aguayo -
10 Aug 2006 4:43 PM - 4 messages
Hi, I need to recover a 2 GB database wich is in read only state, it doesn't allow to change the state ( error with the data file name ...) but the data is readable, doing some querys it seems ok. ...
NIC settings for SQL 2005 and Windows 2003?
DBA Dude -
10 Aug 2006 3:55 PM - 3 messages
All Anyone know what is truly recommended for the NIC settings for SQL 2005 when installed on Windows 2003? Microsoft SQL MVP and SQL author: Mark L. states that the NIC should be set to: "Maximize date throughput for file sharing." ...
Network error
KMP -
10 Aug 2006 3:37 PM - 9 messages
When I unplug my server from the network, I lose connection to SQL Server. I don't understand why it is happening. All my applications have to be closed and reopened to talk to the database again. Can anyone please let me know why ...
Open File Dialog Like Enterprise Menager ?
blacketik -
10 Aug 2006 3:14 PM - 2 messages
Hi, It is possible to open a file dialog directly from another pc (windows 2000 server sp4, msde sp3) like enterprise manager do when you try to restaure a database? I don't want to share folder on my server, and I want to select the ...
Performance and TempDB
cbrichards via SQLMonster.com -
10 Aug 2006 2:55 PM - 6 messages
I am seeing high CPU. My disk counters are normal and memory is in good shape. I have reindexed and DBCC ShowContig has all indexes greater than 90% scan density and logical fragmentation is all down near zero. I have approximately 100 reads for every write. My FillFactor is set at 90%. ...
Temp Tables and TempDB
cbrichards via SQLMonster.com -
10 Aug 2006 2:37 PM - 13 messages
1. If I do not drop a temp table after being used in a stored procedure, how can that cause TempDB to grow? 2. If I do not drop a temp table after being used in a stored procedure, will ...
what is an extended stored procedures?
Learner -
10 Aug 2006 1:44 PM - 4 messages
Hello , I was going through an article that talks about the CLR stored procs. If a stored proc wouldn't have built as an extended stored proce and we don't need write CLR stored proc. Please some one take a moment to explain what is an extended stored ...
changing sa pwd, how??
Eng.Rana -
10 Aug 2006 1:20 PM - 4 messages
hi all, i want to change the sa password from my C# code. i'm using SQL server 2000, win XP, .NET 2003 and need to develop a simple application that changes the sa password from the code and not ...
Alert for DeadLock
ravi lobo -
10 Aug 2006 1:05 PM - 6 messages
I am trying to create an alert to monitor deadlocks with following specification. Name = "Deadlock(s) detected . . ." Type = "SQL Server performance condition alert. Object = "SQL Server:Locks" Counter = "Number of Deadlocks/sec" Instance = "Database" Alert if counter = "becomes equal to" ...
Timeout expire
fniles -
10 Aug 2006 12:49 PM - 15 messages
When running a query in SQL Server 2000, I got "Timeout expired" error. How can I increase the timeout time ? Thanks. ...
Oracle DBA to learn MS SQL
sandiyan -
10 Aug 2006 11:13 AM - 6 messages
Is there a materials such as the following for an Oracle DBA who would like to learn MS SQL(e.g. 2005) - Training courses - Web sites/ebooks - MS articles - etc SQL Server features and compare it with Oracle. So, it should be something of learning method for a person with DBA ...
SQL 2005 - can't connect using server name, but connects with IP
andyrich_1 -
10 Aug 2006 10:34 AM - 2 messages
Hi, I'm trying to connect to a SQL 2005 server using Managment Stuidio Express. I can conenct to the server using it's IP address but can't when I specify the machine name. I can telnet to the machine's sql server port using the machine name ...
Shrink Database not having an effect
arne.lovius -
10 Aug 2006 9:51 AM - 20 messages
Hi, After noticing that one of our databases was growing at alarming rate we discovered a 'bug' in the vendors application and ran a truncate table (at vendor request) to remove the excess data. This changed the used space in the db from 17gb to 4gb which is great ...
Sample databases.
SQLCatz -
10 Aug 2006 7:08 AM - 3 messages
I'm in the process of running a set of tests on SQL Server 2005 (multiple instances). For the scenarios that I want to test – require 4-5 sample databases (in addition to the AdventureWorks provided by Microsoft). Can someone point me ...
SQL 2000 SP4 Slow Performance
Stephen Tsai -
10 Aug 2006 3:23 AM - 8 messages
We get a old SQL 2000 server (with SP2). We are moving to a new server (HP DL380 with 2 Xeon 3.0 CPU, 1G RAM), SQL 2000 SP4 installed. We are doing some performance testing on the new server and found the followings, ...
This sure is cornfusing ... connection woes
Earl -
10 Aug 2006 1:36 AM - 7 messages
SQL2005. New installation as a named instance on a local machine. Attached a database previously designed in SQL2000. My app calls for this database using integrated security. With SQL2000, no problems connecting and executing code against the db, including stored procedures. ...
How can I insert a new field between existing field?
Alex AU -
10 Aug 2006 1:29 AM - 9 messages
Dear all, Is there any way can I insert a new field between existing fields through TSQL or other means, without using Enterprise Manager? Thanks a lot. Regards, Alex AU ...
SQL Server 2000 restore problem
Jason Fischer -
9 Aug 2006 10:22 PM - 3 messages
Hi All, I have a client doing a backup and then trying to restore the backup. When they do, they get the following error: An internal consistency error occured. Contact Technical Support for assistance. RESTORE DATABASE is terminating abnormally. This does not happen to all backups only some of them depending on if users ...
What do I need to do to start SQL2000SP3 with databases in a different location ?
WANNABE -
9 Aug 2006 10:14 PM - 5 messages
I thought it would be easy enough to change the start up locations for my server from EM database properties... WRONG!! I made the changes, stopped the SQL service, Moved the Data and log files (MDF and LDFs), then tried to ...
non-leaf-level pages and leaf-level pages?
Cesar -
9 Aug 2006 9:22 PM - 5 messages
Hi What is de diferents beetwen non-leaf-level pages and leaf-level pages? Thanks Best Regards Cesar ...
SQL 2005 Exception Processing
Jim Heavey -
9 Aug 2006 9:21 PM - 2 messages
I'm relatively new to SQL stored procedures...coming from Oracle world. I am writing stored procedures and I am trying to write "Exception Handling". In oracle, there were "predefined errors" that you could "catch", such as "Dup_Val_ON_INDEX" or "No Data Found". Is there a list of pre-established ...
SQL CLR or TSQL?
Learner -
9 Aug 2006 9:11 PM - 12 messages
Hello Friends, I have been thinking of writing Stored procs in SQL CLR/ changing all of my Stored Procs to SQL CLR. Is there any thing that I need to keep in mind about the size of the ...
maintenance plan wizard - security question, possible bug?
Pedja -
9 Aug 2006 8:34 PM - 3 messages
Hi All, I am trying to create maintenance plan for updating statistics, checking database integrity and database backup, using wizard. First of all, I don't see any option for how long do I want to keep backup files on the system ...
Complex Price List
roger -
9 Aug 2006 8:21 PM - 8 messages
I need help with an odd request. I have been asked to create a view price list that includes the price each customer will pay for any product. ProductID, customerID, and price is all I really need. Our ...
row to column
JIM.H. -
9 Aug 2006 7:16 PM - 4 messages
hello Table T1 has T1: MyID, MyDate1, MyNote1, MyCharge1, MyDate2,MyNote2, MyCharge2 How can I write my view to report these in MyID, MyDate1, MyNote1, MyCharge1 MyID, MyDate2,MyNote2, MyCharge2 format? ...
speed up stored proc when there are multiple selects?
ibiza -
9 Aug 2006 6:27 PM - 9 messages
I have a stored proc which receives a @k nchar(1) as parameter then I do two selects based on that value (SELECT ... WHERE kanji = @k) I'd like to know if it's worth it to add a select before these two ones ...
Unable to backup database: possible full text indexes
ANeelima -
9 Aug 2006 6:03 PM - 2 messages
I had a database called 'ENDesktop10Temp' in MSDE 2000. I restored it without problems into SQL Server 2005 Express. When I tried to backup the database from 2005 Express using either the Enterprise manager/SQL DMO/SMO, etc. I kept getting the following error:
------------------------------------------------------------------------------------------------------ ...
WITH ENCRYPTION
stoney -
9 Aug 2006 5:57 PM - 3 messages
Hi, What are the advantage and disadvantage of 'WITH ENCRYPTION'. We have a few SQL 2000 machines with vendor bought software. Some development happens on the various application. Thanks, Stoney ...
Remote Query Performance
Brandon Lunt -
9 Aug 2006 5:35 PM - 6 messages
I have a query that when executed against the host server, it completes in 11 seconds. When I execute the same query against a linked server it takes 100 seconds to run. I have checked the execution plan for the linked server ...
AWE Question
Isaac Alexander -
9 Aug 2006 4:53 PM - 7 messages
What would be the optimal max server memory setting for the following machine? Dedicated SQL Server: Intel Xeon MP 3.3 GHz (4 physical Processors) 136 GB (C Drive) 8.0 GB RAM Microsoft Windows 2003 Enterprise Edition Service Pack 1 Build 3790 ...
backup and restore
danielsmith611 -
9 Aug 2006 4:30 PM - 6 messages
On a production server, I do a full backup monthly and then delete data from the tables that is older than the current date. On a separate non-production server I restored the initial full backup. My question ...
SQL backup solutions...
Mrpush -
9 Aug 2006 4:28 PM - 5 messages
Hello, Using SQL 2000 and need to choose a good backup solution. I'm aware that SQL has its own backup utility, but what about 3rd party backups solutions? My main choices seem to be Backupexec 10D or Arcserv 11. Can anyone sugget ...
Disappearing databases - HELP!!!!
CyberDwarf -
9 Aug 2006 3:14 PM - 6 messages
Running SQL Server 2000 - patched up to date, behind firewall, on Win2003 Server, using MacAfee VirusScan Enterprise Over the lunchtime, we seem to have lost several databases from a couple of server groups on our server! It appears no-one was working on the server at the time. ...
Backup logged time different
Rob -
9 Aug 2006 2:50 PM - 2 messages
Hi, I'm confused with what's being reported by SQL Server for the date of a transacation log backup. The backup had been taken on Jun 29, 2006, 12:14:20 p.m. This can be seen in the Archive SQL Server Logs. However, when I double-click that entry, I get ...
Error in installing SQL server 2k
Elton W -
9 Aug 2006 2:19 PM - 3 messages
I am getting error when installing SQL server 2K Developer Ed in Win XP. It shows “An error occurred while creating one or more registry entries. The problem could be caused by a low registry quotaâ€. Hope some one can give me some hints. ...
reinstalling SQL ODBC Drivers on Windows XP
Matt Bateman -
9 Aug 2006 2:13 PM - 2 messages
Apparently one of my users lost their ODBC drivers for SQL Server. When I try to run the program that uses those drivers obviously I get all kind of errors. I tried going into the ODBC administrator and when I try to edit or ...
SQL Server 2000 BOL
Joe K. -
9 Aug 2006 2:10 PM - 4 messages
I am looking for the Microsoft SQL Server 2000 books on line (BOL) website link that I can display the latest copy this program. Thanks, ...
ABS function issue
Rajeev -
9 Aug 2006 12:57 PM - 2 messages
Hi Onibuzz, One month ago i have posted one topic on microsoft.public.sqlserver.programming group and u have posted a reply to it. Your reply was a great help to me but i am stuck with another small issue in the same query. I would greatly appreciate if you help me ...
what SQL-DMO can do
Eng.Rana -
9 Aug 2006 12:36 PM - 2 messages
hi all, i'm just SQLDMO newbie and need some help. i was wondering if i can use SQLDMO to do the following: 1- set a new password (change) sa password 2- delete any db accounts 3- add new db accounts ...
xp_sendmail & xp_readmail at SS 2005
Nikola Milic -
9 Aug 2006 12:34 PM - 17 messages
Hi, Does anybody know if xp_sendmail & xp_readmail still exist in new SS 2005? I cannot find any info about them in BOL 2005. Thanks in advance Nikola ...
Logins with '\' character inside created by CRM installation
WT -
9 Aug 2006 11:24 AM - 5 messages
Hello, I am searching how to use in osql scripts logins names containing '\' caharcter. Theses login are automatically created they contain a domain name fowwed by a group name. Thanks for help. CS ...
copy database error (finding folder, login timeout)
Matt Pallatt -
9 Aug 2006 9:06 AM - 5 messages
Hello, just got SQL Server 2005 installed on a new production box and am trying desperately to get data to it from an old SQL2000 production box - unfortunately for me each time i try to use the copy database tools in order ...
Code Coverage Tool
andrei_tapt -
9 Aug 2006 7:43 AM - 9 messages
I want to analyze what statemetns were executed in stored procedures, for example. I'm trying hard to find tools for sql code coverage while there are tons of such tools for Java or C#. I was able to find only : [link] but I want ...
Point in time restore - cannot change date
joe -
9 Aug 2006 4:43 AM - 5 messages
I am trying to roll back a SQL Server 2000 database to a previous point in time, but I am not allowed to select the date I want in the 'point in time' dialog - it always reverts back to the date of the transaction ...
Denormalizing a database table
alkkmrz2004 -
9 Aug 2006 1:43 AM - 2 messages
Folks, Any help with creating a SP that denormalizes the below table to the desired output will be appreciated. Current Input Table Structure: SNum KeyName KeyVal value 1 SCM1 name DFW ...
|
|||||||||||||||||||||||