SQL Newsgroups: Microsoft SQL Server Administration

SQL2005Dev, can't install.

mkayuri@gmail.com - 7 Jan 2006 9:20 PM - 6 messages

Can't install SQL Server 2005 Developer Edition on Windows XP on Virtual PC Guest, and Windows 2003 Server Standard also on Virtual PC Guest OS. The Virtual PC Host is the same computer, which has another guest OS with successfully-installed SQL2000 over WinXP. ...

Unable to move the master log file

Franc v/d Westelaken - 7 Jan 2006 7:28 PM - 10 messages

Hi, I'm trying to move the master logfile to a different location (separate log file drive). I've change the setting using the SQL configuration manager. However, as soon as I do the SQL service won't start and an event in the event log reports that it cannot find the ...

Error running .exe file - in installation of SQL Server 2005

Incabyt - 7 Jan 2006 5:26 PM - 2 messages

Hi, Prior to installing SQL Server on my computer, I was installing the .NET Framework 2.0 ....and came up with the following error while running the .exe file for it. "dotnetfx.exe is not a valid Win32 application." I have a 32 bit Windows XP Home SP2 - operating system ...

arrgent please

sanjay - 7 Jan 2006 12:51 PM - 2 messages

how can i remove \r (escape) from my data base. ...

SQL Cluster

Gopi - 7 Jan 2006 11:59 AM - 4 messages

Hi i done for new SQL cluster and its fine. i like to do for exsiting SQL database, we have database running in SAN in single server. So how to do that? we have to do fresh sql cluster installation, then move the SQL database to ...

SQL Express with VS2003?

ML - 7 Jan 2006 10:55 AM - 3 messages

Are there any issues with accessing SQL Express from VS2003? Can it be accessed with the sqlconnection just like SQL 2000 can be? ...

Help on string sorting

Raghavendra Mudugal - 7 Jan 2006 10:09 AM - 9 messages

Hello I have a customer table created in the mssql server 2000, in this table i am using customerid as "CUST_0001" and so on.. When i say order by on customerid column, the IDs are not sorted in a proper ...

difference between COUNT(*) & COUNT(1)

SouRa - 7 Jan 2006 8:22 AM - 5 messages

Hi, 1 - select count(*) from tablename 2 - select count(1) from tablename query 1 and 2 return the same value as output. what is the difference between count(*) and count(1) ? which is efficient? Please advise Thanks, Soura ...

cursors and tempdb

Dodo Lurker - 7 Jan 2006 7:16 AM - 2 messages

Do dynamic cursors utilise tempdb for processing? I can't seem to figure if that's the case. It does appear that they use memory. In fact, do all cursor types use tempdb and/or memory? ...

question about checkpoints and cache

Dodo Lurker - 7 Jan 2006 7:12 AM - 4 messages

I'm trying to understand sql server architecture and I had some basic questions for you veterans (tough questions for me) 1) My understanding of how the architecture works: data is modified, before and after copies of the modified data are first written to the transaction log. After ...

SQL Server 2005 Hardware

David - 7 Jan 2006 5:37 AM - 2 messages

All What is the best way to spec the hardware that we will need to run SQL Server 2005. Thanks ...

Full Restore Question

g3000 - 7 Jan 2006 4:40 AM - 7 messages

Did a point in time restore on Win2k Server EE MSSQL 2K EE sp3a Database does a full back at 1am Then from 4am on does a trans log backup So had all file from 1am to about 5pm ( when the restore was attempted ...

AWE Sql Server 2000 Error

punga33 - 7 Jan 2006 1:08 AM - 8 messages

I have a box running - quad 3.0ghz xeon processors 16gb ram SQL Server 2000 Enterprise Edition SP4 (patched) Windows 2003 Server Enterprise Edition I have noticed that it is only utilitsing 1.7gb of ram, so i have enabled the AWE option in SQL Server. Assigned the 'PAE' flag in the ...

Do these numbers make sense

Milan Gross - 7 Jan 2006 12:47 AM - 7 messages

I'm wracking my brain on to understand this and could use some help. The MS SharePoint 2003 documentation recommends that the SQL Server used for the portal databases should have free space equal to "200 percent of the the ...

database performance

Abraham Andres Luna - 6 Jan 2006 10:18 PM - 4 messages

hello everyone, i wasn't sure which sql newsgroup to post this question and server sounds generic enough i have a table named RDKCOCUS with 131 columns and over 44k records sometimes the server will timeout when i select using this statement: ...

SQL Agent does not start

JVman - 6 Jan 2006 10:16 PM - 8 messages

Hello All, When I try to start the SQL Agent Service, I receive the following error in the SQL Agent Error Log: [241] Startup error: Unable to initialize the error reporting system (reason: A required privilege is not held by the client) ...

SQL Server Maintenace Plans

Shabnam Gupta - 6 Jan 2006 10:14 PM - 3 messages

Hello Everyone, I am new to SQL 2005 and am trying to setup the maintenance plan for my database. In sql 2000 I had the plan setup to do full backup every night and then hourly backup of the transaction log and delete files every 7 days. ...

synchronize sql table and active directory

rodchar - 6 Jan 2006 10:10 PM - 5 messages

hey all, is there an easy way to have a table in sql synchronized with active directory information? thanks, rodchar ...

Huge Backup, Small Data

cathedr@wa.state.gov - 6 Jan 2006 10:06 PM - 3 messages

After completing the following commands: =========================== USE [myDB]; GO BACKUP LOG [myDB] WITH TRUNCATE_ONLY; GO DBCC SHRINKFILE (myDB_Log, EMPTYFILE); GO BACKUP DATABASE [myDB] TO DISK = N'D:\Backups\myDB.bak' GO DBCC SHRINKDATABASE('myDB') GO =========================== I look at the size of my files and discover that Backup is just over 2 GB in ...

SQL Server 2005 management studio remote connection problems

Rob Kay - 6 Jan 2006 7:03 PM - 4 messages

Hello. I cannot connect via SQL Server 2005 Management Studio to a remote instance of SQL Server 2005 Standard running on Windows 2003 server standard. I have configured SS2k5 for remote access using the surface area configuration tool, specified port 1500 (this box also runs SQL 2k), made ...

Upsize from Access to SQL 2005 Express Edition?

Jakob Lithner - 6 Jan 2006 6:47 PM - 18 messages

I have a database in Access 2003. I want it upsized to SQL 2005 Express Edition. What is the best way? I was surprised there were no straight forward wizards for this! It must be a very expected path for people to take ..... ...

Failed Assertion

J_Crites - 6 Jan 2006 6:05 PM - 2 messages

We're getting the following on a Windows 2003 Server, running SQL 2000 SP3a. 17066: SQL Server Assertion: File: <diskio.c>, line=670 Failed Assertion = 'filepos + CBytes <= (DWORDLONG) m_size << PAGESIZEBITS'. Any ideas? Jeremy ...

Need urgent help !!

Joe D - 6 Jan 2006 5:13 PM - 6 messages

Our backups have stopped working. The only change made was the server it self was moved from one Domain to another. Our backup scripts do work across our different domains. I've Googled and searched MS web site but have ...

Stored procedure passed parameter question

langjr15@uwgb.edu - 6 Jan 2006 5:08 PM - 2 messages

Hey again, I wonder if you might be able to help me. Im breaking apart strings in VB.NET using the substring command and passing them to a stroed procedure in sql server 2000. However in one of the strings Im ...

dts that makes updates

hongo32 - 6 Jan 2006 4:43 PM - 6 messages

hello, its posible that a dts looks the data and compara if the rows exists in target database make a update of the row and else make a insert.... thanks... ...

SQL timeouts with page locks.

Arne - 6 Jan 2006 4:40 PM - 2 messages

I was able to pinpoint why I was getting sql timeouts. It was the result of a page lock. I changed my sql statement to use the nolock Hint. Now I got table lock instead. What is the most common cause of timeouts? ...

how to get only weekdays

Dan D. - 6 Jan 2006 4:23 PM - 7 messages

Using SS2000, in QA I want to return data for only days Monday thru Friday. Is there a way to do this? Is there some function that will give me only the weekdays? Thanks, ...

Login Failed for Linked Server

DaveK - 6 Jan 2006 3:57 PM - 2 messages

In EM I am trying to create a link between two SQL SQL2K servers using NT domain logins. It works using SQL Server logins, but not with NT logins. The error message is "Error 18456: Login failed for user 'NT ...

User Rights

Patrick D. - 6 Jan 2006 3:25 PM - 2 messages

Hi, Because I had to delete and reproduce a user in AD, now I have a problem in SQL Server 2000 Standard with the rights of this user: Since the user has the same name, SQL Server does not allow to retake the ...

dbcc page

CC - 6 Jan 2006 3:09 PM - 2 messages

Hi, How can i check witch object in my database is associated with this page number? PAG: 7:1:3794813 Outup of DBCC TRACEON (1204,3605,-1) ...

Can't Add Tables To A Diagram

rlrcstr - 6 Jan 2006 3:08 PM - 2 messages

SQL Server 2000 - Latest SP, etc... I can create a blank diagram for my database, but when I try to add a table I get "Invalid Class String" - regardless of the table I try to add. I can't find anything that addresses this issue. Anyone have an answer on how ...

can't disable a job in sql2k

mecn - 6 Jan 2006 2:26 PM - 5 messages

Hi all, I have a job in sql2k box. After the box network name changed. I can't do any modification to that job anymore. It says, error 14274 can't update, add or delete a job(or steps or schedule) ...

Sql2k job failed

mecn - 6 Jan 2006 2:19 PM - 6 messages

For some reason one of the sql job keep failing with the error; BackupDiskFile::RequestDurableMedia: failure on backup device '\\testserver\test_db_200601060815.BAK'. Operating system error 64(The specified network name is no longer available.). It runs ok when I manually run. don't know why? ...

Mirroring: Not in correct state to become principal

William Buchanan - 6 Jan 2006 11:47 AM - 10 messages

I am using asynchronous mirroring. When I try to failover on the mirror server using â€œalter database xxx set partner force_service_allow_data_lossâ€ (having disconnected the primary server from the network) it sometimes fails to failover (it reports that the database is not in the correct state to ...

subscription keeps show a run status

maxzsim via SQLMonster.com - 6 Jan 2006 10:34 AM - 5 messages

Hi , I have set up a continuous replication , from the SQL Server Agent's job of REPL-Distribution category , it keeps having the status of "Executing Step 2 (i.e Run Agent) from the subscription i tried refresh it says "No replicated data are ...

Identify logged on users

Leo - 6 Jan 2006 9:53 AM - 4 messages

Is there anyway in Enterprise Manager (SQL 2000) to identify which users are logged on to a particular database? Thanks ...

Identify logged on users

Leo - 6 Jan 2006 9:51 AM - 2 messages

Is there anyway in Enterprise Manager (SQL 2000) to obtain a list of users that are currently logged on to a database? Thanks ...

adding independent agents on publication

maxzsim via SQLMonster.com - 6 Jan 2006 9:37 AM - 3 messages

Hi, I have set up replication but i want to use independent agent for some other tables according to one of the post , i shld right-click properties of the publication , go to Sunscription Options however, it's disabled i am using SQL Server 2000 sp3a , Std Ed ...

changing replication type for hourly to continuously

maxzsim via SQLMonster.com - 6 Jan 2006 4:36 AM - 6 messages

Hi All , Previously i have set up my replication to be on sync per hour but i want to change it to be continuously is there a way to do it w/o removing the existing publication & subscriber ...

Scheduled job for a backup device stopped

Rog - 6 Jan 2006 3:54 AM - 3 messages

Hi all... The are a number of real databases on our SQL Server 2000 and initially I set out a number of Backup Devices to execute both FULL and DIFFERENTIAL backups. My concern is with the FULL backups and the DIFFs are working just ...

Query Analyser/EM Windows Authentication Weirdness

kevin_pritchard - 6 Jan 2006 3:23 AM - 7 messages

Hi, When I start QA or EM using windows authentication on my PC to connect to a server based SQL Server instance it is using the Windows UID of a server admin that I would use to connect to a server using Terminal ...

Scheduled job for a backup device stopped working

Rog - 6 Jan 2006 3:11 AM - 6 messages

Hi all... The are a number of real databases on our SQL Server 2000 and initially I set out a number of Backup Devices to execute both FULL and DIFFERENTIAL backups. My concern is with the FULL backups and the DIFFs are working just ...

SQLServer360.com

comingdt - 6 Jan 2006 3:01 AM - 3 messages

Hello, I am new to Google Groups, my name is Derek Comingore. I have just recently started an online sql server community at [link] (yes I am an XBox junkie as well). The idea behind the organization is ...

xp_sendmail expects @user

maxzsim via SQLMonster.com - 6 Jan 2006 2:09 AM - 5 messages

Hi All , when i executed the following statement i got this error that says it requires a @user parameter EXEC xp_sendmail 'robertk', 'The master database is full.' how do i resolve it ? appreciate ur advice tks & rdgs ...

automate creation of staging database

usenetjb - 6 Jan 2006 2:02 AM - 4 messages

any ideas on how to automate the production of a staging db with day old production data? right now i do it by hand, taking a production db backup and restore this on top of the staging version. im not a dba so go slow ...

how to compare what has been changed between yesterday and today

itcom - 6 Jan 2006 1:58 AM - 3 messages

Hello 1/ I am looking for ways to find out what has been changed per each table. 2/ Everyday I have a full database back up bak file created - about 10G. (about 400 tables) 3/ Every day I will do a full restore of the day before yesterday database ...

error 17883

Eli Milkova - 6 Jan 2006 1:48 AM - 6 messages

Im getting The Scheduler 0 appears to be hung. SPID 6, ECID 0, UMS Context 0x03D15418. Error: 17883, Severity: 1, State: 0 Dont know about other compliants and no performance issues so far. The server is mssql 2000,multiinstance&multidatabase on w2k3. One of dbs is ...

Witness server memory requirements

Steven Berkovitz - 6 Jan 2006 1:48 AM - 8 messages

I am setting up a SQL 2005 mirror for testing purposes and was wondering if there are any defined or documented memory requirements for the witness server? Documentation only states that it needs to run on a computer "capable of ...

Internal SQL Server Error - 8624 - when executing sp

Snoopstah - 6 Jan 2006 1:22 AM - 8 messages

Hi, I have a stored proc that is executing perfectly on a database on all SQL Server instances except one. All SQL Server instances are at SP4, including the one causing me grief. I have checked the sp_configure settings and they ...

SQL training class

Q - 6 Jan 2006 1:01 AM - 5 messages

Hello: I am looking for an advanced SQL training class. Any recommendation? Thanks, Q ...

maintenance plan not working

pc - 6 Jan 2006 12:37 AM - 5 messages

hi everyone, we have a maintenance plan set up on a sql server 2000 database which is configured to backup transaction logs and also the complete database. only transaction logs are being backed up, however. also (I guess as a result of the first issue) the transaction log for ...

SQL Server agent stopped!

Paul - 5 Jan 2006 10:56 PM - 3 messages

Hi Just wondering if anyone knows what might cause the SQL Server agent to stop as I had to restart it on a SQL server recently. Thanks. ...

SQL Server 2000 on 64 bit Intel Xeon Dual Core Processor

Kamal - 5 Jan 2006 10:45 PM - 2 messages

Is SQL Server 2000 supported on Intel Xeon 64 bit processor machine? Where can I download the software? Thanks Kamal ...

How to hack NHibernate code on a website.

Aziz Vahora - 5 Jan 2006 10:35 PM - 2 messages

Hi guys, we are looking to imlement NHibernate in our company. In order to test security. I was wondering if anyone knew how or a way to possible test hecking on .net website that uses NHibernate. thanks ...

Built-In Administrators disabled!!! Please help!

D Lee - 5 Jan 2006 10:06 PM - 3 messages

We're in a big mess here: One of our groups has taken it upon themselves to cleanup some of their SQL servers of old and unwanted logins. The first thing to go on the first machine was the 'built-in administrators' group. Now, the SQL server is ...

SQL Express re-distribution clarification

PS - 5 Jan 2006 9:18 PM - 2 messages

Hello: I have an application that uses SQLExpress as the backend database server. I am planning on re-distributing sql express along with my application. One of the re-distribution options that I am planning is to have sql express be ...

2005 Express Edition Capacity

Rahim - 5 Jan 2006 8:38 PM - 6 messages

I am looking for an inexpensive (less than $200 in quantity 100 per month) database that will meet the following requirements: Max database file size 2 Gb Max number of records 2 million Record insertion rate: 10 per second Queries while inserting: Max time to complete a basic query over the 2 ...

Inequality comparisons against null question

Daniel Santa Cruz - 5 Jan 2006 8:14 PM - 11 messages

This seems very very strange. We thougth it was only an issue with uniqueidentifiers, but we have now determined that any inequality comparison between a value and a null does not result in true or false. The row with that comparison just disappears! ...

cannot connect/login error message

LizW - 5 Jan 2006 8:03 PM - 2 messages

I am trying to connect to a virtual directory where there is an application that was developed in .asp.net - it is linked to a sql server database. I am using IIS, Server 2003 and SQL Server 2000 - same server - Any ideas where ...

Indexes with Duplicate Columns

Joe K. - 5 Jan 2006 8:00 PM - 3 messages

I have a SQL Server 2000 database. This database has indexes with numerous duplicate columns and these columns are not used for covered indexes. A lot of the indexes were created initially. What is the best way to show database performance analysis before and after ...

SQL Server 2005 Performance Issues

cgOrtel - 5 Jan 2006 7:31 PM - 9 messages

Hello- Our business recently upgraded one of our servers to SQL 2005 from SQL 2000. The server has 2 2.8 Ghz 32 BIT Xeon with HyperThreading, 3GB RAM, and 500GB Raid 5 Configuration. Currently SQL is set to use a minmum 1GB of RAM ...

SQL 2005: any ideas on occasional error (7884) "No process is on the other end of the pipe."

Kirk - 5 Jan 2006 7:04 PM - 3 messages

during load testing of our application, i found this error occurred three times over the course about 9 hours. otherwise, SQL was acting perfectly fine. i think it may be happening under load, when maybe the CPU is maxed out ...

Running MS SQL under a user service account

D. Shane Fowlkes - 5 Jan 2006 6:52 PM - 2 messages

(MS SQL 2000) I have SQL Server(s) installed and running under a custom network user service account I created called SqlServerService. I have SQL Server installed and running using this network account on two separate 2003 servers. When I go into active directory and disable this network service account, ...

SQL MAIL ERROR

jcard71 - 5 Jan 2006 6:27 PM - 2 messages

Hi, I have a problem where a few of our SQL 2000 Servers are not sending e-mail notififcations. I verified everything is set up correctly and Outlook is configured with the domain user sqlagent account mailbox, but when I try to open Outlook, I get ...

Add a field

Jeff Cichocki - 5 Jan 2006 6:01 PM - 31 messages

I need to add a rowguid to 300+ tables. Is there a way to script it? Thanks Jeff ...

Deleting inaccessible Sql server jobs

sameer - 5 Jan 2006 5:33 PM - 2 messages

hi all, we have renamed a server which had sql server on it, all the databases are still on it and their is no problem accessing them at all, and now after this the sql server jobs which were on this machine and were running before the ...

Question

Kidem - 5 Jan 2006 5:14 PM - 2 messages

When someone says SQL reporting and support what are they talking about? Is there some kind of reporting tool or something!! Thanks ...

SQL server 2000 32 bits - Windows 2003 32 or 64 bits?

Bazili Swioklo - 5 Jan 2006 5:12 PM - 3 messages

What is the best version of Windows 2003 Server, 32 or 64 bits, to run SQL Server 2000 on INTEL plataforms? It is a two processor server with 4GB RAM. Is there any reliable performance comparison study about 32 bits ...

Locking while updating

niel - 5 Jan 2006 4:58 PM - 6 messages

We are currently using VB to create order numbers. Each user requests an order number as and when required. The problem is that the next in the sequence seems to be allocated on the odd occasion to more than one user. ...

Intalling Client only on a 2k or XP Pro

tshad - 5 Jan 2006 4:29 PM - 3 messages

How do I install the client tools for Sql Server 2000 standard or professional onto my 2k or XP Pro? I start going through the install of the SQL Server Componants and it tries to install the OS and says we can't install on this OS, but then goes on to ...

Single vs Multiple DB..

rcloutie - 5 Jan 2006 4:20 PM - 2 messages

Hi all, First, I'm new to SQL Server and just wondering which approach is the best. Actually, we have 7 softwares developed by our enterprise. So, we have 8 databases (7 specifics to each software and another one which is common to ...

Compatibility Level Question

Amos Soma - 5 Jan 2006 3:18 PM - 2 messages

I am a little confused on the importance of the Compatability Level setting. I have a database originally created in SQL Server 2000 that I backed up and then restored to SQL Server 2005. The compatibility level is currently set ...

SQL 2005 Default instance does not show up in server lists

Brian Henry - 5 Jan 2006 2:51 PM - 6 messages

Have a slight problem, When I view the lists of servers on our network in managment studio, our SQL Server 2005 default instance does not show up in hte list... we have two instances running... default instance and one named ...

Problems with Reporting Services

Diego F. - 5 Jan 2006 2:29 PM - 2 messages

Hi all. I'm starting with RS2005. I see in examples that there should be a reportserver site in the server, but it doesn't work in my server. I didn't install SQL 2005. Where can I see if it's installed or not? ...

new server gives login error URGENT

__Stephen - 5 Jan 2006 2:23 PM - 13 messages

This is on my web page from a log in: Microsoft OLE DB Provider for SQL Server error '80004005' Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with a trusted SQL Server connection. /admin/addconn_1.asp, line 7 I have take a new server given it the former IP of the old one, restored the ...

Narayana Vyas

RATA - 5 Jan 2006 1:43 PM - 4 messages

Article ID : 305635 Last Review : December 2, 2005 Revision : 3.1 [link] I have SQL Server 2000 Enterprise Edition and have the some reported issue in the above article, the article says that it applies to Standard Edition, ...

A Timeout Occurs When a Database Is Automatically Expanding

Murad Hashem - 5 Jan 2006 1:22 PM - 3 messages

Article ID : 305635 Last Review : December 2, 2005 Revision : 3.1 [link] I have SQL Server 2000 Enterprise Edition and have the some reported issue in the above article, the article says that it applies to Standard Edition, ...

Backup yielding Operatin System Error 33?

Dave Smith - 5 Jan 2006 11:54 AM - 4 messages

A little help please? I have a 14.2 GB database that has stopped backing up and yields the following errors in the Event log and SQL Server Log respectively: Application Event Log 18210 : BackupMedium::ReportIoError: write failure on backup device 'C:\Program ...

Error 18456: Login failed for user "sa" - already using mixed mode authentication!

Neil Myers - 5 Jan 2006 11:47 AM - 6 messages

[SQL 2000 Sp3a] "Event Type: Information Event Source: MSSQLSERVER Event Category: (4) Event ID: 17055 Date: 05/01/2006 Time: 11:42:10 User: N/A Computer: ******** Description: 18456 : Login failed for user 'sa'. For more information, see Help and Support Center at ...

how much memory does a transaction take?

peppi911 - 5 Jan 2006 11:29 AM - 5 messages

hello, i found out that it is useful while testing queries in my company to start with begin tran, to do a restore if i might forget the where clause in an update on day after a long night. but what does that cost? ...

Locks (Blocking itself) after installing Service Pack 4

Frank Schneider - 5 Jan 2006 10:27 AM - 5 messages

After installing SP4 we have a lot of Locks on the database which are blocked by itself. The behaviour seem to be the same as described here: [link] Hardware: Active / Passive Cluster W2003 on PE 6650 4CPUs / 16 GB RAM ...

Need adviceon SQL Server 2000 Maintenance Plan

jcvoon - 5 Jan 2006 10:24 AM - 3 messages

Hi: Is the maintenance plan correct ? 1. Perform DBCC CheckDB on Saturday 8:00PM 2. Transactions log backup will occurs from 8:00AM to 11:59PM occurs every 15 minute, from Monday to Friday and Saturday will start on 8:00AM to 4:00AM ...

ADODB Connection Error.

Arunkumar - 5 Jan 2006 10:18 AM - 13 messages

Error Type: ADODB.Connection (0x800A0E7A) Provider cannot be found. It may not be properly installed. /visastatus/NewEmpVisaDetails.asp, line 35 Even registering the dll "sqloledb.dll" didn't fix the problem. Added to it... The Enterprise Manager is giving an error " Provider cannot be found. It may ...

Urgent: ConnectionString is not working for password contains single quotes and double quotes

Kamal Kumar - 5 Jan 2006 10:17 AM - 14 messages

Hello, Connection string gives error in C# which contains single quote and double quote in a single password string. Can anybody tell me about the escape sequence character in sql server for connection string? I know the escape sequence character for either single quote or double ...

Unable to shrink transaction log due to log_reuse_wait_desc=REPLIC

Johnny - 5 Jan 2006 10:05 AM - 4 messages

The transaction log of one my SQL Server databases grew too big and the hard disk ran out of space in the middle of a transactional replication distribution (this db is the subscriber). I am usually able to back up the ...

Good SQL Server Site?

Lee - 5 Jan 2006 9:56 AM - 2 messages

I've been working with FirebirdSQL and Delphi for some years now. Most of our new projects will be VS2005 and SQLServer 2000/2005. Can anyone recommend a good site for learning SQL Server SP language? For instance, how do I refer to a new row/field inserted or updated in ...

Slow Select * from table

wolfman - 5 Jan 2006 8:51 AM - 34 messages

I have a problem with slow selects from one table. It only happens with one table. I have another table with more fields, more records, and some text fields to boot. Select * from tbl_guide_document -- the bigger table, with almost 7,000 ...

Upgrade License and download for SQL Server 2005

jensendarren - 5 Jan 2006 5:30 AM - 2 messages

I have a very simple request but I cannot seem to find what I need! I wonder if anyone can point me in the right direction. I need: (a) To purchase a license to upgrade from SQL Server 2000 to SQL Server ...

Urgent help (SQL server supports Russian collation)

Faheem Latif - 5 Jan 2006 4:38 AM - 2 messages

Dear All, This is faheem please help me in order to give me info regarding is sql server 2000 supporting Russian collation?, Becuase i'm unable to find out in complete collation list. Faheem NetSol Technologies Ltd. ...

update fieldname using SQL

kei - 5 Jan 2006 3:49 AM - 2 messages

How to update a fieldname using SQL statement? is it need to add a new field, copy value and then delete the old field? any faster method? Thx!! ...

Statisticsny

Mike - 5 Jan 2006 3:33 AM - 2 messages

Hi Guys: I am using bulk insert to load data in a large table. I am dropping the indexes first before loading the data. I recreate the indexes after the data has been loaded. Does recreating the indexes update the statistics also? or ...

How SQL server perform JOIN

jcvoon - 5 Jan 2006 1:35 AM - 10 messages

Hi: SELECT Itm.CompanyCode, Itm.BranchCode, Itm.ContainerKey, Cont.OrderNo, Cont.StateContainer, Cont.StateHaulage, Cont.MovementCode FROM IntTruckMovement Itm INNER JOIN IntContainer Cont ON Cont.CompanyCode = Itm.CompanyCode And Cont.BranchCode = Itm.BranchCode And Cont.ContainerKey = Itm.ContainerKey ...

Limiting user records

tascienu - 5 Jan 2006 12:25 AM - 10 messages

Hi, What is the best way to limit the number of records a user can insert into a table. Basically, I want to set something like 50 records. If the user tries to insert the 11th record, I want the action to FAIL, ...

Replication error on a non-replicated DB?

AaronL - 4 Jan 2006 11:04 PM - 4 messages

I'm running in to a problem that I can't seem to find any answers for, and I'd appreciate any help people can give. I have a table with a couple integers and a single text column in it. ...

Restore db from SQL 2k5 beta 2 to SQL 2k5 final

Aaronous - 4 Jan 2006 11:03 PM - 4 messages

I have a db I created in SQL 2005 Beta that I would like to keep. I have a new SQL 2005 server built with the release version. I tried to restore the DB and I get an error that it is an earlier version and it cannot restore. I ...

SQL 2005 and 2000 on same server?

ML - 4 Jan 2006 11:02 PM - 2 messages

We are just setting up a new development box and want to have both SQL 2005 and 2000 for development and testing. Are there any issues with having both running on a single Win2003 server? Can SQL Express also be run on the same box with both of these as well? ...

Apply ROWCOUNT on one Table in UNION

Bac2Day1 - 4 Jan 2006 9:43 PM - 3 messages

I have these two SELECTs in my SPROC... how can I merge the two tables together so that my result is one table? UNION won't work as the ROWCOUNTs are different, I can't use TOP as it's a sproc and you'll ...

Jobs - Read only access

Mark - 4 Jan 2006 9:20 PM - 5 messages

In SQL Server 2000, you either have full access to jobs, or none at all. There is no read-only. Does 2005 allow for read only access to jobs? Thanks in advance. Mark ...

SQL 2005 and weird SP performance problem.

johnsolver - 4 Jan 2006 7:46 PM - 2 messages

Hi, I've recently migrated my DB to SQL 2005 from SQL 2000, the migration was mostly painless except for the following problem I bumped into: btw: I've changed the comp. level to SQL2005 I have a SP that when executed through ASP.NET takes around 10seconds ...

DBCC DBREINDEX

Greg - 4 Jan 2006 6:57 PM - 7 messages

When I run DBCC SHOWCONTIG (tablename) WITH ALL_INDEXES the first index shows Table: 'tablename' (437576597); index ID: 0, database ID: 8 TABLE level scan performed. - Pages Scanned................................: 15721 - Extents Scanned..............................: 2027 - Extent Switches..............................: 2026 - Avg. Pages per Extent........................: 7.8 ...

Loading SQL Server 2005 Standard

Help

Count(*) and count from sysindexes

Profiler blues

Help Please

Create View error

[] braces

SQL2005: sp_msforeachtable problem...

Unkillable Process

source code control

Error Message 17883 (not listed in KB)

Moving a Large Table into New datafile vs. New database

Insufficient system memory!! Error Msg 701

Determine what User Account SQL Server is running under

Session expires after an execution of stored procedure?

Move SQL Users id + pw to new box

Start SQL Agent

SQL 2005 rebuildm?

Backup From ISP?

SQL Distinct Value and Order by some Field......

Licensing Question

"Owner Name" cannot be omitted in sql 2005 querries?

Two tables problem

Using multiple parameters in WHERE clause

Replication Update Conflict

SQL2005: Tuning advisor & UNC database = no result???

Take database offline

SQLDMO Problem

Create table

Ping in sql

SQL Server 2005 Cost help...

problem copying database to new server!

SQL Server 2000 performance

SQL 2005 Table-Valued UDF

Query help needed. Finding the latest record in key...

SQL 2005: Error with Trigger

help with dts package

SQL Server freezes

upgrading to SQL 2005

How can I tell if SQLServer2005_BC.msi is already installed?

SQL2005 - Delete Files Older than 3 Days

Generating SQL scripts for tables

SQL 2005 Error TCP Provider

SQL DB move - is the MS article 224071 incorrect ??

Recommended Max Quantity of Columns in table

usernames...

Ristricted User Permissions on Services

Scripting maintenance tasks

Need help on create view index

Stored proc executes in a read-only state from third party app

Gigantic Log

Frustrated programmer wants to create a SQL server database

SQL Server 2005 INTEGER Keyword

SQL Server 2000 Restore

What Network IO waits mean on windows performance Monitor ??

Please help me with a sql query statement!!

Multiple SQL Version

Stored Procedures naming affect performance?

whats in-line SQL ? <EOM>

self join question

Error: 701 Insufficient Memory - Nightly Data Update

install newer standard etition over older enterprise edition

Date calculation stored in table to be executed by SP

PLS HELP: Database is marked as (loading) after restore

attach 2005 db on 2000

How can I diagnose a suspected slow SQL server?

what happened to www.angrydba.com?

Slow performance - SQL Server 2000

emails reside in Inbox??

extraction of data from transaction log of SQL Server 2000

What Network IO waits mean on windows performance Monitor

Substring problem

Do I have to install SQL server 2000

sa password

Sort order is good in design mode, but bad in open query

SQL development. From development machine to live server.

Create a copy of database

Indexing

cannot repair database.

Wildcard symbol

Any way to repair the damage backup file?

restoring to 2005 doesnt work