|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
Unique backup names
cc900630 -
24 Sep 2005 3:12 PM - 3 messages
How do i modify the backup code to name the backup using the date/time tokens ? BACKUP DATABASE [MyDatabase] TO DISK = N'C:\Backups\'+[DATE] WITH NOINIT , NOUNLOAD , NAME = N'Mybackup', NOSKIP , STATS = 10, NOFORMAT ...
"cannot open user default database. Login failed"
Brent Stevenson -
24 Sep 2005 2:39 PM - 7 messages
When attempting to connect to my local instance of SQL server I am getting this error message: "cannot open user default database. Login failed". My OS is WinXp v2002 SP2. This issue started after I deleted a database on my local server, prior to that it was working fine. ...
Port changed but not working
amish -
24 Sep 2005 1:32 PM - 2 messages
I have changed default port from server network utility. But even now I can connect to my sqlserver with default port 1433. Is it due to named pipes or something old value referred from registry? Regards Amish ...
Urgent! How to reduce or control log file
Azhar -
24 Sep 2005 1:21 PM - 4 messages
Hi there, I am fixing network for one company, i have problems with dell PE2600, with RAID 5, drive D full up, 106GB drive, nearly 98GB being used by database folder, inside that folder log file is taking more than 60GB. now situation ...
TRANSFORM ... PIVOT as in Access
Herry B. -
24 Sep 2005 8:14 AM - 4 messages
I'm migrating my database from MS Access to MSDE or SQL Server, however when I tried to run a query with a statement of TRANSFORM <fieldname>... PIVOT <fieldname> as in Access, MSDE refused to execute it. Anyone know the ...
Optional params in a CLR sproc
Johnny -
23 Sep 2005 10:31 PM - 4 messages
Can someone tell me how I can flag some parameters as optional in a CLR sproc? I am developing a sproc in C# and can't find a way to make a parameter optional. In a T-SQL sproc, we simply declare as NULL to flag it as optional, as ...
Workaround for KB833045
Chris Wood -
23 Sep 2005 10:15 PM - 13 messages
Hi, The workaround involves creating registry values under HKLM\Software\Microsoft\MSSQLServer\MSSQLServer. One value is the number of retires the other is the wait interval. What is a good value for the wait interval? We don't want to go to SP4 or apply this hotfix just use the workaround for ...
Trigger / View problem
paros via SQLMonster.com -
23 Sep 2005 9:11 PM - 2 messages
How do check if a view (from a table) has been updated? When i insert data in a certain table, the view "person_View" gets updated. But how do I write the trigger below to understand that the "person_View" has been updated? ...
Horizontal partitioning - Problem with identity Col.
Nick via SQLMonster.com -
23 Sep 2005 8:27 PM - 4 messages
We have a very large table TABLE1. On this table Searches are taking longer time. We ran the index tuning wizard but there is not much room. We are tuning queries and store procs too. I’m searching for ideas. That can work for current situation. We are looking ...
I keep getting this error when i send a large document into sql server with ADO.NET System.Data.SqlC
Daniel -
23 Sep 2005 7:51 PM - 2 messages
I keep getting this error when i send a large document into sql server with ADO.NET System.Data.SqlClient.SqlException: XML parsing error: Not enough storage is available to complete this operation. I have about 8 gigs of memory on the machine and sql server isnt using even half of it. any way to ...
Can I install SQL 7 and MSDE on the same machine?
Ray -
23 Sep 2005 7:41 PM - 2 messages
Can I install SQL 7 and MSDE on the same machine? ...
Installing a Database
Nando_uy -
23 Sep 2005 7:31 PM - 2 messages
Hello all...I develop a Database in a Local Instance of a server. Then, I need to install ALL the New database in a remote server using TCP connection and, I have no idea how script them and how can I execute this ...
Appending two tables
Ranjit Charles -
23 Sep 2005 6:48 PM - 2 messages
I have 2 SQL tables that Ineed to combine (append). The column information in each table is exactly the same, except they are for different years (one is history and one is current year). I need to be able to create a view that has ...
SQL Agent job not being run after "Failed to retrieve job" error
dwaine -
23 Sep 2005 6:35 PM - 7 messages
I've been having this issue VERY infrequently, but often enough to become a problem. I've developed a system that generates SQL Agent jobs using a sproc (serially). Intermittently, sometime after a job is created, but well before ...
SQL Server 7
Andrew Madsen -
23 Sep 2005 6:15 PM - 6 messages
How much memory is SQL Server 7 capable of handling? If it is more than 2.7 GB what switches do I use to give it access to that memory? ...
locking question - hopefully a quick answer
Corey Bunch -
23 Sep 2005 5:33 PM - 3 messages
I've got two identical tables, Table A and Table B. Users are constantly entering data into Table A. I want to lock the data entry, move all the data cleanly from A to B, delete everything from table A, ...
Very high Disk activity
QZ -
23 Sep 2005 5:23 PM - 10 messages
Hi, We have 2 applications (one is Web app and the other Window Service), they both insert data into one database. We are doing load test after 2 days all of sudden the disk idle time went to 0%. This what we tried ...
IAM error?
jj -
23 Sep 2005 5:22 PM - 4 messages
I have gotten the following error a few times on just one database that I have: Table error: IAM page (1:511426) (object ID 2, index ID 255) is out of the range of this database. This error can only be fixed by running dbcc checkdb allow_data_loss. Can ...
Full text index functino not installed properly
CPLEV -
23 Sep 2005 5:11 PM - 2 messages
I recently upgraded a SQL server 7 installation to 2000 sp3a. This morning I need to enable full text indexing. I went through the installation process but the indexing options are not showing up. I tried a CLI and it told me ...
Connecting to a remote SQL Server
Sonya -
23 Sep 2005 5:00 PM - 4 messages
I am trying to connect to a SQL Server that is located in my home office from remote office location. I've tried to setup a connection using Enterprise Mgr, but it is not working. Can someone provide the steps if any to help? ...
question on recompiles
ChrisR -
23 Sep 2005 4:39 PM - 3 messages
On Monday I added a whole bunch of indexes. They were pretty much just indexes on foreign keys. Should I have recomiled all the sp's? Since I didn't, should I bother now? According to BOL: But if a new index is added from which the stored procedure might benefit, ...
Getting data from 2005 to 2003
Rik Brooks -
23 Sep 2005 3:21 PM - 3 messages
A consultant that we used built an application using sqlServer 2005. I need to move that data from one machine to another. We decided to move it back to 2003 because that's our 'official' version. I know that I can export the data into text files then ftp them over here ...
Linked Served - Dont' work for some query but work for others
Christian Hamel -
23 Sep 2005 3:03 PM - 3 messages
Hello. I'm having some problem with the linked server functionnality in SQL Server 2000. Here's my setup: Server SQL Server Standard 2000 SP3 (Let's call it ServerSTD) Server SQL Server Enterprise 2000 SP4 (Let's call it ServerENT) ...
Error 3123 in SQL Restore
Rowland Costin -
23 Sep 2005 2:28 PM - 5 messages
Trying to restore a database from a personal edition SQL 2000 to another PC. I get the following message The media set for database 'TeamSpiritDataTDB' has 2 family members but only 1 are provided. All members must be provided. ...
dbcc shrinkdb
stoney -
23 Sep 2005 2:27 PM - 12 messages
hi, I need to shring a SQL 2000 db by 50GB. Is it better to start sql in single user mode when doing such action? ...
64 Bit SQL server
MPatel -
23 Sep 2005 2:25 PM - 2 messages
Is it ok to run 32-bit sql server on 64-bit windows 2003 os? Is there performance improvement , same or decerase? Can I attach 64bit sql 2000 user database to 32bit sql 2000? Thanks for your help in advance. ...
Prfmon questions - Disks
rupart -
23 Sep 2005 12:11 PM - 8 messages
I am monitoring a disk which has SQL data. There are the counters i am monitoring AVg.Disk.Read.Q.Length AVg.Disk.Write.Q.Length Disk Reads/sec Disk Writes/sec Split IO/sec I have set all the scale to 1.0(how does this scale works?what is it ...
Link Server between Oracle and SQL Server error
Olivier TACKELS -
23 Sep 2005 11:30 AM - 4 messages
This message appears : "Error 7399: OLE DB provider 'MSDAORA' reported an error. OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: ]." My server is a Windows 2000 Server SP4, with SQLServer Enterprise SP3a. Oracle client 7.3.3.5.0 had been installed. When I use SQL Plus 3.3 (Little ...
Which is better here?
parasada -
23 Sep 2005 11:28 AM - 3 messages
Hi All, Pls forgive me for this BIG question. While fine tuning a query, I found from the plan that a join was taking quite a while, and I used ITW (Index Tuning Wizard) to suggest any new index and it came out with a NEW NC Index adding which the plan got changed to use ...
Restoring master db from old install of different SQL version
MANCPOLYMAN -
23 Sep 2005 11:18 AM - 2 messages
All, I had to downgrade from Enterprise to Standard on a server. So I took backups of all DB's, uninstalled enterprise and installed standard with SP3a. Then I restored all user DB's. I then wanted to use the master from enterprise and install into standard so ...
database restores - what actually happens?
John -
23 Sep 2005 10:56 AM - 2 messages
If you have a database with 2 data files and you do a restore will sql server fill one datafile first before starting on the second, or do both at the same time in parallel to balance the load? Anyone know any decent articles on what happens under the covers? ...
Slow query, but server not using available resources
SimonM -
23 Sep 2005 10:24 AM - 14 messages
I have a problem query that takes ages to run but the database server is only using a fraction of it's resources. I do have the option checked to boost SQL server's priority but it doesn't help? ...
Backup TRN file issue
Macchianera -
23 Sep 2005 9:49 AM - 2 messages
Hi at all, i'm new of this NG :=) My problem is that with SQL 2000 SERVER SP4 i plan the backup of db and trn but SQL doesn't delete the TRN files "older than x days" while it ...
Select qry is not working properly
K R Lal -
23 Sep 2005 7:37 AM - 3 messages
Hello, I am writing an sql qry for cursor function. the Select qry is not working properly. please check this and help me declare @m as varchar(20) declare @mm as varchar(400) set @m='r-01,r-002' set @m=char(39)+replace(@m,',',char(39)+', '+char(39))+char(39) ...
Please tell me Time Query
tomas -
23 Sep 2005 5:57 AM - 2 messages
add Two Time by Query I cann't speak English but I want to know that please help me Ex) AM 2:59 + AM 3 :30 = AM 6 : 29 ...
Use log shipping or replication
Robert Lie -
23 Sep 2005 4:01 AM - 3 messages
Dear All, Now i'm confusing to make up my mind. I have a reporting server, the server that is used just for reporting purposes. The data of reporting server is comes from OLTP Server. I want to minimize the latency of reporting server, so users can get the ...
Reduce the Size of SQL Log File
Diane Walker -
23 Sep 2005 2:43 AM - 4 messages
We have MS SQL 2000 Enterprise Edition, running on Windows 2000 Server. Is it a good idea to reduce the size of the SQL Log File? If it is, do I need to make sure no one is using the database while I am reducing the size of ...
Randomised Recordset!!
Adam Knight -
23 Sep 2005 2:06 AM - 2 messages
Hi all, I have a table of questions like follows: - question_id - area_id - question_text - question_index - question_type ('o','i','c') What i am after: I want to construct a query like that selects all questions with a question type = 'c' in random order. ...
high availability on SQL Server 2000
Bobsie -
23 Sep 2005 1:43 AM - 5 messages
We have a failover cluster that gives our SQL Server environment really great availability - each upgrade we do on Windows or SQL Server requires a SQL restart or a Windows reboot which only affects the uptime for a moment. A ...
Database Status = Loading
SJ -
23 Sep 2005 12:11 AM - 4 messages
A coworker is repeatedly experiencing problems restoring database backups on a new sql virtual server (clustered). He has restored a database backup using enterprise manager. Enterprise manager told him that the restore has completed without giving any errors. We can not access the database and ...
SNMP broken in SQL2000sp4
Craig Humphrey -
22 Sep 2005 10:56 PM - 5 messages
Hi People, I've been running around the various threads in this and other groups, looking at how to install SNMP monitoring for SQL2000 and how people are finding it broken. I was wondering if this issue will ever be fixed by Microsoft? ...
EM running really slow
A.B. -
22 Sep 2005 9:59 PM - 8 messages
My EM and QA have started to run really slowly have have tried to find the problem but I cannot seem to find it. Does anybody have any suggestions on where to look to solve this problem? Thanks ...
DB Maintenance optimization-reorganize data and index pages
mitra -
22 Sep 2005 9:47 PM - 2 messages
Hello, I read in Books Online that the DB Maintenance plan optimization option (reorganzie data and index pages) rebuilds all indexes by dropping and recreating them. Is this the same exact operation as dbcc dbreindex? If yes, then I am assuming our database is not going to be available during database ...
Client License Question - SQL and Server
Sherpa -
22 Sep 2005 8:58 PM - 4 messages
If I'm running a Legato Co-Standby or CA Brightstor failover setup, where only one server is accepting connections at a time. Do I need to purchase a full count of SQL and Server client licenses for both servers. ...
Backup job
docsql -
22 Sep 2005 8:54 PM - 4 messages
Trung to modify a db backup job. I get the following message. [attached file: Doc2.doc] ...
disabling awe
ritta via SQLMonster.com -
22 Sep 2005 8:00 PM - 2 messages
hi, I've disabled AWE in a server using : sp_configure 'awe enabled', 0 RECONFIGURE GO The server has 4G in RAM, after disabling AWE ¿ how much is it ? 2 Gor 3G ?, ¿ Where could I see it ? I think I have to delete from boot.ini the "/3GB", how could I check that AWE ...
COMP.DATABASES.MS-SQLSERVER - Outlook Express
Jerry Spivey -
22 Sep 2005 7:42 PM - 4 messages
Hi, Can the comp.databases.ms-sqlserver newsgroup be added to Outlook Express? If so what is the connection information? Thanks Jerry ...
First(), Last(0 function
Scott Elgram -
22 Sep 2005 7:38 PM - 4 messages
Hello, I have this query in access and I woul like to convert it to SQL. ------------------------------ SELECT KEYC.ProvID, Last(DIMAGE.ID) AS LastOfID FROM DIMAGE INNER JOIN KEYC ON DIMAGE.ProvID = KEYC.ProvID WHERE (((KEYC.PlanID)=10072 Or (KEYC.PlanID)=10125) AND ...
Database not showing up in Enterprise manager
John Jasper -
22 Sep 2005 6:21 PM - 2 messages
Help! When I open up my enterprise manager I am missing one of my large databases ! I get errors like : "Overlapped I/O operation is in progress...." and "error at log record .... etc" Any way to get my database back !?! ...
Databases Only
EddieB -
22 Sep 2005 6:17 PM - 7 messages
Hello, I know to you this seems like a stupid question but I can get some microsoft article that proves my point I feel our department is going to make a big mistake. We have an administrator (help desk supervisor) who wants to put an ...
copying database
Jon -
22 Sep 2005 6:15 PM - 6 messages
Twice a month we need to take a copy/snapshot of an existing DB on server 1 and place it on a server 2. Each copy/snapshot can overwrite the pre-existing database on server 2. Right now we are doing this manually with ...
why an Index scan???
ChrisR -
22 Sep 2005 5:56 PM - 16 messages
sql2k sp3 select distinct questions.element_id, element.element_name from questions, element, reads, error where element.element_id = questions.element_id and questions.question_id = error.question_id and error.error_ma = 1 and error.read_id = reads.read_id I have an index on read.read_id but Im getting a scan of 250k records. What ...
Register Multiple Servers in Enterprise Manager
brimhj -
22 Sep 2005 5:51 PM - 5 messages
I am looking for a way to register several hundred SQL Servers/Instances in Enterprise manager without having to do them one by one. Does anybody know of a way to do this? Doing this via VBScript would be nice. ...
(NOLOCK) and Linked Servers
PButler via SQLMonster.com -
22 Sep 2005 4:46 PM - 5 messages
I know that you can't have an optimizer hint when running an ad-hoc query from another server. My question is why? What prevents it from using the hint? ...
Database Maintenance Plan
natas234 -
22 Sep 2005 4:36 PM - 3 messages
A previous employee created the plan t0 back up TRN and BAK files. When the previous employees account is removed I get an event log that the TRN backup failed because it could not verify that the previous users ID had access to backup point. In the Enterprise Manager I see ...
Drops in performance
Steve Drake -
22 Sep 2005 4:30 PM - 5 messages
All, I am doing some throughput tests of an application we have written, with data updates we get very good through put but ever 100 seconds it drops to 0. The test are using our API and I have run them simultaneously on 2 servers, ...
length of text in row in table
greg -
22 Sep 2005 4:00 PM - 7 messages
hello, we are using a third party issue management system. On the back end it uses SQL 200 sp3. it has different tables for different types of documents (issue, sir, rick, etc...) and columns for properties on the documents (created by, assigned ...
Reporting Services
Zean Smith -
22 Sep 2005 3:52 PM - 2 messages
In Microsoft Reporting Services, anyone knows how to put 2 reports (different queries) into one big report? Thanks.. ...
sp_recompile in profiler
james -
22 Sep 2005 3:50 PM - 3 messages
When I execute any stored procedure with "with recompile" option, the profiler event "SP recompile" doesnt capture it. Same is true if the procedure was created with "with recompile" option or if I forced to recompile through sp_recompile stored procedure. In all of above cases, ...
Backup MS SQL server database to sql script
Greg -
22 Sep 2005 2:42 PM - 3 messages
I'm searching a tool to make backup of MS SQL SERver 2000 Database to sql script (with inserts). Do yoy know any tool to it ? ...
Maintenance Plan/Backup Question
Don Delk -
22 Sep 2005 2:31 PM - 3 messages
I'm having a problem on a remote server with what I think is a Maintenance Plan that seems to be doing an endless backup. My db is about 3GB, the backup file (.bak) of the database keeps growing and eventually will exceed ...
AVG of integer column returns integers result - newbie
Craig -
22 Sep 2005 2:24 PM - 3 messages
I am averaging integer columns, the result is integer not real or decimal How do I get aroung this? SELECT AVG(AmpReading) FROM tblChillWaterSystems GROUP BY LocationID, SystemID ...
A simple INSERT Problem
Rick -
22 Sep 2005 2:24 PM - 5 messages
Dev Tool: VB6 Server: SQL Server 2000. Environment: Windows 2000/Windows XP/Windows 2000 Server I have changed a user connectivity from WINDOWS NT trusted connection to SQL Server Authentication. I have granted the same permissions to the new user. ...
Is it able to add another instant without using the CD to setup again?
Fanjiu -
22 Sep 2005 2:15 PM - 3 messages
Is there any way to add the instant in the Enterprise Manager? Thank you! ...
AWE and Memory Configuration
Fraz -
22 Sep 2005 1:32 PM - 5 messages
We have a database server running Windows 2000 Advanced Server and SQL 2000 Enterprise with 4 CPU and 8MB of memory. PAE has been configured in boot.ini. AWE has been enabled and 5120 MB of memory allocated to SQL Server default ...
why does comparing intergers fail ?
John Jasper -
22 Sep 2005 1:30 PM - 5 messages
I have 2 fields of type "int" I want to add them together and compare them to another field of type "int"..... but... when I have a have the 3 feilds like this - they don't seem to acknowledge that they are equal: ...
Date format change in the server
VBB -
22 Sep 2005 1:21 PM - 4 messages
Hi, Can anyone help me to solve this query regarding Date format in SQL Server Is it possible to change the Date format in the SQL Database server. Is this dependent upon the system date settings in the Control Panel. ...
Snap backup and restore
CGW -
22 Sep 2005 1:06 PM - 5 messages
We are considering a scheme of snapshot backups. I understand that if we start our logging as soon as the system is backup after the snapshot and then backup the log, it would be possible to restore from the log, after restoring ...
sql server crashed and take torn page error
Sabri AKIN -
22 Sep 2005 12:53 PM - 4 messages
our sqlserver has crashed and try to attach mdf file to server but sql server open this database in read only mode.when we execute "select" query we take "torn page error".how can i repair this database or rescue all datas. ...
Windows NT autentication vs. SQL Server
Rick -
22 Sep 2005 12:44 PM - 3 messages
Hi, all: Dev Tool: VB6 Server: SQL Server 2000. Environment: Windows 2000/Windows XP/Windows 2000 Server I had an ADO conection to the from a VB Application, wtih this connection the user could Write/Read data from server and execute stored procedures. ...
Clustered Index
Wes -
22 Sep 2005 12:39 PM - 5 messages
I want a clustered index on a field in a table that is not currently apart of the primary key. Should I alter the table and recreate the primary key as non clustered and then create a new clustered index on the mentioned field? ...
Can we just backup/restore the tables of a DataBase
ad -
22 Sep 2005 12:24 PM - 6 messages
I just wnat to backup/restore the tables parts of a database, and the StoreProcedure and functions reamain unchange. How can we just backup/restore the tables of a DataBase? ...
Windows 2003 SP1 with SQL Server 2000 SP4
Jon -
22 Sep 2005 12:19 PM - 2 messages
Are ther any compatability problems with Windows 2k3 SP1 and SQL 2000 SP4? Anyone got any experience of running the 2 together? Any info. would be welcome for both standard servers and clustered servers. Thanks ...
What's the best way to setup a SQL Server 2000 for failover
immes -
22 Sep 2005 11:50 AM - 4 messages
Hi all, I want to setup a second Server (with SQL 2000) as a backup for my first one. I case of failure I want to be able to manually switch to the backup server (which must have as much actual data as possible < 5 sec latency) ...
Re-indexing table causes Windows to re-boot !
Griff -
22 Sep 2005 10:29 AM - 7 messages
I have a DB with multiple tables and when I attempt to index one of the tables the whole Windows servers crashes and reboots. My understanding is that SQLServer should run as an isolated application and so should not be ...
SQL Server Clustering - Active/Active Split DB's
NWeller -
22 Sep 2005 10:27 AM - 4 messages
We have a system that is currently running in Active/Passive mode. I have been asked to find out if it is possible to change the cluster to Active/Active but have different databases active on each node of the cluster. ...
How can I import txt files using fdf field info ???
Jim Cook -
22 Sep 2005 9:52 AM - 3 messages
I have many ca. 1-5 Gb fixed field width txt files to import into a SQL Server database. They were apparently exported from SAP, and each came with a corresponding fdf file that lists the field layout information ... ...
Can I get back the deleted records
Daryl -
22 Sep 2005 7:10 AM - 2 messages
Dear All, If I used a SQL command "Delete" to delete for example 1000 records, can I get it back after? It is because I executed the delete command and later found out I need some records back. Thank you for your help. ...
Questions about DB-maintenance
Tim Skau -
22 Sep 2005 6:57 AM - 4 messages
Hello. I have setup a Db-maintenance plan as job on our SqlServer 2000 std ed. The database file is approx. 8 GB. When I start this job, the job just goes on "forever" - last night it took 2 hours, and it still wasn't finished. ...
2nd Node Couldnt join existing cluster
rupart -
22 Sep 2005 12:04 AM - 11 messages
Guys I have a cluster running on single node and i am trying to add the 2nd node but getting this error. Any idea? I am using external EMC storage for the physical disks. The only different i could see is, in node 1, the mapping of disks in disk ...
Replacing all occurrences of a string in a VARCHAR column??
MittyKom -
21 Sep 2005 10:46 PM - 2 messages
Hi All I have table Tab1 with a column Col1 of data type VARCHAR. I want to replace every "Kop " string in that column with "HY". Is there an easy way to do this. Below is an example with column Col1 with 2 rows of data: ...
Tlog Backups and Full Database backups at the same time
GG -
21 Sep 2005 9:10 PM - 4 messages
HI, We take Full Database backups everyday at 7:00PM and Tlog backups every hour. So, while the Full DB backups are running will the Tlog backups for that hour be skipped. Eventhough we have setup Tlogs to ...
Undo a Hotfix?
A.B. -
21 Sep 2005 8:45 PM - 2 messages
Is it possible to undo a hotfix? By undo I mean return the instance to the state it was before the hotfix but keep all the data that has been entered since the hotfix. ...
how to remove login that was dbo of an object
Dan D. -
21 Sep 2005 7:58 PM - 5 messages
I saw a login that was in the sysadmin role and shouldn't have been. When I went to the database access tab under properties for the login, each database had "dbo" in the user column. I couldn't change it so I removed the login and ...
Index related problems?? Whats happening here?
MasterNone -
21 Sep 2005 7:52 PM - 4 messages
All queries for a particular table seems to be slow. It has one clustered index on the primary key column which of data type INT and has identity insert ON. This table has < 10000 rows and is fast with ...
Best Strategy to backup the system db
Pooja -
21 Sep 2005 7:48 PM - 2 messages
Hi, I am trying to approach method to copy my system database using enterprise tool. I have researched on Database Mainteance tool and Backup database. I would like to use one of the method to copy my database without any ...
Timeout using date variables
JuiceWeasel -
21 Sep 2005 7:31 PM - 12 messages
I'm running a fairly complicated/large query in sql server. The query limits the data based on a date range, but I'm having trouble with it. If I limit it to be between two constant dates, then it runs fine. If I run it using ...
Excel XP and SQL Server... a good match?
Rick -
21 Sep 2005 7:20 PM - 3 messages
Suppose I have an appliation made in VB6 which connects to SQL2000. The applications creates a DSN(old style) to connecto to the server. The user has a login an a password to use the application. The server validades Windows NT login. ...
MSSQL 2000 authentication problem.Please help, it is really interesting.
Djangar S. -
21 Sep 2005 7:11 PM - 6 messages
Explanation: After attaching MSSQL 2000 SP3 server into domain, Local Admin and SA cannot login into MSSQL EM and QA are not working. Even Local Admin cannot do it. But MSSQL is running, I have another applications witch constantly using SQL Server (authentication by sql). ...
Consistency errors/repair_all_data_loss question
nmsm -
21 Sep 2005 6:51 PM - 2 messages
I've been receiving consistency errors for the past few weeks whenever the indexes on 1 table are rebuilt (which they are each evening). I restored the production database to our development server and ran DBCC CHECKDB and DBREINDEX to confirm that the errors ...
memory and instances
Rich -
21 Sep 2005 6:49 PM - 5 messages
Hello Community, new to SQL Server. Our company has four instances of SQL Server on one server. Our memry used is left to dynamic allocation. Do I get any performance gains by adding more memory beyond the 2Gig limit? I understand ...
Dedicated Database Connection
newie -
21 Sep 2005 6:47 PM - 3 messages
We are looking at ways to optimize our process for retrieving primary keys. Currently, we are creating a new database call to get each ID we need. We are considering the idea of keeping a database connection open with a single ...
Backup Issue
b_dba -
21 Sep 2005 6:11 PM - 5 messages
My transaction log backup using the maintanance plan is failing with following error message in the sql error log. Has anybody seen this before and found a resolution. I have checked and ensured that the CPU has adquete resources/memory to carry out the operation. Any suggestion would be higly ...
Blocking
Arne -
21 Sep 2005 6:11 PM - 3 messages
Have have process that blocks each other in SQL 7.0. How do I nuke these processes? ...
Back Issue
b_dba -
21 Sep 2005 5:59 PM - 2 messages
Following is my log file for transaction log backup via DB maintainance plan. The step 2 of the process fails due to the reason mentioned. I can try omitting the verify backup step in the plan, however wanted to know if anybody has come accross this before and found a solution. ...
Split the data into two files
VM -
21 Sep 2005 5:22 PM - 7 messages
Hi, We have one database of 45 Gig in size and it is in one datafile. I would like to split the data that is in one datafile(.mdf) into two data files, i.e., one .mdf file and .ndf file. What is the best way of splitting the ...
message in sql server error log
Eli Milkova -
21 Sep 2005 5:02 PM - 11 messages
What can cause the message "Login failed for user 'DOMAIN\COMPUTER$' " every 20 sec? the instance is Standard SQL server 2000 with mixed security mode and sql server service accout is domain admin member. The application that use database is working fine but out error log fills up very fast. I will ...
Single quote in identifier in stored procedure
Gaideah -
21 Sep 2005 3:53 PM - 4 messages
If I use a store procedure and pass a string with a single quote like O'Reilly do I have to escape the single quote before I pass the string to the stored procedure? Example: CREATE PROCEDURE dbo.usp_save_user ...
Rename Server
Diane Walker -
21 Sep 2005 3:36 PM - 23 messages
We are running MS SQL 2000 Enterprise Edition under Windows 2003 Standard Edition. We need to change the server name and IP address. Will there be any problem of accessing the existing database? Thanks. ...
am I reading this right?
ChrisR -
21 Sep 2005 3:08 PM - 2 messages
When I see this in my Maintenance Plan job: EXECUTE master.dbo.xp_sqlmaint N'-PlanID C8270137-357F-4781-BFB8-CF86BE6A80B5 -WriteHistory -RebldIdx 10 ' I think that means a Fill Factor of 90%, leaving 10% free. Is that correct? It could mean a FF of 10, but thats not the way Im reading it. ...
|
|||||||||||||||||||||||