SQL Newsgroups: Microsoft SQL Server Administration

SP and BACKUP DB failed

ina - 7 Oct 2006 12:01 PM - 5 messages

Hello, So I have a case here that I can not understand very well. So I build a DeleteOldBackup Stored procedure in order to delete all backup old than 1 month from now. I schedule this job. I noticed today morning that one of my backup DB doesn't work. "job ...

Disallow connection for a second or two

Newish - 7 Oct 2006 10:55 AM - 3 messages

Hi Is it possible to prevent users of a database in SQL Server 2005 from doing anything for a second or two. Can this be done using a stored procedure. thanks Newish ...

Applying Tran logs in SQL 2000

Karthik - 7 Oct 2006 7:29 AM - 3 messages

Hi, I have a SQL 2k database thats around 200 GB in size. I have restored this from a backup, but while restoring I failed to realise that I needed to apply tran logs (didnt specify NORECOVERY) once the full backup was restored. ...

Can't run LDAP Query From Remote Machine

Jim - 7 Oct 2006 3:14 AM - 4 messages

Hi all, I have a SQL 2005 server with a linked server which points to our active directory. I am able to query the active directory from the local machine when RDC'ed into the server, but when I run the query ...

SP3 vs SP3a

Richard - 7 Oct 2006 2:02 AM - 2 messages

I'm rebuilding one node of an active/passive SQL Server 2000 cluster. The current cluster has SP3 applied, but we are having trouble finding SP3. The differences between the two service packs are mostly installation related, but there are other differences, such as MDAC. Does anyone know of any ...

Delay between CREATE DATABASE and ability to connect to that database

jasonkester - 7 Oct 2006 12:43 AM - 5 messages

I have an application that creates a new database during installation, and I've noticed some strange behavior. Once I've created the database, I am able to immediately create tables and populate lookup data, provided I remain connected to the server. If, however, I ...

How can I obtain the login name of the caller of my UDF written in a CLR language?

smaully - 6 Oct 2006 11:13 PM - 5 messages

I am using MS SQL Server 2005. Is there a way to obtain the login name of the caller of my user defined function implement in managed C++? I know I can get the information using the code segment below but I ...

Storing PDFS in MSQL

Len A - 6 Oct 2006 10:48 PM - 2 messages

I am tyring to store PDF files in MSQL- some very large. How do you do this? I have fried using the toBase64 to convert it to text, then store it in the database, then use toBinary to write it- but the file that wrtes out only has about half the data in it. ...

SQL SERver 2005 in a workgroup

Rustom - 6 Oct 2006 10:44 PM - 2 messages

I am running two SQL Server 2005 Servers Enterprise Edition on Windows Server 2003. I have two servers in a workgroup and having tremendous issues getting Database Mirroring and Log Shipping to work. Constantly getting error messages stating that the SQL Server agent does not have permissions. ...

Missing System Stored Procedures

RogerT - 6 Oct 2006 10:40 PM - 3 messages

I have a server that has a few system stored procedures missing, among them sp_grantdbaccess, sp_droplogin, etc. I think this may be from a failed installation of a service pack. This server is going away in a couple of weeks, but in the meatime, I would like to get put these system stored ...

corrupted(?) sql server 2000 table

ILoveSQL - 6 Oct 2006 8:50 PM - 4 messages

Hi all, I have identified a table in our database that seems to have I/O issues. When I run a update statistics on this table it takes about 1 minute 30 secs. I renamed the table and did a select * into a new ...

failed to connect to SQL Server's database!

Dhow - 6 Oct 2006 6:50 PM - 11 messages

Hi, I've just installed SQL Server 2005 into Win SBS 2003 R2, everything went fine and other instances (SHAREPOINT & SBSMONITORING) are working as well. The only thing and the most important that should be working but not, is ...

SQL Server 2005 and SQLMangr.exe (tray icon)

tstephan - 6 Oct 2006 6:06 PM - 4 messages

I used SQLMangr in sql server 2000 to place an icon in my system tray. 2005 doesn't seem to have such a tool. I used to use it to easily start and stop the service. Is there a replacement or a better way to ...

OLAP question

tootsuite - 6 Oct 2006 6:06 PM - 2 messages

Hi, I have a question about OLAP databases. We have a regular OLTP database, mostly relational, but not entirely. I just found it that way, I had no hand whatsoever in designing it. However, what has been apparent to me over time is that long, complex ...

transactional replication

december - 6 Oct 2006 4:33 PM - 4 messages

Hi, I set up the transactional replication (immediate updating) using Central publisher with remote distributor method. I'm wondering what kind of issues I will face in future if i add many publications under one publisher. Because I will need to create a ...

DTS

frogman7 - 6 Oct 2006 4:14 PM - 7 messages

I just downloaded and installed DTS for SQL 2005. Now the million dollar question How it I run it is there a button, link, click, dropdown, or setup of external tools I need to do?????? ...

SQL Job schedule time being reset

reveriedax - 6 Oct 2006 4:09 PM - 4 messages

Some of my SQL jobs scheduled run times keeps being spontaneously reset to a date far in the past. When i look at the SQL Agent log I see a lot of the following entries: [162] Internal request (from SetJobNextRunDate [reason: schedule will not ...

Maximum number of database on a SQL 2005 EE server

Tom Maier - 6 Oct 2006 4:04 PM - 3 messages

Does the "hard limit" of ~32K databases still apply to 2005 Express? ...

HELP!!! -- SQL Server 2005 from 2000

segis bata - 6 Oct 2006 3:58 PM - 3 messages

Hello everyone, I'm writing you because I have this situation: I need to register a (remote) SQL Server 2005 and currently we have SQL 2000. I can't do it using Enterprise Manager. Is there a way to do it *WITHOUT* upgrading to SQL 2005?!? ...

Mirroring Failover - Have to run sp_change_users_login

Dan - 6 Oct 2006 3:28 PM - 7 messages

I have mirroring configured (with a witness server) on a database that is being used by an ASP.NET application. The app uses SQL Authentication, and the conneciton string includes the Failover Partner statement. Whenever the database fails over, the app throws the following error: Cannot ...

Copy paste from Excel - should this work??

cheesey_toastie - 6 Oct 2006 3:24 PM - 4 messages

Hi, Now I'm worried as I showed this bodge to a colleague and he is using it a lot! I found that you can copy paste directly from Excel into the Enterprise Manager GUI (we're on v8.0, sql server 2000). ...

Mirroring - Have to run sp_change_users_login after failover

Dan - 6 Oct 2006 3:17 PM - 2 messages

I have mirroring set up and working on a database that is used for an ASP.NET web application. The web appliation uses SQL Authentication to connect to the database. The mirroring is set up with a witness, and the connection string ...

Storing Word, Excel, and PPT files in a database

Dale Fye - 6 Oct 2006 3:11 PM - 2 messages

I have a lot of experience with Access, where I have generally stored pointers to these types of files in my applications. My boss would like me to modify one of my applications so that it stores data from multiple events, and provides a way to archive data (documents of ...

Stoping anf restarting MSDE

ghostlan - 6 Oct 2006 2:13 PM - 2 messages

What is the command line to stop and restart MSDE? ...

Unable to query remote server

Amos Soma - 6 Oct 2006 2:11 PM - 2 messages

I am attempting to query a remote server from Management Studio. I have the remote server set up correctly as a linked server with the proper credentials. The remote server does allow remote connections. The remote server is set up to wait up to 20 seconds to allow a remote login and this ...

Statistics and indexes

Ana Mihalj - 6 Oct 2006 1:52 PM - 6 messages

Hi, I use sql server 2000 SP 3a. I have a database with statistics updated When i run query select memberid, accountid from account where memberid=10 query plan show: row count - 10 and estimated row count -10 But when i run ...

Alternative to cursor.

trialproduct2004 - 6 Oct 2006 1:22 PM - 4 messages

Hi all, I want to get data from table and do some processing depending on records of table. Do i need to use cursor. Or is there any other alternative available for this. Any suggestion would be truely appreciated. thanks in advance. ...

how the fsck do i shrink the transaction log on sql server 2000?

kevin bailey - 6 Oct 2006 1:10 PM - 13 messages

How the fsck do i shrink the transaction log on sql server 2000? The transaction log is now 150GB and we have no space to do anything. We do not want the transaction log - we just want the database. The transaction log is a pointless waste of space for us so a Brucie bonus ...

Deallocating cursor if exception occured.

trialproduct2004 - 6 Oct 2006 12:38 PM - 2 messages

Hi all, i am facing one problem while executing stored procedure. What i am doing is i am opening one cursor and then depending on values fetch inside the cursor i am inserting data into one table. But sometimes my insert query failes due to violation in primary key. ...

MSSQL Server 2000 Memory Grows Incrementally

Vishal - 6 Oct 2006 11:34 AM - 7 messages

Hi All My SQL Server keeps on taking memory(RAM) on the server without releasing it. There seems to be a memory leak. On every query that gets executed the memory occupied by MSSQL grows. Does this make the subsequent queries execute slowly? ...

Backup Plan advice / suggestion

ina - 6 Oct 2006 9:48 AM - 6 messages

Hello guys, I would like to know if someone can advice me on that. I have A MyDB more system DB (master, msdb, model, tempdb) I would like to set up a Backup plan. I would like to: * Backup daily MyDB and system DB ...

report in SQL 2005 problem

00KobeBrian - 6 Oct 2006 7:44 AM - 4 messages

Hi, I am using the Business Intelligence Development studio to create a simple report in SQL 2005 server. I have created a dataset and tried to connect to a database and it failed to connect. An error is given out and ...

restore db

00KobeBrian - 6 Oct 2006 6:42 AM - 3 messages

How do you restore the backup of a SQL2000 DB to SQL2005 DB? Thanks. ...

SQL OLE fields

SF - 6 Oct 2006 6:24 AM - 2 messages

Hi, I am planning to move my Access Database to SQL Server 2000 (or maybe to SQL 2005) knowing that would provide performance boost. Pat of my database is storing the link (PATH) of the project documents and pictures and these docs ...

How to using database mail to send mail with attchment?

Nick - 5 Oct 2006 11:22 PM - 3 messages

Hi All: i can send email by using database mail function, but i don't know how to send witha attachemtn? Cheers Nick ...

Can backup to disk, but not to tape - Access Denied

Jordan - 5 Oct 2006 8:47 PM - 3 messages

I have been trying to use the Maintenance Wizard to setup a backup job to tape however I continually get an Access Denied message for the failure. Even when I try to insert a previously successful tape and try to see what ...

SQL result dollar amounts multiplied x4?

Paul - 5 Oct 2006 8:03 PM - 3 messages

Greetings, Just a little back information on this is that we just implemented some new reporting software. One of the features allows for drillable reports based on custom hierarchies. The business wanted hierarchies pertaining to data that wasn't currently contained in the database, so ...

SQL Server environmental variables

tootsuite - 5 Oct 2006 7:55 PM - 2 messages

Hi, I'm not sure if they're called "environmental variables", but for example, you can: SELECT system_user to get the name of the currently logged in user. Are there similar variables that I can use to find "application name" ...

HTML email

Pradip - 5 Oct 2006 7:54 PM - 5 messages

What is the best way to send HTML email through SQL Server Stored Procedures? The email body might have multiple html tables. So I want to generate the html inside the procedure rather than specifying a query as a parameter to ...

Cannot Delete Maintenance Plans - SQL 2005

Randy H - 5 Oct 2006 7:41 PM - 4 messages

A consultant created a maintenance plan that isn't in use and is not enabled. I want to delete the plan but get the following error. TITLE: Microsoft SQL Server Management Studio ------------------------------ Drop failed for Job 'Maintenance II'. (Microsoft.SqlServer.Smo) ...

Poor Execution Plan in SQL Server 2005

Leila - 5 Oct 2006 7:28 PM - 31 messages

Hi, We have a database in SQL Server 2000. I made a copy of this database(mdf,ndf,ldf) and attached it to SQL Server 2005 on the same machine. When I try one particular SP in both of them, SQL Server 2000 ...

Error - help

tootsuite - 5 Oct 2006 6:12 PM - 4 messages

Hi, Something is wrong with this: CREATE PROCEDURE Admin_LogError AS BEGIN SELECT ERROR_NUMBER() AS ErrorNumber, ERROR_SEVERITY() AS ErrorSeverity, ERROR_STATE() as ErrorState, ERROR_PROCEDURE() as ErrorProcedure, ERROR_LINE() as ErrorLine, ...

NTBACKUP issue

KMP - 5 Oct 2006 5:36 PM - 6 messages

I have the SQL Server database backups going to the network correctly. I have SQL Server service and SQL Agent Service to start using the domain account that has permissions to read/write to the folder on the network where the ...

CATCH BLOCK ERRORS - what are the datatypes?

tootsuite - 5 Oct 2006 5:23 PM - 2 messages

Hi, I am writing my catch block to log error messages to a table. For this purpose I am creating a log table, but I need to know what are the datatypes??? I can't seem to find this info. ...

Reduced Reads on NonSelective Indexed Column

cbrichards - 5 Oct 2006 4:44 PM - 2 messages

I have a table named "MYTable" that contains nearly 500,000 rows, running SQL 2000 enterprise. A stored procedure runs the following statement: IF ( Exists( SELECT * FROM MyTable WHERE GUID = @GUID ) ) ...

System generated transactions

Tom - 5 Oct 2006 4:26 PM - 2 messages

I'm running SQL 2K SP4 and have a stored proc with the following code: .... SET @lCursor = CURSOR LOCAL FOR SELECT ... OPEN @lCursor WHILE 1 = 1 BEGIN FETCH @lCursor INTO @lRow_imrelist_code ...

How to find which version of SQL 2005 (32bit vs. 64bit)

M Craig - 5 Oct 2006 3:41 PM - 6 messages

I have found a kb on getting the Version/Build/ServicePack of SQL2005, but how do you determine if you are running 32bit or 64 bit edition? Thank you, Mike ...

SQL Server 6.5 Error!. please help. any ideas ASAP. Thanks!

vmas - 5 Oct 2006 3:36 PM - 6 messages

Hello! I have SQL Server 6.5 on Windows 2000 Server. Having problem with the database all of a sudden. Database went into Suspect Mode & users could not connect. I looked up the blogs on google & i saw that changing the status of database in sysdatabases will fix ...

Kill Old Sessions

Izzy - 5 Oct 2006 3:23 PM - 8 messages

I've got a few databases which users access using Terminal Server. I noticed today I had several (20+) sessions which had a Last Batch date which were days even weeks old. I want to kill these old sessions if the Last Batch date is greater ...

deploy maintenance plans?

realgeek - 5 Oct 2006 3:02 PM - 6 messages

Hi. I have a maintenece plan on my development server that rebuilds indexes and updates statistics of a certian database that undergoes a lot of updates of data daily; it also truncates the log file and backs up the database. ...

moving database files

param - 5 Oct 2006 2:37 PM - 5 messages

Hi all, We have added a new HDD to our server since we were running out of space on the first one. What is the easiest way to move the databases to this new hard drive? We are running SQL2K5 ...

restore database bug

Jason - 5 Oct 2006 2:32 PM - 2 messages

Hi, I'm having some problem with restoring a database from another server. The problem is that sql server 2000 is telling me at the end of the restore process, the user is invalid in the database. It is the same ...

Cant seem to modify a SQL Server 2000 Table Valued Function in SQL Server Management Studio (2005)

grd - 5 Oct 2006 2:31 PM - 8 messages

Hi I cant seem to modify a SQL Server 2000 Table Valued Function through SQL Server Management Studio (2005) Has anyone else experienced this issue? Dickster ...

Net 1.1 and 2.0 and SQLServer 2000 and 2005 at one machine

Uli - 5 Oct 2006 2:06 PM - 5 messages

Hi, we have a VServer with Server 2003. I'd like to install Software for net 1.1, 2.0 and also SQLServer 2000 and 2005 on it. Does anybody knows if that's possible without problems. I have a consultant ...

SQL Server 2005 Profiler: Tracing Table / Index Scans

Robert Klemme - 5 Oct 2006 2:00 PM - 8 messages

Hi, I am profiling activity on a SQL 2005 DB with SQL 2005 Profiler. I included Scan:Started and Scan:Stopped events but in the trace I only see Scan:Started. I have a filter on the databaseid and user name but a ...

Problems with SQL Server agent

McA - 5 Oct 2006 1:44 PM - 5 messages

Hi, I have som problems with a SQL Server agent job. I have created a DTS package that extracts data from database and saves the data to a csv file on the network. When I run the DTS package manually the file is created and all is OK. ...

IS NULL bug(?)

Shuwi - 5 Oct 2006 1:20 PM - 6 messages

Hello, My problem is; weird results with a IS NULL clause in a query. I have a sql2000 dbase, table, 2 columns and the following query: dt_column = type: datetime computed: no length:8 nullable: no TrimTrailingBlanks:n/a FixedLenNullnSource:n/a ...

Performance degrades severely after executing REORGANIZE

Robb Gilmore - 5 Oct 2006 1:04 PM - 9 messages

Hi, We have a SQLServer 2005 database that is undergoing a serious problem. It is causing some searches to take 10 minutes rather than seconds. Our users are almost unable to use the application since this has been ongoing for 3 ...

Managing 2000 and 2005

Adrian - 5 Oct 2006 12:49 PM - 10 messages

Dear all I have now a default instance of SQL Server 2005 running on one PC and an old default instance of SQL Server 2000 running on another PC. I would like to administer both SQL Servers with the new SQL Server 2005 ...

how to use microsoft application blocks ent lib june 2005

Mukesh - 5 Oct 2006 11:39 AM - 4 messages

Hi I m using microsoft application blocks Enterprise Library june 2005 with .net framework 1.1 and VStudio2003 And C# as coding language Sql server 2000 database the project is running properly on the localhost server but my online server does not have the ms Ent lib installed and also ...

Viewing log content

Waldo - 5 Oct 2006 10:46 AM - 4 messages

Hello I'm testing SQL Server 2005. Is there a way to see the contents of the log files from the databases, a viewer or something like this? Thanks - Waldo ...

TRUNCATE TABLE and index

Larry Lau - 5 Oct 2006 9:16 AM - 8 messages

Hi all, Does the sql command TRUNCATE TABLE delete the index of the corresponding rows? If not, what should I do to reduce the index size? Thanks, Larry ...

Error In Log

Phil - 5 Oct 2006 8:18 AM - 6 messages

Morning All, Rececntly I have been getting quite a few errors on the resotre of my databases, what happens is the files are downloaded from a remote server, unziped and then I run some script to restore them......this has been working ...

DBCC TRACEON 208 & tempdb growth continuously

Ivan - 5 Oct 2006 4:58 AM - 2 messages

Dear all, our client is using Windows 2000 sp4 & SQL2000 sp4 In these two weeks, we found that the SQL server tempdb growth continuously. before, the tempdb size is set to 500Mb and there's no problem in these ...

Table Statistics

Mahesh - 5 Oct 2006 4:32 AM - 3 messages

Hi, i have a database with statistics updated. if i take a backup and restore the database in some other server, should i run the statistics again on the restored database? need your help. Thanks in Advance Regards rmahesh ...

Returning constant in place of value in SELECT

Jeremy.Deats - 5 Oct 2006 3:25 AM - 3 messages

I have a column in a table that is of type int, the value will always be 0, 1, 2. Is there a way to specifcy in the SQL syntax to always return a specific varchar value in place of the in that's stored in the ...

Openrowset vs linked server - ODBC text driver

mhaack - 4 Oct 2006 11:54 PM - 3 messages

Hi, I am trying to set up a linked server in SQL Server 2005 to access text files, so I can easily join them to SQL tables. I was able to do this with no problems in SQL 2K. I have set up an ODBC text driver DSN which works fine from excel, etc. ...

Query In SQL Express

Charles A. Lackman - 4 Oct 2006 10:07 PM - 5 messages

Hello, I just converted my MSDE Database to SQL Express and now some of my queries don't work. Column1 = NVarChar Column2 = NVarChar SELECT Column1 + ' ' + Coumn2 AS BothColumns FROM Table1 What I am trying to do is add a space between both values. ...

How to find duplicate records by tree field?

ad - 4 Oct 2006 9:45 PM - 4 messages

I have a table named student, there are tree fields GradeID, ClassID, Seat in it. How can I fild the duplicate record by the tree fields? ...

updating sql server 2005 db compatibility level through query

Vadim - 4 Oct 2006 8:16 PM - 4 messages

Hi, Can somebody advise on how to get the compatibility level of the db I am connected to through query, e.g. select comp.level from sometable, I am interested here in the exact query and how to set that compatibility level through query, e.g ...

Push data to remote server

Rishi - 4 Oct 2006 8:06 PM - 2 messages

Can I run bulk insert or bcp on a local server to insert data into a remote server? What are the other options to Push data to a remote server outside a firewall? ...

Backup/copy to remote server

vast55555 - 4 Oct 2006 7:36 PM - 4 messages

Hello, I've spent the afternoon reading old newsgroup posts and BOL but am still a bit confused about the best way to approach a new backup scheme. My organization would like to establish a single repository for backups from our database servers, by either backing up databases on each ...

Help With Making A Query

Charles A. Lackman - 4 Oct 2006 7:13 PM - 2 messages

Hello, With the following tables how would I create a query that would return all rows from the Customers Table that have an entry in the Activity Table? TableName: Customers ID - Integer CustomerID - VarChar StartDate - Date EndDate - Date TableName: Activity ...

Stored Procedure - how do I loop query results

marcus - 4 Oct 2006 6:47 PM - 2 messages

I am building a stored procedure to select records and send an email with the information in those records. My procedure works fine when there is one record. But, when there are multiple records, only the top record in the result set is emailed. ...

Hardware Tuning for Queries

Leila - 4 Oct 2006 6:37 PM - 8 messages

Hi, I have several queries in a complicated database that join almost 10 tables each. The query plans are good because there are a lot of index seeks and merge/loop joins (Hash join have been eliminated by appropriate indexes). It ...

After corrupted publisher

Ron - 4 Oct 2006 4:31 PM - 4 messages

Hi All, I am fairly new to MS SQL Replication. I have two servers one is setup as the publisher and the other is setup as both the subscriber and the distributor. Due to server reboots, the publicher DB became corrupted therefore we ...

Insert into table using 2 different SELECT statements fails

Chris Asaipillai - 4 Oct 2006 3:25 PM - 3 messages

Hi I want to do the following Insert statement using 2 seperate Select statements from 2 diferent tables insert into tblProcessStageEmails (ProcessID,EmailTemplateID) select ProcessID from tblProcessLookup where ProcessDescription Like '%Awaiting Respsonse%' select EmailTemplateID,* from tblEmailTemplates where TemplateName like 'VAT - Awaiting response follow up (Voluntary)' ...

DTS Email Task Works - But not in JOB

taranbuckley - 4 Oct 2006 12:28 PM - 3 messages

I have a DTS package created in SQL Server 2000 that creates a table, pumps it to excel then emails the spreadsheet to users. I do not have exchange. I have Outlook 2003 and I have an email account set up in ...

problem in connecting to server after restore of master

danielsanberger - 4 Oct 2006 10:22 AM - 3 messages

Hi all, even though sysdatabases contains a row with [name] = 'master' I get the follwoing error message when sending commands to the db engine: Msg 911, Level 16, State 1, Server BEQV288H, Line 1 Could not locate entry in sysdatabases for database 'master'. No entry ...

Some questions for SQL Server 2005

Peter - 4 Oct 2006 9:09 AM - 7 messages

Hi, I am new to SQL Server 2005 and just install a SQL Server 2005 Standard Edition on Windows 2003 Server. During the installation, I find that there are some difference from that for SQL Server 2000 and would like to seek your advice ...

Copy Database Wizard and DTS Transfer Database Task don't work

Andreas.meyer@dmc-group.de - 4 Oct 2006 7:32 AM - 3 messages

Hello, I work with two SQL-Server 2000 computers. Both hav SP4 for SQL Server 2000. Both belong to the same domain and can see each other without problems. A mutual registration of the other sql server in Enterprise Manager is no problem. ...

Date overlapping

Rsapru - 4 Oct 2006 3:06 AM - 3 messages

i have a table containing following data effdate termdate uid ----------- ----------- ----------- 1 2 1 ...

SQL Server 2000 Type in Startup Parameters Incorrectly

Joe K. - 4 Oct 2006 1:49 AM - 3 messages

I type in the master.mdb or mastlog.ldf incorrectly in the startup parameters on SQL Server 2000 database server. Cannot start the database server. What are the commands to resolve this issue. Please help me resolve this issue. ...

Perfmon/Profiler confusion

Frank Rizzo - 3 Oct 2006 11:53 PM - 4 messages

I am trying to troubleshoot crazy values for SQL Statistics/SQL Compilations/sec in Perfmon. So I started up the Profiler,removed all the default events and added Stored Procedures/SP:Recompile event class. I am seeing numbers like 20 SQL Compilations/sec average, however, the ...

All DB maintenance plans fail

Jordan - 3 Oct 2006 11:19 PM - 5 messages

MS SQL 2000 SP3 on a Windows 2003 SP1 Server. Both SQL services are running under an Administrator account. The database maintenance plans to backup the server databases were also created when that account was logged onto the ...

Msg 8127 problem.

Cuellar - 3 Oct 2006 10:43 PM - 4 messages

Hi, I need help with this sql. It works for SQL Server 2000, SP3, (8.00.760) but it fails in SQL Server 2005 (9.00.1399.06). SELECT DATEPART(yy, os.[CreateTS]) as 'YEARCOL', DATEPART(mm, os.[CreateTS]) as 'MONTHCOL', DATEPART(dd, os.[CreateTS]) as 'DAYCOL', ...

Problem with Stored Procedures can't invoke through a Select Stmt

reklawdiov - 3 Oct 2006 10:09 PM - 2 messages

hi, I need to create a stored procedure that returns a field based on an id, i've looked through the Books Online and googled myself to frustration, it's very easy with Oracle to do what i need but i'm stuck ...

DBCC INEDXDEFRAG cauing transaction log growth

imarchenko - 3 Oct 2006 9:28 PM - 2 messages

Hello! I have noticed that when executing DBCC INDEXDEFRAG on big table (SQL Server 2000 SP4), transaction log starts growing significantly. I was hoping that INDEXDEFRAG is implemented as a serious of short transactions and shouldn't cause significant transaction log growth. Our database is in ...

DBO ownership

WANNABE - 3 Oct 2006 9:01 PM - 8 messages

Is there a quick query of process that can be used to find any objects in a database that are NOT owned by DBO ??? What and how?? Thank you.. ...

Problem Copying Table

berwiki - 3 Oct 2006 8:48 PM - 2 messages

I am trying to copy a table to another SQL 2000 Database, but I continually get errors. When I right-click, choose All-Tasks, Export-Data and go through the DTS settings, I get an 'Unspecified Error' on row 107 (which, looking ...

How to measure TPS

archuleta37 - 3 Oct 2006 8:08 PM - 7 messages

How can I measure the number of Transactions Per Second being performed on a SQL 2000 EE server? ...

Opinions on Option (Keepfixed Plan)

Frank Rizzo - 3 Oct 2006 7:42 PM - 5 messages

I've got this situation where a certain large stored proc (that's used all day long) just compiles way too often, to the point where it hurts the performance. I've tried all the tricks I could find to reduce the ...

Problems with restore

Dan - 3 Oct 2006 5:25 PM - 4 messages

I am trying to restore a database and when I try to use the GUI restore function it just hangs. I can restore through query analyzer without a problem, and all other functions of Enterprise Manager are working correctly. ...

SQL domain move, best way to deal with domain user accounts?

Daniel Peterson - 3 Oct 2006 5:16 PM - 2 messages

Hello, We're planning on doing a domain move on a SQL 2000 (sp3a) server from one Windows domain to another. Things like service accounts, etc. aren't a big deal, but I was wondering what the best way to deal with the windows ...

How to send mail in SQL Server 2005 ?

tootsuite - 3 Oct 2006 4:26 PM - 4 messages

Hello, I am wondering, what is the correct way to send mail from SQL Server 2005? For example, we have an older 2000 job that used to run every 5 or 10 minutes or so, which called a stored procedure that read a table in the ...

Clone SQL SERVER question

ina - 3 Oct 2006 4:24 PM - 3 messages

Hello Guys, I am working in a clone of SQL server and I have some question: NEW SQLSERVER = Copy of OLD SQLSERVER As the new sql server "NEW SQLSERVER" has the same configuration as the "OLD SQLSERVER" all the jobs and others setups have still the old ...

Naming Guide Lines for the Machine (Server) that hoist SQL 2000

Bill - 3 Oct 2006 4:14 PM - 2 messages

I currently have a program that uses either SQL 2000 or MSDE. It works Great. However, I have noticed that if I Install it on a Machine that uses the naming convention with a hyphen in the machine name, that after a short ...

Just delete a loading / suspect database

Rich - 3 Oct 2006 3:57 PM - 3 messages

Hello Group, I was trying to do a restore and to make a long story short, the restore was interupted. The database is now marked Loading/Suspect. I there a way to just delete this database? I can create a new one and ...

Standby/Read-Only Mode

childofthe1980s - 3 Oct 2006 3:54 PM - 3 messages

Hello: In SQL 2005 studio, I restored a database from a backup file and the database now is in Standby/Read-Only mode. When I try to change the properties to read-only mode, it tells me that the database is in warm standyby--whatever that is. ...

Job execution logged as an error

jaimefelipe - 3 Oct 2006 3:51 PM - 6 messages

I have a special necessity in which I need that the result of failed jobs in SQL Server Agent be logged as errors in Windows Event Viewer. Normally they are logged as Warnings. We developed a solution that uses active scripting for writing the errors in ...

Setup SQL Database Mail

SQL 2000 Memory allocation "best Practices" AWE newb question

Moving objects from one schema to another

Recommendation

Transactional Replication Times Out..!

SQL Server 2000 Setup SQL Mail

SQL 2005 clustering

Visual Source Safe with SQL Server 2000

Is SQL Server Multithreaded?

shifting the transaction log

SQL Event logging

Timeout Expired...max pool size was reached.

Indexes ineffective in MSSQL Server 2000

Bookmark lookup takes time in SQL server 2000

service manager

Detaching MDF/LDF files to SQL Server 2005 running on MSCS

Reporting in Local time

Datetime convert fails!!

Column summing other columns

CONTAINS in SQL Server

Replication option

One hell of a problem (SQL2K)

Copy Stored Procedures from one server to another

Moving SQL Server installation (dbs, logins, replication, jobs, DTS etc) to new server

How to create a new instance with SQL 2005

Logical read and DBCC dropcleanbuffers

SQL Mail on 64 bit SP1 box? Not useable!?

Dropping and recreating all statistics

what queries has a process executed

Attach a Database from multiple computers? (SQL Server Express 2005)

Getting objects in existing DBs into VSS

DBCC CHECKDB returns error, sys.sysobjvalues

Service Pack 4 instal from command prompt

SQL on MOM2005 - [WildPacket]

collation

export every table into a separate csv

shared lock (TABLOCK) behaving as exclusive (TABLOCKX)

Alter SP

SQL 2K SP4 and log-shipping

User defined functions

ListAvailableSQLServers not refreshing (VB-Sql server 2000)

Arithmetic overflow error converting expression to data type datetime Year and month

SQL Server 2005 Workgroup Edition ?

string to date conversion query

How do I find unique indexes in SQL-server 2005.

How to find unique indexes in SQLserver 2005

msdb log backup failed

Cannot Update Identity Column while doing Select statement

Locking - different behavior on similar servers

SQL server express

insert or replace

procedure parameter not working (newbie question)

Suitable Hardware

Huge transaction log - not sure why or how to fix it

SQL Instances

Database Mirroring in High Safety Mode

how can I find out the number of SQL servers installed in a Domain

Developer Edition - XP Home - SSIS Import/Export?