SQL Newsgroups: Microsoft SQL Server Administration

Quest for Monitoring

Hassan - 10 Jun 2006 8:36 PM - 2 messages

Can anyone comment on the use of Quest for monitoring SQL Servers ? Is it worth the spend ? Thanks ...

Startup stored procedures

noam - 10 Jun 2006 7:56 PM - 5 messages

Hi, how can I know if there is any Startup stored procedures in my sql server, and who create them by the t- sql command? Thanks ...

SQL 2000 table definitions

Rick - 10 Jun 2006 7:35 PM - 4 messages

I really blow it here. I deleted a database without have a backup. I want to get the structure back (the data is not important). I have a backup of the master and other system tables. Can I use them to get the structure? Is the ...

Sql2000 + Sp4:job run to much slow

Loris - 10 Jun 2006 2:51 PM - 10 messages

Hi, I'm a Italian developper and so sorry for my bad English. My problem is: On Sql2000 Sp4 my stored procedure takes 45 minutes for running on 8 Gb databases. The same stored on the same databases invoked by a job, without ...

Can a stored procedure open excel and call a macro? or vice versa

Mike - 10 Jun 2006 1:59 PM - 2 messages

I googled it but found nothing. I've seen where excel can call a stored procedure to return a record set but what if my stored procedure returns several record sets, how does excel handle that? Thanks ...

Install sql 2000 local database in standalone machine

badushag - 10 Jun 2006 1:42 PM - 2 messages

I installed client tools & connectivity in my xp machine with sql server 2000. I need to install local database. But I face problem when I tried to install MSDE. Its showing an error message "Error reading from file C:\Program Files\Microsoft Sql Server\MSSql\\Bin\comnevnt.dll. Verify ...

reproducing deadlocks

vicky - 10 Jun 2006 7:21 AM - 2 messages

I have done some research in how to avoid and view trace logs for deadlocks. now iwant to test this on my test db. Is there any steps by which deadlock can be reprduced in any test dbsay authors or pubs? ...

sqlserver express varchar has trailing spaces

timasmith - 10 Jun 2006 5:10 AM - 7 messages

Hi, I installed SQLServer Express, created an ODBC connection and connected via the JDBC-ODBC bridge to run some basic insert statements. I couldnt get the SQLServer JDBC driver to work. However trailing spaces seem to be appending to my data, causing ...

Shrinkg log file on live production server

Pooja - 10 Jun 2006 4:24 AM - 4 messages

Hi, I had quick question regarding shrinking only transcation log file directly on production server. I have simple recovery model and we don't use the transcation log but i would like to reduce the size of log since there is ...

SQL 2005 SP1 upgrade failure. Some of my servers pass, most fail

Chris Auer - 10 Jun 2006 1:17 AM - 5 messages

Here is the log from most important server to me. Thanks for any help anyone can be. 06/09/2006 20:22:44.806 ================================================================================ 06/09/2006 20:22:44.821 Hotfix package launched 06/09/2006 20:22:47.584 Product discovery successfully completed during ...

Migrating to a new server

GaryC - 9 Jun 2006 11:12 PM - 6 messages

I currently have SQL running on an server that used to be used for call center operations. There are many orphaned applications on this server and we are planning to back up the server, reinstall a freash copy of 2000 server ...

Can't use DAC in SQL2K5.

ChrisR - 9 Jun 2006 10:47 PM - 6 messages

SQL2K5 No SP. Im trying to test out Dedicated Administrator Connection for my first time and getting an error message: ____________________________ Cannot connect to admin:Server\InstanceName. Additional information: DAC's are not supported. (ObjectExplorer) _________________________ The Browser service is running. ...

Dynamic SQL Over 4000 characters

cbrichards - 9 Jun 2006 10:42 PM - 4 messages

I have created a parameterized statement in a T-SQL procedure that uses sp_executesql such as the following: --****************ORIGINAL STATEMENT************************* DECLARE @sql nvarchar(4000) SET @sql = ' SELECT ... FROM ... ...

Option (maxdop 1) in a Veiw

datagal - 9 Jun 2006 10:19 PM - 2 messages

I have a big unioned query that requires the (maxdop 1) option to run. But when I out the query in a Create View if fails on the Option statement. If i take the Option statement out, the View generates, but when I try to ...

Performance Issues - Identical DBs but different servers

BTabios - 9 Jun 2006 8:14 PM - 5 messages

Hello Everyone, Here's the scenario. We have a production webserver server and a development web server. Both are running SQL Server 2000. I encounted various performance issues with the production server with a particular query. It would take approximately 30+ seconds to return ...

Any possible optimization for the following SQL statement

fzhang - 9 Jun 2006 7:30 PM - 3 messages

Hi all, I am relatively new to this group and forgive me if this question is too trivial... Say, I have an audit table AccountAudit that contains account records. When each batch of rows are inserted, the timestamp is saved at ...

HOw do I make a SQL database --30GB ?

naijababy - 9 Jun 2006 6:38 PM - 3 messages

We need to make a 30 GB SQL database that is going to be tested on our fibre drives. Please point us in the right direction. Is there anyway to generated SQL databases of any size? Thanks for your help ...

Creating SQL Server Database / Tables

JD - 9 Jun 2006 6:26 PM - 2 messages

Could someone please point me to a tutorial that would show me step by step how to create a database in SQL 200 / 2005? I have never created any database but pretty much a power / technical user. Just for example, ...

Transaction Log File

AJ - 9 Jun 2006 5:30 PM - 4 messages

You can't actually view the transactions in the transaction log file, correct? I know this must be a silly question, but somebody asked me how to do it.... and I want to be sure there isn't something I don't know about. ...

Different Restore Error

MGeles - 9 Jun 2006 4:31 PM - 2 messages

I get the following error when I try to restore a database on a SQL 2005 server TITLE: Microsoft SQL Server Management Studio Express ------------------------------ Restore failed for Server '172.27.101.60'. (Microsoft.SqlServer.Express.Smo) For help, click: ...

Restore diffs gives an error.

_Stephen - 9 Jun 2006 4:19 PM - 6 messages

I am doing a practice run restoring a server. I just got a what a DBA should do from my boss so I thought that I'd date all the bullets that I have done or do them on a regular basis. ...

Restore dbase but leave 1 table the same

Paul - 9 Jun 2006 4:13 PM - 5 messages

I have 2 servers and am migrating data occasionally from one server to the other. There are several tables but one of the tables I do not want to be updated by the restore. Just wondering if there is an easy way to do this? ...

MSDE 2000 how many users

Rafael Tejera - 9 Jun 2006 3:17 PM - 4 messages

How many users and transaction can handle MSDE 2000. I have an application with 2 pc and I would like to know if MSDE 2000 would work perfectly on that environment. I was reading the MSDE documentation and I did not found anything about it. Any additional information I would appreciate. ...

Replication Question

cynault via SQLMonster.com - 9 Jun 2006 3:16 PM - 3 messages

I have continuous transactional replication running from a production server to a reporting server. Both servers are SQL 2000. A week or so ago, a new column was added to a table being replicated (on both production and ...

Restoring a database from a .trn file

log2ins - 9 Jun 2006 2:43 PM - 7 messages

Hello, I have received a .trn file and I have to fully restore a database into SQL Server 2000 from it. Is it possible? And, if yes, how can I do it? Thanks in advance for the help, Antonio ...

errors... lots of errors.

Heather Mac - 9 Jun 2006 2:18 PM - 2 messages

Good Morning... Any thoughts.... Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionWrite (WrapperWrite()).Native error: 4 SQLState: 01000}{[Microsoft][ODBC SQL Server Driver][Shared Memory]General network error. Check your network documentation.Native error: 11 SQLState: 08S01} The following information is part of the event: ...

SQL Server on the SAN Installation

robboll - 9 Jun 2006 1:49 PM - 7 messages

I am installing SQL Server 2000 and all System and User Databases on a Server with a Storage Area Network (SAN) drive. Everything will be installed on the SAN drive. I believe that in the future when I want to replace the server all I ...

Active Directory Linked Server Fails After Upgrade to SQL Server 2

Jonathan Palmer - 9 Jun 2006 1:35 PM - 6 messages

We had an SQL Server 2000 instance running on Windows 2003. This was querying a linked AD server running on Window 2000. The query we run is as follows: SELECT location FROM OpenQuery(python, 'SELECT location,title, displayName, sAMAccountName, givenName, telephoneNumber, ...

The multi-part identifier "x.y" could not be bound

Joe - 9 Jun 2006 10:43 AM - 2 messages

I get this message for some logins and not others - any decent explanation why? TIA ...

list of stored procedure changes

Joe - 9 Jun 2006 10:42 AM - 4 messages

I noticed that there is an inbuilt report in SSMS for the "Schema Changes History". My questions are simple - how is it achieved? Is there a system view I can use to achieve the same? Is there a setting which controls ...

aarich event error when backup is run on big DB

Friendly - 9 Jun 2006 8:04 AM - 8 messages

Hi all... Let me first explain why I posted this here... I have run this error past Microsoft and Gigabyte, and both cant help me, so now I'm turning to you guys :-) What happens is that I got a job set up on SQL ...

Profiler to track Triggers

maxzsim via SQLMonster.com - 9 Jun 2006 7:40 AM - 3 messages

Hi , Can profiler be used to track and execution of a trigger ? if so what are the event(s) that i should display appreciate ur advise tks & rdgs ...

Backup Software

Robert - 9 Jun 2006 7:12 AM - 4 messages

We are using SAN for the SQL Server 2000. Someone mentions that since SQL Server is using cache during operation, when we do the sanpshot of the SAN, the cache value has to be written to SAN. Is it correct, what is the exact steps for this mechanism ? ...

Inserting NULL when foreign key gets deleted.

Aayush Puri - 9 Jun 2006 6:34 AM - 3 messages

I have a couple of tables in my database (SQL server 2000) 1. Student -- Columns are as "StudentID" -- INT "StudentName" -- NVARCHAR "DepartmentID" -- INT 2. Department -- Columns are as "DepartmentID" -- INT ...

partitioned views in sql server 2005 question

Pedja - 9 Jun 2006 3:33 AM - 2 messages

Hi, We have table which should keep only 1 year of data (probably around 200GB). We want to partition it (by month), however since we have sql server 2005 standard edition, we cannot implement partitioned table.The only remaining solution would be to use partitioned view. ...

Server Thrashing the CPU

SteveM - 9 Jun 2006 2:56 AM - 6 messages

We have a client with a SQL Server 2005 installation that has started thrashing the CPU. The server houses a BizTalk installation and a database for a mobile application. The thrashing seems to be continuous and just started today - no changes ...

Full-Text Catalog

Scopus69 - 9 Jun 2006 1:50 AM - 4 messages

I just recently failed over to my secondary SQL server via log shipping while I was moving my production equipment to another data center. Once I got my production equipment back up and running I copied the database back over with ...

Monitoring sql statement ran against a table

maznblue@gmail.com - 9 Jun 2006 1:49 AM - 4 messages

I need to know if there is a way to either record all queries ran again a particular table or to fire off a trigger if a particualr row is selected from that table in sql server 2005. The main issue I am ...

SQL Server Express 4 gig limitation

Ken - 9 Jun 2006 1:00 AM - 2 messages

Considering SQL Server Express's 4 gig limitation, I'm wanting to know if this limitation exist only for the .mdf database (data) file or both ..mdf file and .ldf (transaction log) file combined? ...

replication sqlserver2000 to sqlserver2005

tech101 - 9 Jun 2006 12:19 AM - 3 messages

Hi, I want to replicate all Updates, Inserts and Deletes (possibly indexed view changes) to a whole database from sql server2000 (live server) to sql server2005 (reporting server), but I only want to do it every night to at an interval that I choose. (Note I don't want to replicate ...

The 'subject' in SQL Mail

dschmeck - 9 Jun 2006 12:07 AM - 3 messages

I'm using the following code in a trigger: (in SQL Server 2003) And while a message is successfully sent and it includes the appropriate message and recipient data, the subject is constantly left blank. Any help on this would be much appreciated. ...

Deadlock trace interpretation

cbrichards via SQLMonster.com - 8 Jun 2006 11:58 PM - 3 messages

I have the following from a DBCC Trace: 06/08/2006 16:29:02,spid4,Unknown, 06/08/2006 16:29:02,spid4,Unknown,Wait-for graph 06/08/2006 16:29:02,spid4,Unknown, 06/08/2006 16:29:02,spid4,Unknown,Node:1 ...

Does displaying the estimated execution plan change anything?

Danny - 8 Jun 2006 11:20 PM - 2 messages

Generally I would think that having a query in query analyzer and displaying the estimated execution plan would not change anything in the system but ran across an interesting problem today that makes me think otherwise. On SQL Server 2000 sp3a, I have a table with 300,000 rows in it. The table ...

Recovery mode 'magically' changing

mryan - 8 Jun 2006 11:04 PM - 6 messages

I have a database that is the source in a logshipping pair (SQL2k, SP3a) that is 'magically' changing from Full Recovery to Simple Recovery. Is there a trace flag I can turn on to catch this change and where it is being triggered from? ...

Records getting deleted from SQL Server 2000 with Access linked Tables

razisyed - 8 Jun 2006 10:18 PM - 5 messages

I hope someone can help in solving this problem. I have a VB application that is accessing data from SQL server 2000 through linked tables in MS Access. It all works very well, except every once in a while, a record gets deleted from SQL Tables. I know for sure that the ...

Need help understanding fn_get_sql and the stmt_start and stmt_end columns

pshroads - 8 Jun 2006 10:17 PM - 2 messages

I have been using fn_get_sql for sometime now to get information on running processes. I have been passing the handle of an active SPID and fn_get_sql returns the text of the stored procedure that is running. Then I came accross a script that someone wrote that gets the actual ...

Universal Time

Nery Martinez - 8 Jun 2006 10:13 PM - 2 messages

Hi, Is it possible to change the time from UTC to other time in SQL Server 2000?. I dont find any settings for that. thanks ...

datetime error

Eduardo Sicouret - 8 Jun 2006 10:06 PM - 4 messages

Hello, Need some help with this: I have SQL server 2000. I run a query with the following where clause: WHERE last_call_date >= '2006-06-01 00:00:00' AND last_call_date <= '2006-06-02 23:59:59' ...

How to interpret the profiler trace

yangshiyong - 8 Jun 2006 9:44 PM - 3 messages

All, Thanks in advance for your help. Any help is appreciated. I have a urgent production deadlock issue. Because of the deadlock, one of the import applications is killed by SQL Server. I tried to find out the reason of deadlock. I run the SQL Profiler and ...

Date Format - SQL Server 2000

Bob - 8 Jun 2006 9:31 PM - 4 messages

If date format is set by default language and the default language is set to English and English has a mdy format, why would dates come out as ymd when queried? Is it possible to set the date format on server level so that ...

Find location of data files

sqlteam32 - 8 Jun 2006 8:27 PM - 5 messages

What is the tsql cmb to view the file structure location on a database? This will help me with my attach and detach. ...

Do we have BCP on linux platform?

Maxwell2006 - 8 Jun 2006 7:54 PM - 6 messages

Thank you, Max ...

Sql Server - TRN Log shrink or truncate.

Uday - 8 Jun 2006 7:50 PM - 5 messages

Hi there, I guess this is the right group to post this question.... I have a SQL Server DB. We import tons of files every day. The DB data file size grows everyday. Which is understandable. But the TRN Log file also ...

Query only new records

Al - 8 Jun 2006 7:08 PM - 5 messages

Hello, Can I have some advise on how to do the following. I need to create a csv file based on a query of new records from a table. In other words the query will run periodically and I dont want it to pick up ...

Indexed Views with aggregated awareness

Eric - 8 Jun 2006 6:21 PM - 14 messages

Please correct me if I'm wrong here but what's the purpose of sql server indexed views.. I mean I don't mean to go off on rant here and please understand this is not a post to discredited ms sql server 2005 at all, I'm ...

Any way to delete rows from table and ignore Foreign Keys

TJT - 8 Jun 2006 5:47 PM - 2 messages

I am trying to delete data from a table which is being referenced by a lot of tables by Foreign Keys. There are 2 tables in particular that do not have an index on the Foreign Key field referencing the table that I am ...

SQL express problems

Hareth - 8 Jun 2006 5:42 PM - 2 messages

i reinstalled sql express & i noticed they totally locked it down & added a SQL Server Surface Area Configuration.. the prob is when i create a visual studio sample website it cant connect to SQL bc some prob see attch ...

renamining a users login name in SQL2000

davidw - 8 Jun 2006 4:57 PM - 7 messages

Does anyone know how i can rename a users loginname in SQL 2000? The link below explains how i can rename a user but not the login name [link] USE AdventureWorks; ...

SQL backup to NAS

Cyber-Guy - 8 Jun 2006 4:23 PM - 4 messages

Greetings, I've got a small/big problem, which is the following. Got a server running Windows 2003 server with SQL 2000 and would like to backup my database to a NAS. I was able to configure the NAS to allow the ...

Testing of clustering in 2003 / 2005 environment

_Stephen - 8 Jun 2006 4:08 PM - 4 messages

I am looking to set up some stress tests on a pair of older SQL Servers. I have upgraded the OS & DB for each so I have the best available. If tests pass, I am clear to upgrade production. ...

Deny view on system tables and views

Chris Leroquais - 8 Jun 2006 4:08 PM - 2 messages

Hello, Through a GUI, my users can see all the system table or views. I want to hide these tables and views so the users cannot see them in the list. Is it a good idea to: use master; deny select on 'systemTable1' to Public ...

DTS Package

Johnfli - 8 Jun 2006 3:47 PM - 2 messages

How can I have a DTS package rename a file? for example, I have a file c:\temp.txt I would like to have a DTS package change it to c:\temp060806.txt (the numbers is teh date) ...

Memory Management on cluster

emnova - 8 Jun 2006 3:32 PM - 3 messages

I have an active/active two node cluster, each node runs Windows 2000 Advanced Server and SQL 2000 Enterprise Edition. Each node has 3.7 GB of memory. The 3GB switch is enabled on both nodes. When SQL Server on nodeA fails over to nodeB, will this instance only ...

Database retains size

Eduardo Sicouret - 8 Jun 2006 3:08 PM - 11 messages

Hello, I have this 10 GB size database and unfortunately i'm running out of space in my HDD. I'm using SQL Server 2000. before i use dbcc shrink file on the database data file, the result of sp_spaceused are the following: ...

SQL 2005 script

mecn - 8 Jun 2006 2:53 PM - 7 messages

Hi, I have a SSIS or DTS package in sql2005. How do I convert the package to a sql script so I could run it. Thanks ...

Shrink Transaction Log File

Joe K. - 8 Jun 2006 2:50 PM - 5 messages

I have a SQL Server 2000 database the data file is 12 GB in size, the database transaction log file (Med_Forms.ldf) is 72 GB in size. The used disk space on the transaction log file is 70 GB. ...

No current backup?

Bilal Abbasi - 8 Jun 2006 2:18 PM - 5 messages

Hello All, The hourly sheduled appends to the trasnaction log file start genereating the following in the output log. There is no current database backup. This log backup cannot be used to roll forward a preceding database backup. [SQLSTATE 01000]. ...

BAK, TRN files

Adrian - 8 Jun 2006 2:07 PM - 2 messages

Hey all, I know *.BAK and *.TRN files are backups and logs. But it is ok to delete them if you are running server backup IE Using Arcserve. We seem to be constantly running out of space on your drives so I have been ...

Simple distributed transaction example does not work

Scott Nichol - 8 Jun 2006 2:01 PM - 6 messages

I cannot get distributed transactions to work on a single server. I am hoping that someone can help. As the simplest test I can imagine, I have added a linked server pointing to the local server by doing EXEC sp_addlinkedserver @server='pubsserver', @provider='SQLOLEDB', ...

SQL performance loss when using parameters

sorenhansen.dk - 8 Jun 2006 11:54 AM - 6 messages

Hi, I have a performance problem with som SQL, and I hope someone can help me. When I run the SQL using a parameter, the query takes ~1.30 min to complete. If I use the value of the parameter directly in the SQL, the query ...

Index Rebuilding

csajid - 8 Jun 2006 11:39 AM - 4 messages

Hi, I am going to Rebuild the index on tables of production database. I will use 'dbcc dbreindex' command to do this index rebuilding. Now, I want to know what are the Prerequisites should i take to do ...

Microsoft SQL Server 2005 Setup The cabinet file 'Sql.cab' required for this installation is corrupt

Diamondas - 8 Jun 2006 11:36 AM - 2 messages

Installing SQL 2005 install in progress sertup error : "Microsoft SQL Server 2005 Setup The cabinet file 'Sql.cab' required for this installation is corrupt and cannot be used" ...

reporting user access rights on SQL7

Peter Geelen - 8 Jun 2006 10:40 AM - 2 messages

I need to migrate a SQL 7 database server (in domain 1) to a new SQL 2000 (in another domain 2). To map the users from the domains, I need to know which users are configured on the databases, plus which access rights and roles they have. ...

Help for thin SQL Server

Merry.Win - 8 Jun 2006 9:32 AM - 2 messages

Hi,everyone I am a newbie to the SQL server. In my project,I need a SQL server in minimal size to meet the XPE environment. How can I get the goal mentioned above? Where can I find the technical articles or files needed for building minimal ...

Unable to connect to SQL Server 2000 Default Instance

Robert - 8 Jun 2006 8:50 AM - 8 messages

Hi, I worked out that in the existing server (SQL Server 2000 on Windows 2003 Server with SP1 installed but Firewall hasn't been activated), a developer has installed a named instance and there is no default instance. I installed the Default Instance and am able to connect it locally (Register ...

error:40 connecting with sql server 2000

chrisbarber1 - 8 Jun 2006 8:28 AM - 5 messages

Hi I am getting this really annoying error that I cant resolve. I have created a website that accesses a SQL SERVER 2000 database and it works perfectly on my home machine. The error has occurred when I have transferred it to my hosts server. ...

For a newbie in SQL Server 2005: Backup and restoration of a database SQL Server 2005

Bruno - 8 Jun 2006 7:37 AM - 3 messages

Hello, First, excuse me for my poor english. Being an absolute beginner in the installation and the use of SQL Server 2005, I allow myself to ask of the assistance on the procedure to set up to safeguard a data base and the procedure of ...

Operating system error = 32(error not found).

Jet Lai - 8 Jun 2006 7:11 AM - 5 messages

Dear all, i try to backup abc.bak(21G) TO remote Server every night. But the system gave me the following msg: BackupDiskFile::CreateMedia: Backup device '\\bkupsvr\dump$\abc.bak' failed to create. Operating system error = 32(error not found). ...

How to read the value of DEADLOCK_PRIORITY

Franck Fouache - 8 Jun 2006 7:00 AM - 4 messages

Hi, a simple question, i want to know the value of DEADLOCK_PRIORITY, where and/or how to read it ? Best regards. ...

SQL 2005 Multiple Instances

SQL DBA Consultants - 8 Jun 2006 6:23 AM - 2 messages

I want to know the best practices & recommendations on running multiple on one OS in SQL 2005. ...

how to display 10 rows at a time when 1000's returned form sql query

Daniel - 8 Jun 2006 5:15 AM - 3 messages

how to display 10 rows at a time when 1000's returned form sql query how to select the 20th-30th row in a where clause? e.g. select the 20th to 30th employee who name is 'bob' in tsql. i need this because my select often ...

Debugging triggers on views in SQL Server 2005?

BrianInHouston - 8 Jun 2006 3:14 AM - 3 messages

I am trying to debug an "INSTEAD OF INSERT" trigger on a view in SQL Server 2005. I setup a stored procedure to insert to the view, then (in Visual Studio) put a stop in the stored procedure. This works fine, until I try to ...

SQL Newbie Performance question

Charles - 8 Jun 2006 1:45 AM - 3 messages

I will be running Windows Server 2003 Enterprise Edition as well as SQL 2000. I want to go with 4GB of RAM. I want a SQL cluster environment which would include having an external direct attached storage system. I ...

Performance Question

Charles - 8 Jun 2006 12:55 AM - 5 messages

I have a need to configure a mission critical SQL and Web server and also looking for possible failover/redundancy We will be running Windows Server 2003 Enterprise Edition as well as SQL 2000. We want to go with 4GB of RAM. We want a SQL cluster environment which ...

Upgrading data from SQL 2000 to SQL 2005

maflatoun - 8 Jun 2006 12:39 AM - 4 messages

Hi everyone, I'm testing the upgrading of a SQL 2000 database to a 2005. This is what I do, 1. On the sql 2000 server, I create a backup of my database 2. Copy it to another server 3. On the sql 2005 developer edition server, I do a restore from the ...

Dumb question - MSSql - what is the front end?

David Smithz - 8 Jun 2006 12:39 AM - 5 messages

Hello there. If I am developing an application that I want to use MSSQL 2000 Server as the back end (Which I get as part of SBS 2003) what is the actual front end to a MS SQL database? I know Access is an option, but I am of the understanding that some people ...

Last Logins

Big Ern - 7 Jun 2006 10:29 PM - 3 messages

To anyone who could help: Let me explain what I'm trying to accomplish. We now have a business requirement that we need to track last logins on all of our SQL servers. I've been searching, reading, googling everything that I can think of and there is ...

Create Multi-server environment in the SQL 2005- need HELP

ipramono - 7 Jun 2006 9:17 PM - 2 messages

I tried to setup a master-target server for the multi-server environment I tried the step in the microsoft support page already, but I keep getting stucked with Create master wizard's third and fourth step. This is my scenario: I have computer A and B connected in my network. ...

compatibility level 80 in sql server 2005

Vadim - 7 Jun 2006 8:25 PM - 5 messages

Hi, I have a general question about the implications of setting sql server 2005 database to compatibility level 80. It will take me some time to convert and test the existing db schema and app to fully support sql 2005, so for now I ...

SQL Server 2005 Optmizer Bug

HenryJ - 7 Jun 2006 7:46 PM - 6 messages

Recently I uncovered an optimizer flaw with SQL Server 2005: Variable passed to TSQL involved in a range search on a table joined to a Very Large table (160 miliion rows partitioned no doubt) resulted in the optimizer choosing Index Scan as opposed to Index Seek. However when same ...

2601 Error When Creating or Altering a SPROC SS2005

hpux9@nospam.nospam - 7 Jun 2006 7:00 PM - 4 messages

I get the following error(in profiler) when creating or altering a stored procedure (or view) in SS2005: "Error: 2601, Severity: 14, State: 1" To duplicate create a table (table1) start profiler, add errors and warnings, start the trace, create the proc below ...

Database Engine Tuning Wizard: "Failed to initialize MSDB database for tuning (exit code: -1). (DTAC

Ian Boyd - 7 Jun 2006 6:52 PM - 2 messages

Error trying to tune a database: Database Engine Tuning Wizard: "Failed to initialize MSDB database for tuning (exit code: -1). (DTAClient) Steps to Reproduce the Problem 1. Launch Database Engine Tuning Advisor 2. Enter connection info Server Name: <The Server dns name> ...

Datafile limitations per database

kisstene - 7 Jun 2006 6:39 PM - 2 messages

How many mdf files can you use in comprising one database. I know one can setup primary & secondary but how far down the list can it go? Can you have 30 files (each limited to 50GB)? ...

SQL2000 Database taskpad view

mecn - 7 Jun 2006 6:26 PM - 2 messages

Hi, I am trying to view the database taskpad for data allocation and data sizes. It gives me an error says that an error has occurred in the script on this page...... Any ideas? Thanks ...

Interpreting Statistics IO

cbrichards via SQLMonster.com - 7 Jun 2006 6:21 PM - 5 messages

This is my orignal statistics io return: Table 'MyTable'. Scan count 1, logical reads 4338, physical reads 0, read- ahead reads 0. This is my revised statistics io return: Table 'MyTable'. Scan count 117, logical reads 536, physical reads 0, read- ...

Help-me with this error: Error: 50020 Severity: 1 State: 1 Store Procedure ((null)) fail.

Retf - 7 Jun 2006 6:20 PM - 4 messages

Hi all, I have one application that read one TXT file with 2000 lines, eache line is one exec of one SP in my DB, this SP have 6 inserts and one other EXEC SP But when exec is in line 900, 1000 or more I receive this erro: ...

Migrating SQL users from 2000 > 2005 Database

Jason - 7 Jun 2006 5:42 PM - 3 messages

I already implemented the script to migrate SQL users from one server to another. My question is, do the databases need to be moved before the script is run or do the users need to be moved to the new server ...

Sql Server connections

tshad - 7 Jun 2006 5:19 PM - 3 messages

I am having a problem where my Sql Server 2000 will lose a connection and I cannot get a connection for 5 or 10 minutes. I try to start up EM and it cannot connect. For a while I thought it was my ...

Restrictions on eval copy of SQL 2k5

MGeles - 7 Jun 2006 4:51 PM - 5 messages

I just installed an eval copy of SQL 2005 and so far I can't make a remote connection and I can't change the sa password. Does anyone know if these 2 things are restricted in the eval copy or am I just doing something wrong? ...

Triggers fire when no records are affected

RLJONES39 - 7 Jun 2006 4:45 PM - 2 messages

I just recently found out that SQL triggers fire even when there are no records affected by the SQL statement. This has caused me some grief with resulting cascading triggers. This seems like an inordinate amount processing that could be bypassed with a simple check by the SQL engine. ...

Combining two database - best way to transfer objects and data

Input string was not in a correct format in SS 2005 Developer edit

force sql to ignore dependancies

enable ansi_nulls on existing table

2005 install ques re owner of database?

Job Failure - Exception Report (msdb)

EM in SS2000

Money datatype Substring

Increasing size of NVarChar column

Setting SSIS Log properties

Deleting a field in a table

SQl server 2000 hanging after CPU upgrade

SQL 2005 newbie - execute CLR stored procedure at times specified by table data

How to se TempTables dat in Query Analazer

frequent index corruption

Query

Extended Property

2NF and 3NF

MSDE incomplete install

SQL Express Table and Column limit.

How to insert date in database table in sql server

Querstion: update on joined field

Loading issue with newly restored db

cost

CONVERT Money Char(20)

Timeout expired obtaining a connection from the pool

Including view primary keys in relationships

Tough SQL problem, need expert advice!!!

keep 2000 with 2005 install?

Query Help

Expiration for trial install

WaitForChildren: Children persisting. Retry: 12876

How do I tell what version of the SQL Client Tools I have installed on my system?

Transactional Replication - Adding New Articles

SQL Jobs

SQL Server 2000 - Change license mode from per seat to processor

Script runs fine in QA, not as a job

Help on Showing Querry Execution Plan in SQL Server Management Studio

Duplicating tables

how to set a schedule to run codes like

Version

Date of insertion

Not displayed maintenance option under Management

Joins Performance Problem

SQL Server 2000 features ?

Backup/DR configuration using mirroring and log shipping

SQL port number

SQL 2005 - Witness server

Stored proc question (prolly a newb-q)

URGENT : Unable to backup SQL databases

T-SQL to produce barcode 128 checksum

Cleanup Task / xp_delete_file

Unable to connect to database after migration...

What has to be changed for Named Instance ?

RS: multiple SP more performant?

SQL 2000 Databases (Newbie Qs)

Row-level locking & concurrent access

SQLServer:Backup Device(Device Throughput Bytes/sec)

Divide by zero error!!! Help!

reboot reboot reboot

delete all rows from a specific partition in SQL 2005?

sql server automatic cleanup

Transaction Log Query

W2k3 Web Edition and SQL 2005 Workgroup

The number name 'myServer.myDatabase.dbo.myTable' contains more than the maximum number of prefixes.

Upgrading a database from SQL Server 2000 to 2005

Goofy Bullsh!t SQL Server 2005 Date Values

query question, only want 1 column distinct

Uncommitted Transactions

Monitoring SQL Server with MOM

How to view the recent SQL queries run on my SQL Server?

database file has incorrect modified date

SPID DB Transaction Log Space Used

Cannot Connect to SQL Server 2000 Using Domain Account

SQL Server 2005 - DDL trigger - ALTER DATABASe

Help - can't create or edit a Maintenance Plan

sql server 2005 using more memory than max limit

how to make sensitive data encrypted in tables

2005 Agent does not start on Reboot

Upgrade Standard Edition SQL 2K to Enterprise

Stored Procedure & String Parameter Passing

Database damage

ALTER TABLE/COLUMN syntax

More ports for SQL Server

About sp_execute

What logic can I use here ...

Is running SQL on VMWare supported by MS ?

what is wait types:MISCELLANEOUS

Error with connection

SQL Server upgrade

Help! Crunch time here

Getting rid of all the "dbo." ?

SQL 2005 upgrade advisor

How do you know whether or not your transaction log file has any pertinent data in it?

Logging severity levels less than 19 ?

how can I know the proces in SP is finished ?

so I can't run ANY versions of sql server on my xp 64 machine?

A table owner to use xp_sendmail

Is there a way to do a 'skip' when doing 'select'?

Attaching 2000 dbs to 2005