Microsoft SQL Server Administration

How to truncate a transaction log using Simple Recovery Model?

WayneM - 26 Mar 2005 9:15 PM - 14 messages

I have a SQL Server database on a server with limited disk space and I do not need the transaction log. Is there a TSQL command to truncate the log? I am using a Simple Recovery Model, but it is still keeping a transaction log. ...

Cannot start SQL Server & Sql Agent

maxzsim - 26 Mar 2005 3:59 PM - 3 messages

Hi, i am running SQL server 2000 evaluation copy on SQL server 2003 and suddenly i cannot open my EM From Service Manager , i can start SQL Server but not SQL Agent, From EM , i could not connect to my SQL Database ...

LINK REMOTE SQL SERVER 2000 Database

Savas Ates - 26 Mar 2005 3:22 PM - 2 messages

I have a local mdb file and remote sql server 2000 database.. i know only my remote table user name and password... my mdb file and sql database are same... I tried to link my remote database I click link table and odbc from my mdb... ...

Problem executing a stored proc, please help

rajeshlh - 26 Mar 2005 4:11 AM - 2 messages

Hi All, I have stored proc that processes about 60,000 rows using a cursor. When I call the SP from Query Analyzer, I get the following error message after processing about 12,000 records : Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (InvalidParam()). ...

Backup and DTS....@ the same time....

Carl San - 26 Mar 2005 2:51 AM - 2 messages

I am launching full backup of user database and at the same time loading the data to the tables using a DTS package. Will this be a performance issue? I am using SQL2K. Thanks, Carl ...

Multiple MSDE's

Mike - 26 Mar 2005 1:44 AM - 2 messages

We recently migrated to windows server 2003 with sharepoint, ISA, etc. I noticed that there are 3 instances of the MSDE in addition to the install of SQL 2000. One MSDE for sharepoint, one for ISA, one for SBS monitoring, and ...

SQL Server Users

Willie Bodger - 26 Mar 2005 12:50 AM - 2 messages

OK, this has always gotten me and I can never seem to remember how to get it to work. When I create a new database and create new users, when I try to assign/define which databases they have access to, I get an error stating ...

Calculate Concurrent Users Between a Date/Time Range

Microsoft Newsreader - 25 Mar 2005 10:56 PM - 5 messages

We have log records in a table that track user's session durations with a Start_Date_Time of when their session started and an End_Date_Time of when they logged off. Is there a way in SQL Server/Transact SQL to determine how ...

SQL Password... unknown

Eric - 25 Mar 2005 10:23 PM - 5 messages

I have just taken over a server that has SQL 2000 on it and the person that set it up neglected to write down the password before being asked to leave. I'm trying to install SP3 and it won't let me because I don't know the ...

copy sql server db on same server

Chris - 25 Mar 2005 9:59 PM - 2 messages

what would be the best way to copy the entire db to the same server instance? The only thing is the db name needs to be changed. But the logins, tables, etc are all the same. Can't use the wizard since the same instance.... ...

Error 644 Severity level 21

John Rosenlof - 25 Mar 2005 9:43 PM - 2 messages

Hi, I got the following error message for one of our databases: Event Type: Error Event Source: MSSQLSERVER Event Category: (2) Event ID: 17052 Date: 3/25/2005 Time: 9:18:53 AM User: XXXXXXXX\Administrator Computer: XXXXXX ...

ACT! installs 2nd instance no SA or Win-Admin access to..

Scott Davis - 25 Mar 2005 9:12 PM - 4 messages

Folks, It's a bit of a wierd one, I know.. I installed ACT! (CRM -- POS) today. My machine is 2003 Server running SQL-2000/std/sp3. The ACT! installation creates a second SQL instance, i.e. <machinename>\ACT7 ...

DROPCLEANBUFFERS/FREEPROCCACHE

mrdj - 25 Mar 2005 7:51 PM - 6 messages

I've been doing some stored proc tuning and I want to ensure that after the changes I make to the query the execution times are accurate. So basically, if I run DROPCLEANBUFFERS and FREEPROCCACHE in an environment with other ...

Select performance is one table, but not another

JerryK - 25 Mar 2005 7:38 PM - 6 messages

Hi, I was noticed that at select (Select * from mytable) against one of my table in QueryAnalyzer took forever to return results. In the order of 12 minutes! There are approximately 47,000 records in the table. I did a ...

Full text search?

Dean J Garrett - 25 Mar 2005 7:23 PM - 2 messages

I seem to have a problem with how Full-text search works in SQL Server 2000. Here is an example, I have the following two "Notes" field values in two different records: Notes for record 1: 'hello this is a test' ...

converting a string into a password varbinary field.

Ryan McAuley - 25 Mar 2005 7:00 PM - 2 messages

Hi, I have a table that saves user information, name, password etc. How do I convert the user entered password into a varbinary datatype? ...

Debug SP not stopping on Breakpoint

Mike L - 25 Mar 2005 6:37 PM - 3 messages

I was able to pull up a stored procudure in .Net using the Server Explorer. I double clicked the SP to pull it up, added a few breakpoints, then I right clicked on the SP, selected Step Through, then entered the parameter value. ...

Need help on Effective Reindexing Stragtegy.

MZeeshan - 25 Mar 2005 6:21 PM - 12 messages

Hello- We have a database supporting a vertical solution. Following are some of the important details: OS: Windows 2003 Server (sp?? I am not sure but can get that info if needed) DB: SQL Server 2000 / sp3A Data Device Size = 125 GB ...

Managing TB size of data

Ramuk - 25 Mar 2005 5:27 PM - 8 messages

hi, I jsut want ot know what are the challenges we should face in managing few 100 TB size large DB. What is the best way to do the backup and in the live 24 * 7 environment how to do the Full backup if needed? ...

Waitstats data within the Profiler Traces?

ktf - 25 Mar 2005 4:53 PM - 3 messages

Waitstats data is captured from dbcc sqlperf(waitstats) and analyzing that per stored procedure can provide helpful understanding performance bottleneck information. Is there any where I can select it within the Perfiler? If not what is the closest areas within a trace I can capture a close information. Also is it ...

Find table/indexes size

FireStarter - 25 Mar 2005 4:52 PM - 4 messages

Hi, guys! Is there any way that I can find out how much space each table (along with its indexes) is ocupying on disk? If that's impossible, how can I find out which tables occupy most space in my database? I'm running out of disk space quickly and I need to do ...

Shrinking tempdb to a certain size?

ktf - 25 Mar 2005 4:35 PM - 3 messages

I need to shrink the tempdb (mdf file) to release some space. I increase it a little to much on the SAN. It is sql 2K on a 24X7 environment. If I try to shrink the tempdb is it going to work? do I have to reboot? What else should ...

TimeStamp ??? from fn_virtualfilestats report?

ktf - 25 Mar 2005 4:27 PM - 2 messages

Any idea how to translate TimeStamp from fn_virtualfilestats to real time? Thank you. ...

hunt for a better job

DBA - 25 Mar 2005 4:17 PM - 3 messages

Hi all, I have 3 yrs SQL Server exp. and I have just received my MCDBA, I am currently wroking but I want to find a new job inorder to increase my salary. What is the best way to hunt for a better job? ...

TRXN LOG BKP time takes so much longer than Full BKP???

ktf - 25 Mar 2005 4:01 PM - 7 messages

One of several databases I support is about 70 MG. I have a nightly full backup and hourly transaction log backup running on all of databases and there is no conflict in time on jobs.. There is something about this database ...

Data Migration Recommendations Needed

Lontae Jones - 25 Mar 2005 3:27 PM - 2 messages

I often have to copy an entire database from production server onto a staging server. I was looking on other ways this can be done without headaches. This is what I do. There are probably better ways out there. ...

Find out how much data was replicated

Osk - 25 Mar 2005 3:05 PM - 3 messages

Hi I use SQL Servers 2000 SP3 on Windows 2000 Advanced Server SP4. I've set up a transactional replication w/o updating between two servers, one of which is a publisher and the other is a distributor/pull-subscriber. I wonder if SQL ...

SAN issues, please help

Van Jones - 25 Mar 2005 2:44 PM - 7 messages

We have a new SQL2000 SP3a server built that replaced an old SQL2000 SP3a server. The only difference between the 2 is that the new one has Win2003 instead of Win2000 and SAN drives instead of local drives. This new server is ...

Primary File Group Full?

G Dean Blake - 25 Mar 2005 2:42 PM - 13 messages

I'm uploading a table to my Web Hosting Site that has 499 rows (big rows because they have binary object in them). After an hour or so of importing using a DTS package, I get the following error: Error at Destination for row number 499. could not allocate space for ...

Help needed with OpenQuery

Jim Wile - 25 Mar 2005 1:52 PM - 2 messages

Hello I am trying to do the following on a linked server (Oracle RDB), not (Oracle, Oracle). 1. drop a constraint 2. truncate a table 3. load new records into the lined server from ms sql server. I am struggling with the syntax of the commands to make the medata changes ...

Backing up a database?

epigram - 25 Mar 2005 12:49 PM - 2 messages

I've got two developers that are working on a asp.net app that use SQL Server 2000. They've both got the developer edition on each of their PCs. I'd like to know what is the best way to "backup" the database so that 1) we ...

Scrash OS, Win 2000 server while restoring SQL server database

TN - 25 Mar 2005 7:39 AM - 2 messages

Hi All, I have a problem with restoring SQL server database: OS: Window 2000 server Database: SQL server 2000, SP3a Hardware Configuration: 1 CPU P4 3GHz HDD: 120GB (C:60GB, D:140GB) Backup file size: 30GB I want to restore it on D driver. ...

SQL 7 server SQL.LOG file

Joe Wingrove - 25 Mar 2005 7:39 AM - 3 messages

I have a problem with a SQL.LOG file on my SQL 7 server it appers on the C drive and grows until it eats up all the space on the drive. I am unable to stop its growth and cant get rid of it anyone know what I can do to stop it ...

could not find stored procdure xp_availablemedia

jkim65 - 25 Mar 2005 6:12 AM - 4 messages

hi. I am getting this error when I try to restore database from device and try to choose 'filename'. It's apparently I am missing xp_availablemedia stored procedure, but where can I get a copy of this and put it in? ...

How to 'call' UDFs from SPs

The Gekkster via SQLMonster.com - 25 Mar 2005 1:15 AM - 12 messages

New to SQL Server in general (2000 in particular) and working through the relative difficulty of upsizing an Access '03 database that's currently used in a small ASP web application. The database is generally hit via the ADO command object, passing parameters as needed via CommandText. ...

How to backup and restore related databases?

Peter - 24 Mar 2005 11:41 PM - 11 messages

If an application will update tables in different databases in a transaction, how to backup the databases? For example, if the transaction is something like this: Begin Transaction update tables in 1st database update tables in 2nd database Commit Transaction ...

Is it possible to restore SQL Server from Registry and System file

Andrey - 24 Mar 2005 10:31 PM - 6 messages

Assuming that the backups are taken when SQL Server is shutdown, is it possible to take a backup of SQL registry keys and system files from one server, copy these backups to another server and restore SQL Server? Can we ...

Fastest way to determine if a query returns any rows

Klaus Löffelmann - 24 Mar 2005 10:07 PM - 3 messages

Hi, I hope I don't embarres myself because of the simplicity of this questrion, but what would be the fastest way to determine, if a query would return any rows (without actually returning them, and I don't need to know how many ...

query on data and log file

SQL Server DBA - 24 Mar 2005 9:18 PM - 6 messages

If I have to query the two filenames of a database for both data and log file, how can I do it from master database. One method I know is to use the database and call sp_helpfile. But I want the query to run from the masterdb about the data and log file of a database. ...

Exporting data using T-SQL... something opposite of BULK INSERT.

MZeeshan - 24 Mar 2005 7:57 PM - 11 messages

Hello- We have to export data as part of processing and save it as a flat file. What developers did was to use xp_cmdshell and export data that way. It solved that problem but now the account calling it has be a member of ...

copy data from one database to another

SQL Server DBA - 24 Mar 2005 6:36 PM - 3 messages

Hi, In our build process (where SQLServer is used as an embedded database) we always recreate the database from scratch. When the database is recreated, the script also recreates some basic data from the script. Some of the QA folks are having a problem with this. They are not willing to lose all ...

Log Shipping!

Shan - 24 Mar 2005 5:53 PM - 5 messages

Hey, I am trying to setup log shipping but some how it does work. I does not let me select the Server from the drop down list in the Add new destination server window. Any idea why? Regards ...

DTS Package error: TNS-12541: TNS:no listener

James Juno - 24 Mar 2005 5:33 PM - 3 messages

I have created a connection to an Oracle database. I am able to connect to one server and not to the other. The error message I get is : TNS-12541: TNS:no listener Here are the steps I took before creating this connection: ...

ASKING FOR JDBC AND SQL92 COMPATIBILITY

villeurbanne - 24 Mar 2005 4:57 PM - 5 messages

We try to compare Postegesql/Oracle/Sql Server/Ingres for a local application developped in Java. Could you confirm by mail that oracle database server is SQL92 (Level entry) compatible, and support JDBC1/JDBC2 and JDBC3. Thanks for your respons. ...

Scale Up or Scale Out with SQL Server 2005

Saptagiri - 24 Mar 2005 4:51 PM - 8 messages

Hello All, We plan to upgrade from our current vey old SQL Server Box to a newer one. We have the following requirements 1) we want to be able to seperate storage from the server(e.g. by using a ...

Find tables w/o primary keys but w/ unique clustered indexes

Osk - 24 Mar 2005 4:30 PM - 7 messages

Hi I run SQL Server 2000 SP3 on Windows 2000 SP4. I want to find out, which "user tables" in my DB don't have a primary key but do have at least one unique index. I couldn't find any documented way to do this straight away. ...

Random error on Import

G Dean Blake - 24 Mar 2005 4:13 PM - 3 messages

I am trying to transfer my MSSQL database to a webhoster. They don't allow me to have administrator privilege so I cant load my database there by doing a restore - I have to do an import via a DTS package. The DTS package does ...

Sever Memory Settings for 2 instances of SQL Server

Clark - 24 Mar 2005 3:21 PM - 4 messages

I needing to run 2 instances of SQL Server on a single server for a few weeks. Please suggest some memory configurations. Total server memory: 8 GB RAM ...

IAM page (0:0) is pointed to by the previous pointer of IAM page (

sqlsleuth - 24 Mar 2005 3:11 PM - 5 messages

Server: Msg 2576, Level 16, State 1, Line 1 IAM page (0:0) is pointed to by the previous pointer of IAM page (1:867) object ID 992722589 index ID 0 but was not detected in the scan. Server: Msg 2577, Level 16, State 1, Line 1 ...

SQL Server is using process id of 1032 since ...

Jluo - 24 Mar 2005 3:02 PM - 2 messages

In the application event log on my SQL Server 2000 machine, I see a few messages like the following for each of the three instances (the following number 1032 is different for the other two instances, which are 1048, 1064): ...

SS

shif - 24 Mar 2005 2:29 PM - 5 messages

Hi my database i upgraded to mssql7 to mssql2000,before the size of log file was 2mb running db for 2 months,after transfering to ms2000 the size is increasing very fastly after 1 week the size increased to 165mb. ...

upgrading sql server 2000 based application to sql server 2005

Raj - 24 Mar 2005 10:47 AM - 2 messages

HI, I introduce myself as software analyst(DBA) with manhattan associates. Currently we are having a data warehousing product in which back end is sql server 2000 , which includes DTS packages and analysis server cubes...... now the question is can we install this product in a machine with sql server ...

BLOB index search

Paul - 24 Mar 2005 7:15 AM - 2 messages

Hi, I am wondering if I can user SQL server to store Word documents in the BLOB field and then use Index Server to crawl through those documents (maybe on a timed basis) to generate a catalog which can be used for web based queries ...

DTS runs OK, but not scheduled job

Masako - 24 Mar 2005 6:37 AM - 4 messages

Hi, When I run DTS manually, it works fine. But when I run the scheduled job, it failes. The error said cannot find a file specified. It imports Excel file to SQL2000 Server database. I set same domain user id for DTS creater and Agent ...

bit mask with 300 flags

Igor Marchenko - 24 Mar 2005 1:50 AM - 5 messages

Hello, I have 300 groups. Each user can or can not be associated with certain group. I would like to represent group membership using corresponding flag (on/off). Using integer dattatype it will look like : G1- 1, G2 - 2, G3 - ...

LogShip between SQL 2K and SQL 2005

Moh Abb - 24 Mar 2005 12:44 AM - 2 messages

It seems like with SQL 2005 Beta 2, setting up logship between SQL 2K and SQL 2005 is not possible. If any one one knows please confirm this. Thanks, Moh ...

How to change the Default value of a Column

Baranggay Ginebra - 23 Mar 2005 11:47 PM - 4 messages

What's the SQL or is there a stored procedure to replace the DEFAULT value of a COLUMN? Dropping and re-adding the column seems overkill to me. thanks in advance ...

collation question

A.G. - 23 Mar 2005 9:27 PM - 2 messages

Hello We used MSSQL 2000 ENG - enterprise edition on a Windows 2K SP3 server ENG. What are differences between SQL_Latin1_General_CP1_CI_AS collation and Latin1_General_CI_AS collation ? If I compare with COLLATIONPROPERTY function, results are equals. Is it possible to install an instance with SQL_Latin1_General_CP1_CI_AS ...

Stored prodcedure sytnax

Luis Esteban Valencia - 23 Mar 2005 8:39 PM - 4 messages

Can someone help me with this procedure I cant put it to work create procedure crearnuevopedido @idusuario int, @idcentrodecostos int, @idcompania int, @fecha smalldatetime, @maximomedido int out as insert into tblpedidos(idcompania, idusuario, fecha, valortotal, subtotal, iva, idcentrodecostos) values (@idcompania, @idusuario, @fecha, 0 , 0, 0, @idcentrodecostos) ...

select dynamic field

ming - 23 Mar 2005 8:23 PM - 5 messages

Hi all, I have a question might be easy but annoy me for days. Let's say we have a table, it has field listed below (1..12 indicate month number) pid,year,1,2,3,4,5,6,7,8,9,10,11,12 ...

Error 1222 Lock Request time out period exceed

Alpha - 23 Mar 2005 8:21 PM - 4 messages

Hi, I'm getting this error when I tried to click on the Current Activity in the Enterprise Manager. This is a SQL2000 running on Windows2000. Does anyone know what causes this and how to fix it? I also get this error ...

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

Hernán Rado - 23 Mar 2005 7:47 PM - 3 messages

Hi !! Does anybody know how can I solve this problem ? Server: Msg 18456, Level 14, State 1, Line 1 Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. I have this problem when I tryed to execute a select between two SQL server ...

Problems using TOP and User Functions

TechnoSpike - 23 Mar 2005 7:14 PM - 3 messages

Hi! I'm trying to create an User Defined function that gives me the top rows of a table. I must be able to define wich is the top number of rows to be returned. I assume I could do this: ...

Start up SQL Server

Luis Gomez - 23 Mar 2005 7:09 PM - 6 messages

I can't start SQL, shows an error: "The service did not start due to a logon failure - Error 1069" Can somebody help me. Thanks Luis ...

Performance of SQL Server Stored Proc slows down 300% over a few weeks

Adrian Dams - 23 Mar 2005 6:54 PM - 12 messages

Hi I have a problem on my solution where a stored procedure that normally takes about 200ms to execute will, over a period of about 1 to 2 weeks, gradually slow down to over a second. Eventially, it'll even slow down to 3 seconds to ...

Copy userdata

ALN - 23 Mar 2005 6:13 PM - 6 messages

Hi, how can I copy the userdata from one sqlserver to another sqlserver ? Best regards Axel Lanser ...

Error 15401 adding login to SQL Server

dbwmn2001 - 23 Mar 2005 6:00 PM - 2 messages

I have a SAP Server running SQL2000 on Windows 2003. Recently I migrated the server from a NT4 Domain to a AD Domain using ADMT (with SID Migration for users) and everything seems ok. Now, after one month, I have to shut down the old NT4 domain and before ...

Understanding the Hash Warning event in Profiler

pshroads - 23 Mar 2005 5:46 PM - 2 messages

I am seeing a fair amount of Hash Warnings in a Profiler trace that I am running but I don't know how to use this information. It looks like the only useful information that the Hash Warning event returns is the ...

SQL Query Analyzer

JrSnyper - 23 Mar 2005 5:27 PM - 17 messages

I can not get this query to work right it returns the records for the dates 03/19/2005 and 03/20/2005 but not 03/21/2005. Could this have any thing to do with my SQL Server collation set? My collation set is ...

Backup takes 100% of the CPU

Deena Schrier - 23 Mar 2005 4:29 PM - 3 messages

There is a Backup of a large database that takes 100% of the resources on the server. The backup takes about 1 hour. There are several other small databases on the server, but since all the resources on the machine are being ...

Meta Data

Kayode Yusuf - 23 Mar 2005 4:17 PM - 3 messages

Greetings - Can somebody please help me out with retrieving Meta Data dynamically for a Stored Procedure. I know I can use SET FRMONLY ON to retrieve it - but this return a Header info. What I want is a resultset containing that META Data that can be ...

dbcc checkdb gets hung

DML - 23 Mar 2005 3:11 PM - 5 messages

I have a server running Windows 2003 with sql server 2000 8.00.973 hot fix level that is hanging when I run dbcc checkdb on one particular database. It keeps getting io and cpu time -- but just runs and run and runs. ...

Number of CAL's for SQL Server 2000 SP3 & ASP app

Stewart Harrison - 23 Mar 2005 3:05 PM - 3 messages

I need to know how many SQL Server 2000 CAL's I will need to serve an ASP web application that will connect to our SQL Server. The application vendor told me to ask Microsoft, so I'm asking in this ...

SQL Server 2005 Question

T. - 23 Mar 2005 2:38 PM - 3 messages

Hi there...just wondering if the MS SQL Server 2005 Express Manager CTP is the same thing as the beta? If I install Express Manager, am I getting a full version of 2005, or just a new enterprise manager type tool? ...

Question about the use of filegroups

war_wheelan - 23 Mar 2005 2:23 PM - 15 messages

I want to MOVE older tables to a separate filegroup on a monthly basis and I need the tables to remain part of their original database. I read the following in BOL. Filegroups can be created when the database is first created or later ...

GETDATE() as default value is out of sync

ccarson - 23 Mar 2005 2:06 PM - 12 messages

I have a table which has several date fields (SessionStart, TransStart, TransEnd, SessionClose). The SessionStart field is populated on insert with the default value GETDATE(). After this record is inserted, I update the other date fields in order as the transactions arrive. ...

Moving tempdb

Skc - 23 Mar 2005 1:51 PM - 4 messages

Hi, We have a Dell PowerEdge with 12GB assigned to C. We have noticed that Tempdb is around 5GB or 7GB in size and is killing performance. We want to move tempdb to a volume on the machine (e.g. T which has 40GB ...

MS SQL 2k db and damaged log file

Fibre Optic - 23 Mar 2005 12:55 PM - 5 messages

Hi ALL, I would like to attache my data base but I have damaged log file. Could some one explain how to play with such a DB ? Does anyone know howto dump data from *.mdb file without MS SQL 2k server ? ...

sql licences for 100 users ?

scott - 23 Mar 2005 12:37 PM - 7 messages

Hi, I have a client that wants to host our sql database in another db app on lynux as sql licences are too expensive. (about 100 users) As far as i understand: - a single processor licenes for sql allows unlimited connections to sql ...

automatic Restore Solution with 2 Server.. need help

Klaus - 23 Mar 2005 12:32 PM - 2 messages

hi @ll I looking for a solution like I have a Server A with a Backup Job every 4 hour's and a second Server B to restore/recovery the backup DB's. Is there any way to run the recovery process automaticy every 4 hours depend ...

SQL server INstallation

Arvi - 23 Mar 2005 12:05 PM - 2 messages

Hi, I am trying to install SQL server 2000(32 bit) on a windows 2003 64 bit server. currently without SP. Although when startin setup, it says not below SP2 supported it gives an option to ignore and cancel. On ignoring it continues and finally after everything at the stage ...

Performance hit for cross-database partitioned view (on same serve

DBA72 - 23 Mar 2005 11:53 AM - 3 messages

What would be the performance difference for a view spanning multiple tables in separate filegroups but in the same database as opposed to the same view spanning tables in different databases (all on the same server). Since the execution plan is the same, I would think that there is no ...

Last allocated extent

CC&JM - 23 Mar 2005 11:39 AM - 4 messages

Hello, Is it possible to know the last allocated extent in a datafile? I want to know this information to know(estimate) how much space will be free when i shrink one datafile. Another thing that would like to know is if its possible to shrink one ...

Update a database

Anki - 23 Mar 2005 10:33 AM - 6 messages

Hi All the information on database A (on an SQL2000 Server) has to be 'added' to another, already existing database B on the same server, before deleting database A. Could you please advice which is the best way to do this? ...

How to change Database name in SQLServer?

news.microsoft.com - 23 Mar 2005 8:35 AM - 4 messages

I want to change some Databases' name. But the only way I know is backup the database, and change another name when recovering it. Is there any other way that is easier than that below? thanks zlf ...

Service Manager Auto-Start works intermitently

news.starhub.com.sg - 23 Mar 2005 7:46 AM - 2 messages

Hi ! My service manager for SQL Server is set to Auto-Start on boot up. However this happens intermittently - sometimes it auto starts and sometimes it doesn't. When it doesn't, I ran it manually and it does show that the option to ...

Table-Statistics

Jiteshk - 23 Mar 2005 6:45 AM - 4 messages

Where do information( in which table) related table statistics is stored ...

About Identity Column

Ellis Yu - 23 Mar 2005 3:32 AM - 6 messages

Dear all, I use the identity property that makes generating unique numeric values in my table "OrderDetail". Its primary keys include the column "OrderHeaderNo" and the identity column. It's fine up to now. But I wonder ...

LEFT Join Problem

Daniel - 23 Mar 2005 3:17 AM - 9 messages

We would like to restrict the number of records returned in a LEFT JOIN query but we find that it doesn't work as it supposed to be. Query: select t1.statdescr from table1 as t1 with (nolock) left join table2 as t2 ...

best location for the tran log?

T Dubya - 23 Mar 2005 1:42 AM - 4 messages

I have a SQL 2000 database on RAID 5 storage. The data files and the tran log are all on the same RAID 5 volume - the E drive. My only other option for placement of the tran log is a partition of the system drive ...

KB article 871973 Missing

Lee Jackson - 23 Mar 2005 12:55 AM - 2 messages

Hi, Iwas given a MS KB article number (871973) so i could read up on making a backup of your live data and restore it on the test company. However i can not find it Can anyone either give send me a link to a alternative article or give me a ...

SQL Server 2000 x64 Edition?

Harlow - 23 Mar 2005 12:53 AM - 5 messages

Does anyone know if Microsoft will have an x64 version of SQL Server 2000? I see there is a link to "Windows Server 2003 x64 RC2 Customer Preview Program" on Microsoft's 64-bit SQL Server 2000 home page, but no specific ...

SQLServer Performance /Processor License

kpxus - 22 Mar 2005 11:07 PM - 6 messages

I have Enterprise SQL2000 sp3 running on 2 processor hyperthreading enabled Server. But we are using 1 processor license. The performance counters showing system context switches/sec 7911 (Maximum peak for a day) process : total pagefaults/sec 4488 (max. peak for a day) ...

recovery model and dbcc dbreindex

Craig H. - 22 Mar 2005 9:32 PM - 3 messages

Hello, I have a log file that grows significantly during DBCC DBREINDEX. Does anyone know of a good reason why I shouldn't switch the recovery model from FULL to BULK_LOGGED, perform DBCC DBREINDEX and then switch back to ...

Profiler question

John Oberkehr - 22 Mar 2005 9:21 PM - 4 messages

Is there any way for Profiler to display the number of rows that were returned to the client from the SQL that was executed. I have been looking and all I can see are the reads and writes, nothing dealing with the number of rows returned to the client. ...

Removing a server

Jeff - 22 Mar 2005 9:18 PM - 3 messages

I am trying to remove a server name from SQL Server 7.0 server by using the, sp_dropserver 'SERVER2' but keep getting the error of 'There are still remote logins for the server 'SERVER2' SERVER2 no longer exists. How can I remove this server ...

calling use @dbname in a cursor

MANCPOLYMAN - 22 Mar 2005 8:59 PM - 3 messages

Folks, I am trying to use a cursor to run space check on each db on the server OPEN cur_DBs FETCH NEXT FROM cur_DBs INTO @DBName WHILE @@FETCH_STATUS = 0 ...

My SQL7.0 Problems

AnytimeAnywhere - 22 Mar 2005 8:57 PM - 3 messages

I have a SQL 7.0 DB that is working fine, except for some records that a user deleted. She wants me to restore them. My normal process for restoring SQL data is to restore last night's backup to a test DB and let ...

xp_sendmail: failed with mail error 0x80040115

BJ - 22 Mar 2005 8:49 PM - 6 messages

Hello, I know it is weired. There was a network outage in our data center, which also involved reboots to many machines suddenly. When the dust settled, my xp_sendmail no longer is working. config: win2kadv server, MS sql 2000 Ent Ed, sp3a ...

Simple Recovery and the T-Log

Robert Richards via SQLMonster.com - 22 Mar 2005 8:47 PM - 6 messages

If I were to be in Simple Recovery mode and executed the following statement, would there be a record of it in the T-Log? update table_a set col_a = 1 where col_a = 0 ...

Change Coalition for Instance

Frustrated with two clients that can't connect...

Insufficient Memory error - SQL Server not utilizing available mem

RAID

Index troubles

SPC hangs on open cursor, how do I debug??

Why can't I do this in a script?

Connecting web pages to SQL Server

Delete a transaction log

How to Delete Transaction Logs (.TRN) from T-SQL Script/Job??

Default option for fields

Job Sequencing ?

Transaction Log

sql does not release memory

Do Named Pipes work across a WAN?

Named Instance stack dump upon startup

Need Help: SP fast in QA, slow in APP

Detach/Attach database

SQL Mail doesnot work...

Input dates before year 1753 ?

Not a BUF latch. Error Re-Indexing

Enterprise Manager driving me CRAZY!!!

Foreign Key Constraints and Circular References

sql 6.5 on NT4.0 in 2003 mixed mode enviroment

SQL Server 7 Service Pack 4 being painful (memory leaks?).

SQL 6.5 to SQL 2000

Last part of deadlock

NEWBIE question for ya!

enormous transaction log dump

change sa password for sql agent

Naming standards for tables, sprocs, and other object names

Not enough memory

SQL Code for age

Newbie - can I do this in a script

How to get all the databases' db_owner's group's user names on one Server in one Script

Log Shipping Problem

shrinking database question

Logfile problems - again, catch 22 situation

performance Problems

dropping and recreating a table

Database conference ...

Stored Procedure limits records to 10,000

User access in read only database

SQL Agents

restoring from 7 to 2000

BUILTIN\Administrators Account

What's the equivalent to access' database compress/repair-function

SP3a concurrency errors

Equivalent of ROWNUM in MS-SQL

Database Copy

LEFT JOIN and NULL

Backup Database ?

Reducing log (ldf) file size

can i using linked Server in mssql server 64 bit version?

How full backup work ??

Delete records without logging

Q: default vaule for a field

Enterprise manager freezing

Restore the Stored Procedure - No backup

Number of characters in a "IN" clause

Query Analyser not displaying results...

measuring traffic

prevent database listing

sa userid and Paranoia

Page Splits - What tables?

DB Maintenance Plan not working properly

Install SQL Server in flash drive

SP3 for SQL Server 2000

database maintenance plan

Pros of having SQL server added to AD

Create table on multiple Filegroups .. is it possible ?

Filegroup restore

Can't connect to SQL Server (developer edition) from another PC?

How to enable TCP/IP on SQL Server

Probably somebody entered my laptop via SQL server. Please, help.

Estimating the Size and Growth of a Database / Table

Error Converting data type