Home All Groups Group Topic Archive Search About

Microsoft SQL Server Administration

microsoft.public.sqlserver.server
Score SQL Server 2000 issue
spitapps - 9 Sep 2006 11:38 PM - 2 messages
I have webspace running on a machine with IP address 82.165.206.115 through 1and1.com.  Then I have an internal server running on my network which is running SQL Server 2000.  I have yet to be able to ...
Score Jump to next record insertion.
bsheikh - 9 Sep 2006 8:48 PM - 2 messages
Hi Fellows, I am trying to update some records  for simplicity my table is as follow ProgId        PrgOccur          UPC CircD          100                   235689748965 ...
Score Backup of Stored Procedures
3451Jack329 - 9 Sep 2006 7:09 PM - 3 messages
How can I backup all the stored procedures from my SQL Server db to all .sql files? ...
Score Backup issue: Transaction & Differential
KTN - 9 Sep 2006 2:38 PM - 13 messages
I have a backup schedule to do transaction log every hour and it fails quite often latetly.  In order to have a continuous backup, I have to perform differential in between which is not part of the backup plan.   The error I ...
Score Data Acess aplication block
Mukesh - 9 Sep 2006 1:08 PM - 5 messages
Hi I have  Microsoft Enterprise Library 2005  installed on my local system. I m also using ASp.net 1.1 And C3 as coding language , I have MS Sql Server 2000. I am developing a web application in which i am using  data Access ...
Score drop out of stored procedure when found some data
shard - 9 Sep 2006 10:35 AM - 3 messages
Hi   I have a stored procedure which takes a while to run and returns some data. I want to make another version that just says is there some data to look at (boolean, yes no). This should run as quickly as possible so as soon as it finds theres any data to ...
Score Alter Seed value of Identity column
Prasad - 9 Sep 2006 5:42 AM - 3 messages
Hi,     I want to create temporary table, say "a" which has  a column say "col1" which i wnt to be an identity for which I need to provide a seed value.     I tried the following ...
Score MSSQ server service (widnows service) account configuration --
Kumar - 8 Sep 2006 11:38 PM - 2 messages
Hi Folks, We have some inhouse applications developed using microsoft technologies like C#.net,asp.net  and sql server 2000  and we have third party applications using sql server 2000. In all our sql servers we configured as below. ...
Score is it a good idea to keep sql server with mail server on single T1
bharat - 8 Sep 2006 11:05 PM - 4 messages
hello everyone!!!!!!!! I just wanted to know is it a good idea to keep both mail and databse server on same T1.if yes then plz tell me why. Waiting for yr help.if you could have any documentation on this plz let me ...
Score Removing Logins from Server and Databases
dotNetDave - 8 Sep 2006 10:52 PM - 4 messages
Is there any way to remove logins from the server and all related databases in including all roles in the databases? Thanks, David ====================================== David McCarter [link] VSDN Tips & Tricks .NET Coding Standards available at: [link] ...
Score SQL
Mik - 8 Sep 2006 7:47 PM - 2 messages
Would someone review my plan of action:  THANKS!! I have SQL Server 2000 Enterprise running on Windows 2003 Enterprise (32bit) in an MSCS 2 node active/passive cluster.  Both computers will have 6GB of memory each.  I'm going to perform the following 3 steps: ...
Score bug of synonym ??
bajopalabra - 8 Sep 2006 6:50 PM - 4 messages
hi the clause : EXEC mySy works when i create the synonym by : create synonym mySy for [database].[schema].[storedProc] but fails when i create it by : create synonym mySy for [SERVER_NAME].[database].[schema].[storedProc] anybody knows WHY  ? ??? THANKS ...
Score Attempting to restore a db from a network drive and use the 'with move' statement
war_wheelan - 8 Sep 2006 5:35 PM - 3 messages
Attempting to restore a db from a network drive and need to move the log file to a new location.  CAN SOMEONE PLEAS REVIEW THE STATEMENTS AND ERROR MESSAGES AND LET ME KNOW WHAT I AM DOING WRONG. Here is the script that I am using for this procedure ...
Score Tostring() cannot make it work
Mike - 8 Sep 2006 5:12 PM - 4 messages
I have SQL Server 2000 on a laptop I am Trying to use .ToString like in: select ID, Label.ToString() from TblLabels where .... I get the message: Invalid object name 'Label.tostring'. What is wrong, my SQL server doesn't seems to recognize this ".Tostring()", ...
Score Oracle linked Server invalid Book mark error
Suriya Prakash - 8 Sep 2006 4:16 PM - 4 messages
Hi,           I am connecting oracle through the linked server from SQL server 2000.I am able to access oracle data using OPENQUERY method. But Whenever i Use a direct quiery say ...
Score 2005 issues with BinaryWrite??
E L - 8 Sep 2006 3:41 PM - 2 messages
I have moved over some data from 2000 to SQL 2005.  The data is the same, but now some existing working code is not working with the BinaryWrite method of Response.BinaryWrite in an ASP page. In a field in a table that is ntext. It contains HTML data tags. ie. ...
Score Non-Yielding on Scheduler 1
Sid - 8 Sep 2006 3:27 PM - 2 messages
I'm receiving the following error on SQL Server 2000 SP4 (no additional hotfixes after SP4 have been installed.) Process 78:6 (e70) UMS Context 0x06485810 appears to be non-yielding on Scheduler 1. Following this message I receive the follow message ...
Score Any issues with 2005 SP1?
Michael MacGregor - 8 Sep 2006 3:15 PM - 5 messages
Does anyone know of any major, or indeed minor, issues with installing SP1 for SQL 2005? Michael MacGregor Database Architect ...
Score Help Me read the data collected from Trace Flag 1204
msqldba via SQLMonster.com - 8 Sep 2006 2:39 PM - 2 messages
Here is the data i got...from trace flag 1204..Could you guys help me read this..like understand which is the problem child and which one is chosen as a victim any thing that helps me to understand this.. ...
Score SQL Server Express
mjv - 8 Sep 2006 2:29 PM - 3 messages
Can I install SQL Server Express on a Windows 2003 server that has SQL 2000 already on it? ...
Score Problem migrating SQL Server 2000 database to 2005
OD - 8 Sep 2006 2:06 PM - 5 messages
I have an application that is running on Windows server 2003 and SQL 2000 Server. This application was written in VB so it has both windows client interface and Web client interface. Due to the age of this server we ...
Score Issues with Transaction Log backups
Saral6978 - 8 Sep 2006 1:21 PM - 7 messages
I'm pretty new to SQL, and am running into a problem.  I had setup a Maintenance plan on one of my databases and the Transaction Log Backups are not working.  I'm not getting any feedback in the error on why they are not ...
Score How to switch identity within stored procedure
Shilpa - 8 Sep 2006 12:40 PM - 3 messages
I want dynamically created views by one user get viewed by other users. These users will not know who has created the view. To make this possible I am trying to write a procedure which will switch identity of user to dbo and then create a view and again restore original ...
Score Trigger
IndyChris - 8 Sep 2006 11:45 AM - 4 messages
I'm attempting to create a trigger on SQL Server 2005 that executes an assembly. When a new row is inserted into a table, I want to send an email out. Creating the assembly was hard enough, now I'm having ...
Score Alter table problems (transaction log will growth to 60 Gb...)
Major - 8 Sep 2006 6:40 AM - 7 messages
I have a large table, and I try alter one column: ALTER TABLE TABLE_NAME ALTER COLUMN COLUMN_NAME DECIMAL (15,9) The transaction log will growth to 60 Gb, and then I haven't any more disk space avalable. Does the SQL server have any parameter like NOLOGGING ...
Score Sysperfinfo counter values
cbrichards via SQLMonster.com - 8 Sep 2006 4:47 AM - 2 messages
I am trying to wrap my mind around the counter values returned from master. sysperfinfo. For example, the object/counter SQLServer:Databases Transactions/sec. This value is cumulative. So if sampling 1 were taken were taken on October 1, 2006 at 11:30 am and the counter value was 9,000, and sampling 2 was taken ...
Score SQL Server and Analysis Services on same server, how much RAM ?
krislioe - 8 Sep 2006 2:15 AM - 5 messages
Hi All, We are running OLTP and OLAP on same box, SQL Server 2000 Standard Edition on win server 2003. There are 70 OLTP users and 5 OLAP user using Crystal Analysis Services. ETL and Process Cube is done during lunch time. ...
Score Persistent Database Corruption
Joshua Andrews - 8 Sep 2006 1:12 AM - 4 messages
I am having an issue with persistent database corruption when copying databases between instances. We have a production system with an 8GB (or so) database that I copy over to our test systems on a regular basis. A DBCC CHECKDB on this production database reports no issues. After ...
Score SQL Error 823: I/O error 64
Aaron - 8 Sep 2006 12:54 AM - 9 messages
We are running SQL Server 2003 on a Windows Server 2003 for SBS. We have created a database and everything seems to be working fine. However, once the server is rebooted and go to the database in Enterprise Manager we get the following error we trying to access the ...
Score scheduling question for SQL Server agent job for 1/1,4/1,7/1,10,1
Paul - 7 Sep 2006 10:53 PM - 5 messages
HI I am executing a stored procedure from a job using the server agent but can not create the correct run times.   I only want it to run 4 times a year, the morning of 1/1,4/1,7/1 and 10/1 for each year.  Anyhow just wondering if ...
Score Linked Server - AS400 - Missing Data
Denny - 7 Sep 2006 10:34 PM - 2 messages
I set up a linked server from SQL to an AS400 and it connects ok, but does not return all data.  For example, if the as400 file has 1059 records, it returns 1001,  if it has 4080, it will return 4004, and so on.  The ODBC ...
Score Memory allocation SQL 2000 SP3 vs SQL 2000 SP4
Pete - 7 Sep 2006 10:02 PM - 2 messages
Hi, I was wondering if the memory allocation between SQL 2000 SP3 and SP4 is different? Since last week I was running SQL 2000 SP3 Enterprise on a Windows 2000 Enterprise server with 4,5GB of RAM.  The /PAE /3GB setting is enabled in the ...
Score Is there a way to monitor % used of data file and log file in sql
Iter - 7 Sep 2006 9:59 PM - 2 messages
Is there a way to monitor % used of data files and log files in sql server 2000? ...
Score Short Date to String
Aaron - 7 Sep 2006 9:00 PM - 3 messages
I have a field in my database that is a date type, but sometimes I need to retrieve it a string.  Right now, I use this: ISNULL(CAST(Shippers.LastActive AS varchar(50)), '') AS strLastActive Which will return something like this: ...
Score Windows 2003 Standard and SQL 2000 Enterprise
Hassan - 7 Sep 2006 8:58 PM - 2 messages
Can I have 8 GB of RAM ? Or is there a max limitation of 4GB bcos I have Windows 2003 Standard Edition ? Thanks ...
Score About trace flag 8588
Iter - 7 Sep 2006 8:28 PM - 3 messages
Hi Guys, I got an error about trace flag 8588, Error 8526 Level 16: Cannot go remote while the session is enlisted in a distributed transaction that has an active savepoint. I setup two sql server 2000 in two windows 2003 server, both ...
Score TOP 10 for each group
MS User - 7 Sep 2006 7:48 PM - 11 messages
SQL 2K I got a table 'Sales' with columns CompanyID Deptid ChrgAmt Load I want to generate a report with Top 10 Deptid (in terms of ChrgAmt, Load) for each CompanyID. Thanks for your time. Mike ...
Score Lock Information
Paul H - 7 Sep 2006 4:39 PM - 6 messages
I need some help in interpreting the information displayed under Management -> Current Activity -> Locks / Process ID in Enterprise Manager. There seems to be a number of locks against the "Water.dbo.sched_lock" object. The values in the Index column are different for the different ...
Score Missing Data
Bulent Yazici - 7 Sep 2006 4:09 PM - 4 messages
Hello Everyone, Yesterday, I noticed that about 24 entires were missing from one of my tables. This table has been in existence in SQL Server for about 3 years now and only has 190 entries. It lists all the partners for our website and only ...
Score union 2 tables
greg - 7 Sep 2006 3:31 PM - 4 messages
Hello, I have 2 tables.  T1 and T2. Each table has an ID column. T1 has a column count. I would like to add up the count columns.  but only for rows that are in the T2 table. ...
Score Connecting to SQL Server via MS Access-Issue
PDavies - 7 Sep 2006 3:29 PM - 2 messages
We have a user who can connect via link tables to sql to one database oak.  On the other database (which he has exact same permissions) he gets timeout message (ODBC Call Failed).  He can oly see one table in link tables with the ...
Score Truncating the end of a datafile. How do I find what object is at the end of the file?
Paul Cahill - 7 Sep 2006 3:03 PM - 5 messages
One of our people has very kindly cleared out a number of huge, dead tables. I'd like to knock the end of the data file without moving the datapages (we are log shipping with litespeed across a wan). I know I have 20GB free in the datafile but it will not truncate. I assume ...
Score permissions to run start and stop jobs
Dan D. - 7 Sep 2006 2:42 PM - 7 messages
Using SS2000 SP4. I have a user who is able to start and stop jobs. The user only has db_owner permissions in a few databases. Should someone who is in the db_owner role be able to start and stop jobs or run dts packages? ...
Score Column troubles
Rune Thandy via SQLMonster.com - 7 Sep 2006 1:26 PM - 2 messages
I've got a table which goes something like this: id          usertext1        usertext2       usertext3     label1    label2 ...
Score Parallel Database Backup
Mahesh - 7 Sep 2006 1:21 PM - 4 messages
Hi, We maintain master data in DB1 and transaction data in DB2. now we wants to take backup of two databases(DB1 and DB2) parallely to avoid inconsistency. Thanks in advance Regards MahesH ...
Score Problem with connecting to Named instances of SQL Server 2005.
SQLCatz - 7 Sep 2006 12:15 PM - 2 messages
Current setup. [Machine01]. Windows Server 2003. SQL Server 2005 Standard Edition - 1 default + 2 Named instances. [Machine02]. Windows Server 2003. Created DSN to connect to Machine01.DefaultInstance - Worked. Created DSN to connect to Machine01.NamedInstance01 - Worked. Created DSN to connect to Machine01.NamedInstance02 - Worked. ...
Score backward compatibility (2000->2005)
Malin Davidsson - 7 Sep 2006 11:49 AM - 4 messages
Hi! I have heard that it's not possible to use (for example) *= as a join in SQL Server 2005 and now I have tried to find other things that I can't use. Does anyone know where I can find this? ...
Score Opening Solution clears previous queries in SSMS
Catadmin - 7 Sep 2006 10:39 AM - 8 messages
Yikes! Does anyone know of a way that I can open a solution but keep my current query windows open?  Every time I go to File -> Open -> Project/Solution, it kills any query windows I was working in. ...
Score Excessive Paging During Memory Release
Nick Colebourn - 7 Sep 2006 9:33 AM - 5 messages
Hi All,        I'm running a twin processor dual core box with 12GB RAM and approx 1TB of attached storage. The server is 64bit (x64) and SQL is set to dynamically manage memory, with an upper limit of 8GB and a zero lower limit ...
Score Restoring Master Database
Fredrik - 7 Sep 2006 7:11 AM - 3 messages
Hi ! I'm about to move a SQL Server installation to a new server. Is using backup/restore to move all databases. Both servers is SQL Server 2000 with SP4. I have read all books online topics about this (and I have done this kind of ...
Score collation on nchar column
Rea - 7 Sep 2006 6:54 AM - 2 messages
Hey eb Whats the point in having a collation attached to a unicode charecter typed column?? If you want to set a specific collation to character data, why make it unicode on the first place?? Am I missing something here?? ...
Score Error Message
Prasad - 7 Sep 2006 4:57 AM - 5 messages
Hi,     Is there any way to get the error message within a stored procedure. I have to store the SQL Server error message in a table.     TIA Thanks P ...
Score what causes an orphaned connection ?
Hassan - 7 Sep 2006 3:10 AM - 3 messages
Of late, i have seen certain apps leave behind orphaned connections and as a result the respective resources such as locks,etc. We end up manually going and killing the spid. So my question, what causes is it and why ? Why does SQL server loose its ...
Score round function
clemlau - 7 Sep 2006 1:08 AM - 7 messages
Can anyone reproduce this with sql 2005? SELECT ROUND(95.99, -1) returns: An error occurred while executing batch. Error message is: Arithmetic Overflow. if you try it with anything less than 95 it works.  It errors out any ...
Score AWE and Max Server Memory (MB)
cbrichards via SQLMonster.com - 6 Sep 2006 10:49 PM - 3 messages
What purpose does Max Server Memory (MB) serve, if I have 8 GB of RAM: 1. I have the switch properly set in the boot.ini 2. AWE Enabled is set to 1 3. Max Server Memory (MB) set to 2147483647 ...
Score Best way to insert data into tables without primary keys
tom c - 6 Sep 2006 10:06 PM - 3 messages
I am working on a SQL Server database in which there are no primary keys set on the tables.  I can tell what they are using for a key.  It is usually named ID, has a data type of int and does not allow nulls. ...
Score Maintenance Plan will not run
Jodi Venneri - 6 Sep 2006 9:33 PM - 2 messages
With SQL Server 2000 I can set up my maintenance plan but it will not run.  No log files are created. There are no indications what so ever about why the plan will not run.  Another SQL Server 2000 will run maintenance plans fine.  ...
Score 'master..xp_smtp_SendMail'.
tootsuite - 6 Sep 2006 9:19 PM - 5 messages
Hi, What is the SQL Server 2005 version of: 'master..xp_smtp_SendMail'. Apparently, this sp does not exist in 2005 - and causes our job to fail. Thank you ...
Score compare two columns for each row of resultset
bihoode - 6 Sep 2006 9:04 PM - 4 messages
Hi ,       I have a result set including two columns , I must compare two columns       and put the larger number in another columns. I can use a loop ,       but I that's too slow on large datasets so I need something like ...
Score Differential backups failing regularly
tootsuite - 6 Sep 2006 9:02 PM - 6 messages
Hi, Don't know what the problem is here. We are running a clustered instance of SQL Server 2005 on Windows 2003 - the backups are being written to a location on a SAN. Here is the error message: [SQLSTATE 40001] (Error 1205)  Could not insert a backup or restore ...
Score Backup Plan
George Schneider - 6 Sep 2006 8:28 PM - 17 messages
I have been using enterprise manager to run backups.  I backup up all the db's system and user under one maitenance plan.  I have it set to remove the bakups after 7 days.  The backups are removed but not the tranaction log ...
Score Been a DBA for too long.. want to get into DB Design and modelling
Hassan - 6 Sep 2006 8:19 PM - 2 messages
I have been a DBA for a while now and while doing that, i've never got my feet wet in say development nor into database design and modelling. Can someone tell me if there are any courses,etc. out there that i can take ...
Score Logging an Error During a Transaction
Sal - 6 Sep 2006 7:48 PM - 11 messages
Hi: If an error occurs in a transaction, I would like to permanently save the error (insert a record in a table) before I roll back.  By default the rollback will also rollback that inserted record.  Is there any way not ...
Score Monitor SQL data/log file % used
Tim Kelley - 6 Sep 2006 7:27 PM - 2 messages
Is there a way to monitor the % (or size) of the data file used in a SQL 2005 database?  I can use the Performance Monitor to track the log file (Log file(s) used size (kb)), but I don't see the same option for the data file. ...
Score 2 registrations for the same server (SQL Server 2000)
Conan Kelly - 6 Sep 2006 6:10 PM - 3 messages
Hello all, I was wondering if it is possible to add a second registration for the same server.  It doesn't look like it is possible though. I want to do this because I would like one registration with system objects and one without.  Thata way I can do most of my work in ...
Score Sql Server 2005 Enterprise Edition(Sql server community Help required0
Swagener - 6 Sep 2006 5:58 PM - 5 messages
All SQL Gurus, We are in the exercise of planning and designing a data warehouse for our company. But at same time we are having a debate over which database to use Mysql or Sql Server Ent Edition. I'm in the favour of Sql Server due to its Gui flexible front end and ...
Score object owner dbo - need help
tootsuite - 6 Sep 2006 5:49 PM - 7 messages
Hi, I have a developer here, that when she logs into and creates tables in the database, the owner of the table is her login, not dbo. How can I change the settings so that the tables she creates belongs to ...
Score Maintenance Plans in SQL 2000 vs 2005
Brad Baker - 6 Sep 2006 5:43 PM - 12 messages
We're in the process of setting up some new SQL 2005 servers (previously all our DB servers have been SQL 2000). SQL 2000 had maintenance plans which consisted of a Database Backup Job, Transaction Log Backup Job, Integrity Check Job, and an Optimization Job. ...
Score sql 2005 Enterprise Manager
BrianMultilLanguage - 6 Sep 2006 5:13 PM - 4 messages
Is it still there in 2005 and does in work on 2000 and 7.0? Thanks ...
Score Which app to install first, VSTO or SS 2005 Developer??
tlyczko - 6 Sep 2006 5:04 PM - 3 messages
I have Visual Studio Tools for Office (VSTO) and the SS 2005 Developer that comes with it, all of which I can install on my local XP box. 1. Which one do I install first, VSTO or SS 2005 Developer?? ...
Score move/copy database items from SS 2005 Express to SS 2005 Standard??
tlyczko - 6 Sep 2006 5:03 PM - 5 messages
Can anyone refer me to good 'recipes' or sources of information on this topic?? I have Visual Studio Tools for Office, which installs SS 2005 Express locally to my XP box, and I want to develop in SS 2005, then copy the ...
Score Management Studio 2005 View reformat
Spidey - 6 Sep 2006 4:41 PM - 3 messages
When we edit an existing view in SQL Server 2005 Management Studio it reformats the code in the view. Is there anyway to turn this 'feature' off?  It really makes the code harder to read and work with. Thanks. ...
Score Moving a database to a new drive
OD - 6 Sep 2006 4:36 PM - 5 messages
I have a CRM 3.0 application running on a Windows server 2003 R2 and SQL 2005. I need to move the database and log file to a different drive from the current location. It is currently on C: which is the system partion. I need ...
Score Processors
Ulan - 6 Sep 2006 4:14 PM - 10 messages
Does anybody have any experience or know of any articles between 4 dual-core vs. a 8 proc box???? I'm looking at comparing processors exclusively. Thanks ...
Score How to do sizing on Memory requirement of SQL Server 2000 ?
krislioe - 6 Sep 2006 4:10 PM - 5 messages
Hi All, We have custom application  running on SQL Server 2000, about 100 users, on WIn Server 2003. The RAM installed is 1GB, very often that the server the client getting kicked when trying to connect to the server from custom app.  Then we add to 2GB, now its getting better. ...
Score different file size
Marek Wierzbicki - 6 Sep 2006 3:24 PM - 6 messages
Hi I find strange thing. I have (MSSQL2000) big database (about 90 GB). In this database I have to files with about 10.000.000 and 30.000.000 records. I was copy this tables to other serwer, to new created database. After it I create ...
Score Specific partitioning question
Pedja - 6 Sep 2006 2:47 PM - 3 messages
Hi, I want to implement partitioning on one of the tables (see example below). I want to partition it by its identity column, and at the same time I want each partition to be aligned with calendar month, and to be stored on respective ...
Score Creating a trigger on a table using a cursor.
Phonzo - 6 Sep 2006 2:23 PM - 3 messages
Good Day All, I am trying to create a trigger on a table and this trigger must update an Audit table which reflects the column name (the changes apply to), the old value and the new value. I have tried running through a cursor to dynamically update the Audit ...
Score SQL Server Backups
A McGuire - 6 Sep 2006 2:01 PM - 8 messages
Question: I have a server that has over 50 databases on it.  The configuration is as follows: C:\ Installation Files E:\ Transaction Log Files F:\ Data Files and Backups T:\ Temp Database The configuration isn't a debatable item - it is what it is and I have to ...
Score Question for the veterans
Gav - 6 Sep 2006 1:51 PM - 9 messages
I have an SQL 4.21 database that we are finally upgrading, problem is nobody can remember the sa password (or knows what other accounts may exist). Can anybody offer any advice on how we might go about changing it or recovering ...
Score Not Unique Constraint Issue
mr.adamk@gmail.com - 6 Sep 2006 1:13 PM - 10 messages
Good day. I'm running into an issue which is odd. I want the complete opposite of a UNIQUE constraint. For example: create table tmp ( USER              char(30) not null, ...
Score Locked files during backups on a cluster
michaelg via SQLMonster.com - 6 Sep 2006 12:44 PM - 4 messages
Hello, I am running an active-active cluster on SQL 2000 SP3a over a Windows 2003 Enterprise server. We have two production instances running (SQL1 and SQL2). Each was setup on a different node originally. When the two instances are ...
Score creating a stored procedure
thamarai.82 - 6 Sep 2006 12:12 PM - 5 messages
hi, can we use  table as an out parameter in sql stored procedure? if so can any one help me out with an example. thanks in advance regards, Thamarai ...
Score switch to low priority
Davy - 6 Sep 2006 12:12 PM - 2 messages
I'd like to known if it is possie to connect to sql server 2000 and switch to al lower execution priority? I wrote a log logshipping program and i'd like to execute it at a lover thread priority within sql server. ...
Score ddl statement is not allowed
rob.graveley - 6 Sep 2006 10:47 AM - 8 messages
Can someone help me with this. I have installed the trail version of SQL Server 2005 on a 2003 server box alongside an existing installation of SQL Server 2000.  I can connect to and create new databases but cannot create tables within the ...
Score Index size
Malin Davidsson - 6 Sep 2006 8:56 AM - 3 messages
Hi! If I have an index on a nvarchar-column and change this column to varchar, will the index size decrease? and the db-size too? Thanks //Malin ...
Score Cluster Failover
Joe.Mobley - 6 Sep 2006 8:23 AM - 4 messages
Each morning I find that 1 of my servers has failed across and I'm getting the following error: Does anyone have any ideas?? Many Thanks Event Type: Error Event Source: ClusSvc Event Category: Startup/Shutdown Event ID: 1234 Date:  06/09/2006 ...
Score Why the database data file is lost?
ja - 6 Sep 2006 6:52 AM - 5 messages
Hi, all     I have a stored procedure to create table to a database from time to time, if the time is short ,it runs OK, but if the time is longer than 10 hours, it will turn out the following error: ...
Score Giving Database to Outsourcing company
tshad - 6 Sep 2006 3:48 AM - 4 messages
We are using an outsourcing company who now wants a backup of our database - which has sensitive data in it. The problem is that our Database has 2 applications in it with many Stored Procedures and Tables in each.  I already have them set up with access to ...
Score What is the working set ?
Hassan - 6 Sep 2006 3:47 AM - 3 messages
Can someone tell me more about it ? ...
Score optional input parameter for stored procedure?
Cylix - 6 Sep 2006 2:04 AM - 2 messages
How to set a input optional parameter for stored procedure? ...
Score group by and min()
justingharvey - 6 Sep 2006 12:55 AM - 7 messages
I have a simple table.  Let's say 3 columns, c1, c2, and c3.  c1 is int, others varchar.  Assume the following data. c1     c2     c3 ------------------------------------ 2     d11     d111 ...
Score dbcc checkdb
jai - 6 Sep 2006 12:55 AM - 5 messages
I found the error 2508 after I ran dbcc checkdb on one of my tables. It says it found a consistency error. What should I do??? Can I run the dbcc checkdb <dbname>,repair_rebuild. Please advice. Regards Jaideep ...
Score disable and enable trigger on schedule
00KobeBrian - 6 Sep 2006 12:04 AM - 8 messages
How do you disable and enable the trigger on a table automatically at some time daily? ...
Score Performance Issue
cbrichards via SQLMonster.com - 5 Sep 2006 10:59 PM - 8 messages
I have a server that is undergoing performance issues. Showcontig shows little fragmentation. Server memory setting is dynamic, with 0 Min and 8023 Max. From Perfmon: Available bytes = 5010813086 Target Server Memory (KB) = 2705186 Total Server Memory (KB) = 2705186 Buffer Cache Hit Ratio = 99.382 ...
Score Backup one server, restore to another
Ron Hinds - 5 Sep 2006 9:39 PM - 2 messages
I frequently restore the backups of my production server to my standby/test server. They (the servers) aren't completely identical, however. Production has 3 logical disks for OS, data and logs while standby has only two disks. The real problem though is the time it takes to do a restore using EM. It ...
Score No "Maintenance Plans" under SQL Server 2005
Scott Moseman - 5 Sep 2006 9:17 PM - 5 messages
Running "SQL Server Mgmt Studio" For the software "SQL Server 2005" Under the SERVER instance, there's Mgmt -> Maint Plans. Under SERVER\INSTANCE, there's no Maintenance Plans. The DBs I need to back up are under SERVER\INSTANCE. ...
Score Reseting Indexes
Greg - 5 Sep 2006 9:11 PM - 3 messages
I just migrated a Microsoft Access 2002 database to SQL Server 2005. So far everything is working great. While updating my Access.mdb file to an Access.ADP file I've been testing adding, editing and deleting records to various tables so that I can ensure my Stored Procedures are working ...
Score text finding script
Ben Watts - 5 Sep 2006 9:04 PM - 2 messages
if I wanted to find a specific piece of text with a database and have it show me what column and table it was in, how would I write that? ...
Score SQL Server patches - where to find
Tom - 5 Sep 2006 8:13 PM - 4 messages
Hi! For maintenance and other reasons does anybody know a web page where I can check for latest updates for SQL Server 2000 and Analysys Services 2000. I have applied SP4 to both services but don't know where to ...
Can't create http endpoint - don't have permission
Monthly rollups, tricky SQL question?
SQL Server Slow day by day
Database Mirroring - setting up the witness
SQL Server is terminating due to 'stop' request from Service Contr
Training
Schedule job only on work days
Transaction log backup
SQL Server 2000 errors
Application Roles
Checkpoints
Getting the dateformat
SA pass??
Transaction log Backup
Loading a TRN file that is in a byte array (C#)
SQL Performance issues
trigger problem
Which Index is using
Selecting 2nd maximum
Mapped drives
SQL Profiler "Server processes SQL server trace data" option info
SQL Server Throwing Rows
What is the correct query for that?
Security (How to protect SQL Server)
collation
Note on Disk Queue Length
Stopped Shrinkdatabase....
SQL Server 2005 Performance
SQL Licensing
script for generating service user account?
MultiServer SQL 2000 SP3 Administration
login failed for user
Code Review
Changing SQL Port
Backup databases and Checkpoint
MDF file is not getting smaller
How to query for unique constraints only?
Bring Log File (LDF) Online
Types of constraints
How to change Default port in MS SQL server (2005) and Use it with Pro* C
q; output to a text file
import 1 mln records = QA is hung up
SQL Server 2005 daily backups
Next »