SQL Newsgroups: Microsoft SQL Server Administration

Can't shrink a Transaction Log File

gemel - 19 Mar 2005 11:45 PM - 3 messages

I backed up my log file and attempted to shrink it with DBCC SHRINKFILE. The command executes but leaves the transaction log at it's current size. I know that an uncommited tansaction can cause this to occur. a) How do I test for this? ...

Getting these two errors periodically

Chris Schmidt - 19 Mar 2005 11:39 PM - 2 messages

Configuration: SQL Server Enterprise 2000 SP3a on Windows 2k Advanced Server. Error: 0, Severity: 19, State: 0 SqlDumpExceptionHandler: Process 53 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. Error: 0, Severity: 19, State: 0 language_exec: Process 53 generated an access violation. SQL Server is ...

Backups from SQL 7 Running under Server 2003

LorenN - 19 Mar 2005 11:29 PM - 2 messages

cI had been running SQL 7 under Server 2003 for 5 weeks. I didn't know that 7 should not be run under 2003. I trying to correct this. ( my current is now inoperable because of HD problems) I have backups from this configuration. I'm try to do a recovery using ...

Data Type Convertion Error

CC&JM - 19 Mar 2005 8:57 PM - 4 messages

Hello, I need to convert one character field to datetime and after make the differenc between two fields. The problem is that if in the output result appears one value that is biggest then 23:59:59 hours its shown the ...

DW/DSS Schema design

Hassan - 19 Mar 2005 8:35 PM - 2 messages

I know a data warehouse stores historical data and the fact and dimension tables could be huge with billion rows and could be more than 100s of GB in size for just one table. Can someone share some design tips on whether they ...

model database "lost"

Christian Castro - 19 Mar 2005 6:39 PM - 8 messages

When moving the sysdatabases to a different drive using specific Q224071 () instructions i found that the model db does not show up and when running: use model go sp helpfile go i get: Could not locate entry in sysdatabases for database model. No entry found ...

Page Count of a File

GK - 19 Mar 2005 3:07 PM - 2 messages

Dear SQL Gurus: I have some PDF files on a fileserver. I have the metadata for these files in a table, which says, which file resides where, etc (DocumentID, DocumentPath). I also have one column which is for PDF Pages for the ...

sa login

Tumurbaatar S. - 19 Mar 2005 12:32 PM - 7 messages

Is there a way to disable or rename SA login? I've tried to remove it from Sys Admin role but it seems this cannot be done. ...

msg : 2714

Adel - 19 Mar 2005 11:21 AM - 3 messages

II am trying to create table through Query Analyzer. an error message appears "Server: Msg 2714, Level 16, State 4, Line 1 There is already an object named 'ACTIVITY_TABLE' in the database." the table does not exists in the DB I used following scripts to create table ...

time of last dbreindex

Hassan - 19 Mar 2005 7:48 AM - 3 messages

Is there a way to find out when the last time indexes were rebuilt using dbreindex ? I know theres a way to see when stats were last updated and sure would be nice to know when indexes were rebuilt last ...

Memory utilization is very high

John Abraham - 19 Mar 2005 6:51 AM - 3 messages

My server configuration is Acer Altos 22000 with 1GB RAM, dual processor pentium 64 bit Xeon processor running at 900 MHz with SP3. I have a SQL server 2000 database with SP3 for my inhouse activity. The problem is the memory utilization is very high at 98% with sqlserver ...

DBCC Shrinkfile

Hassan - 19 Mar 2005 6:14 AM - 5 messages

What happens underlying the DBCC Shrinkfile statement ? What moves around ,etc.. ? Trying to figure out why it takes so long for this command to run ,, what does it do ? Thanks ...

query to list db and recovery model

Hassan - 19 Mar 2005 6:09 AM - 5 messages

I want a query that would list all databases on a server along with its current recovery model setting such as DB1 Simple DB2 Full ...

does dbcc checkdb increase size of data files ?

Hassan - 19 Mar 2005 5:29 AM - 3 messages

Does DBCC checkdb increase the size of data files ? I have a 300GB database thats almost full and wanted to know whether the size would grow when I run DBCC checkdb ? Also, does the maintenance plan under integrity - > check database integrity ...

Export SQL server Diagram.

strout - 19 Mar 2005 2:21 AM - 2 messages

Can I export SQL server diagram into VISIO? I found an article that saves dtproperties table to export diagram. I don't know if you can import the DTS package into VISIO or not. ...

How to run SQL Profiler without sysadmin rights

pshroads - 19 Mar 2005 1:03 AM - 1 message

I thought I'd share what I do to enable people to run SQL Profiler traces without having to give them sysadmin rights. I wrote a batch file that calls Profiler from the command line as follows: profiler /Sserver /Uuser /Ppassword /Tx ...

Any way to create 5KB size of Database?

SRIRAM - 19 Mar 2005 12:07 AM - 4 messages

Hi when we create new database that will take base structure and size of the model database. it will be approx 1.43 MB as per version. now i want to create database that size is 5kb any way to create database like that size, ...

Adding a field whose value DEPENDS on other fields in table

pmud - 19 Mar 2005 12:05 AM - 4 messages

Hi, Three fields in my database table are , OPEN_STATUS, INPROCESS_STATUS, COMPLETED_STATUS. The values of these are T (true) or F . Now I need to add another field for Status (a generic field) , which has value : 1.Open if the value of the field OPEN_STATUS=T , ...

Trouble in shrinking the Transaction Log with DBCC SHRINKFILE

gemel - 19 Mar 2005 12:01 AM - 2 messages

I am trying to reduce the size of my transaction log. I back it up and then use DBCC SHRINKFILE to try to reduce it. No errors occur, but the log does not reduce. I know that an open transactio can cause this problem. How can I ...

How to add a default to existing column in T-SQL?

Leon Shargorodsky - 18 Mar 2005 11:03 PM - 3 messages

Please help me with T-SQL sytax for adding a default constraint to existing column. Books Online do not help at all. Thanks! Leon Shargorodsky ...

Change Recovery model through T-SQL

Jluo - 18 Mar 2005 9:27 PM - 6 messages

I have an instance of SQL Server 2000, with 400 databases. Now I want to change the recovery model of each of them from simple to full. How can I do it in T-SQL? If not T-SQL, what is the easiest way to change all of them? ...

Anyway to find informatoin on how a record is deleted?

Alpha - 18 Mar 2005 9:15 PM - 2 messages

Hi, One record, linked by a key tid, is deleted from several tables in the database. Is there anyway to find information on when and who deleted the recrod from SQL server? Thanks, Alpha ...

Database Defaults

Scott - 18 Mar 2005 8:47 PM - 4 messages

I have a strange (well I think its strange) where I have create a field (CreateDate) with a default of (getdate()); however, on the server where this table is built, it is not populating the CreateDate, and as a result I am ...

Update same table diff rows

Chen - 18 Mar 2005 8:43 PM - 2 messages

Hi, Can someone tell if I need update same table at same time but different rows, is there has method to avoid one process terminate as victim by SQL Server 2000? Regards, -Chen ...

collection name question

Rafal W. - 18 Mar 2005 8:25 PM - 2 messages

1 of my SQL 2000 servers has few databases that acts as backend for web based ..NET applications, most of them is in English and they have collection name: SQL_Latin1_General_CP1_Cl_AS.. I just noticed that recently deployed db which stores Italian text has collection name: <empty> .. my questions are what it ...

What could cause a SQL server not to listen on port 1433?

SA Development - 18 Mar 2005 8:04 PM - 15 messages

Hi, What could cause a SQL server not to listen on port 1433? Thanks, SA Dev ...

dual processor benefit

pdwight - 18 Mar 2005 8:03 PM - 3 messages

Currently running SQL 2K on a W2K sp3 box with one P3 1.2 processor. Current db size is 62 gigabytes. Our situation: We use Meditech hospital software which has it's own db structure (mumps). Nightly, most of the data that is entered into the ...

sp_MSforeachdb

Mark - 18 Mar 2005 7:27 PM - 3 messages

I am trying to use the undocumented SP 'sp_MSforeachdb' with 'sp_helpfile' and the following syntax gives me only the current database and not the others. Can someone give me the correct syntax ? Thanks. Exec sp_MSforeachdb 'sp_helpfile' ...

SQL 2k SP3: Inconsistent counts on null fields(?)

K. M. Linner - 18 Mar 2005 7:23 PM - 4 messages

This query returns different results every time it's run. It's part of a nightly data audit for data integrity. It was just added to our audit two days ago and has never been correct. select count(customerid) from customer ...

Building a SQL 2000 server farm

Oughtsix - 18 Mar 2005 7:23 PM - 5 messages

I work for an insurance company that presently has one production sql 2000 server with 4 unique databases. The databases do have some interaction with each other. I am in the process of planning an upgrade for this server. Our ...

How to query data through scheduled tasks

LWhite - 18 Mar 2005 7:09 PM - 3 messages

Hello, We are currently using an inventory control system that is a little lacking. It allows us to store expiration dates for our materials but lacks any way to use the information. The system is built on an MSSQL 2000 database. ...

Monitoring SQL Performance

Tony - 18 Mar 2005 6:47 PM - 1 message

Can someone tell me the best tool on the market that will simplify my life when it comes to monitoring and maintaining a SQL 7.0 & 2000 database? Thank you, Tony ...

Is there a bug with Views and Select *?

JerryK - 18 Mar 2005 6:42 PM - 4 messages

Hi, I added some new columns to a table and they do not show up in a View that references the table "*" selector. If I go into Enterprise Manager and re-save the view they show up. Has anyone else experienced this problem? ...

Replace password with "******"

Simon Abolnar - 18 Mar 2005 5:40 PM - 4 messages

How can I replace password in SQL server table column with ****** In Access it can be done by Input mask: password How can I do it in SQL server? Thanks for help! Simon ...

Please help with Server name change

Al - 18 Mar 2005 5:39 PM - 3 messages

I had 2 instances of SQL on my machine which I am using as a server. The first is MSDE and The second is the SQL 2000 developer edition. Recently, the IT changed the main server to windows 2003 and with it, they have changed the ...

Copy Backup file

kpxus - 18 Mar 2005 5:37 PM - 4 messages

hi, I have a problem copying 12 Gb database backup files (2) for network backup copy from the SAN. I used xp_cmdshell ' copy ...' to copy the backup files every day night. Sometimes, the files are not copied over the network. I have ...

Keep one connection open for log

Astros - 18 Mar 2005 5:15 PM - 5 messages

I am using SQL 7. If I open one connection for long, I notice that as I keep running more SQL statement my I/O and CPU Usage keep growing. Even though I am done with the connection not running any statement I still see those ...

REPLACE NULLS WITH A SELECT STATEMENT (maybe)

Michael Hardy - 18 Mar 2005 3:18 PM - 2 messages

I need to create a view to support a report requirement. I need the returned dataset to include the AIRLINECODE and FLIGHTNUM so the info will be available no matter what vendor the end user filters on. To do ...

Selection From Selection

JLong - 18 Mar 2005 3:02 PM - 3 messages

Is it possible to create a selection from a selection? I have a query which returns what I want, it join two tables and does some calculations. It works fine, however I would like to query it to be able to group and sum on some ...

How can I increase the Query Timeout Value

Rob Diamant - 18 Mar 2005 2:57 PM - 4 messages

Is there a way to increase this value on the server or does it have to be done at the application level? If at the app level, any suggestions as to how. TIA Rob ...

newbie question sql 7.0

Ryan McAuley - 18 Mar 2005 2:52 PM - 3 messages

Hi group... I've been out of the programming game for about 4 years and would like to get back into it. So I decided to make my own web site with a sql back end. I am however having two separate problems. ...

DTS invalid object name error

David C - 18 Mar 2005 2:01 PM - 3 messages

When I try to import or export between my laptop and our SQL Server 2000 server I get 2 errors stating [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.vw_LaborTotalsAll' I looked it up in TechNet and said it had something to do with the order of ...

How do I do restore only SOME DTS scripts from msdb database?

Larry Woods - 18 Mar 2005 12:36 PM - 3 messages

I understand that I can backup my DTS scripts by backing up the msdb database, but how do I restore only CERTAIN DTS scripts from the database? If I restore 'msdb' I might be overwriting DTS scripts, etc. that are ...

Synchronize Database schema

Angelo - 18 Mar 2005 11:50 AM - 4 messages

Hello, does any body know a tool to synchronize database schema? Thank you, Angelo. ...

SQL Mail

Nimi - 18 Mar 2005 10:53 AM - 3 messages

Has anyone come across this error: Error 22030 ....MAPI Error 273. ...

Questions on query performance

Pavils Jurjans - 18 Mar 2005 9:49 AM - 3 messages

Hello, Could you please clarify certain questions for me, connected with general query execution speed... 1) I have this table with several fields, and one of them is of type smalldatetime. The dates are always exact - ie, with time part equal to ...

execute statement

Param N - 18 Mar 2005 8:16 AM - 2 messages

hi all this is basically in SQL create procedure sp begin if iMode = 16 then exec('Select DeptCd as DepartmentCode from '+ sCheckValue+' Group by DeptCd'); end how can we wright the above query in Oracle Plz help me *** Sent via Developersdex [link] *** ...

can I send a variable table name

Param N - 18 Mar 2005 8:16 AM - 2 messages

Hi every one, Can i send a variable table name in to the store procedure in ORACLE8i eg create procedure sample (x as numeric, table_name as varchar(150)) is begin if x = 1 then select * from table_name; end if; end; ...

Stored procedure executing in parallel.

SQLCatz - 18 Mar 2005 7:31 AM - 9 messages

I have a requirement wherein a dos batch file will execute (n) number of stored procedures whose names are passed in as parameters. This I have done. It works. The next step requires that the execution of these stored procedures should ...

SELECT TOP X

Rene - 18 Mar 2005 6:32 AM - 5 messages

I would like to create a store procedure that returns a recordset. I would like the store procedure to takes one parameter indicating the number of record to retrieve. Below is the store procedure that I made. When trying to ...

Best way to archive data?

DBA72 - 18 Mar 2005 5:01 AM - 2 messages

We have a data warehouse of approximately 200Gb. Our data is separated by yearly quarters into separate tables and filegroups. Each quarter is in one table and there is one table per filegroup. There is a view which unions all ...

shrink tx-log

H - 18 Mar 2005 4:32 AM - 3 messages

Hi If a tx-log was created with a 1GB size, how do I get to shrink it down to 100MB? I've tried tuncating and then shrinking but it won't shrink beyond the original create size even though there ...

Migrate Btrieve database to MSSQL 2000 database

andrew - 18 Mar 2005 2:43 AM - 4 messages

Hi, I've a Btrieve database which I want to migrate to MSSQL 2000 database. May I know what is the method I can use? Thanks andrew ...

MSSQLServer services

chittana - 18 Mar 2005 2:03 AM - 3 messages

I'm running SQL 7.0 SP4 on NT 4.0. Each time i restart server, the sql services just showing starting status for 2 minutes & gives error message "1 or more services failed to start". I have start the services manually. I've ...

space Mgmt Question

Tina - 18 Mar 2005 1:08 AM - 4 messages

I have a 532mg SqlServer database where most of the space is one large table with large binary objects. It is very infrequently updated and when updated a backup is always made. So, I don't need a lot of free space for new rows ...

Reinstalling SQL Server on a Cluster

Michael C# - 18 Mar 2005 12:05 AM - 4 messages

OK... Here's the deal. We had a 2 server cluster set up with SQL Server. This consultant we were working with uninstalled the cluster and then uninstalled SQL Server. Now we set the cluster back up, but we're having ...

Access linked server

Andre - 18 Mar 2005 12:04 AM - 1 message

I have a SQL server in a workgroup that needs to access an Access db in a domain. Is there a way of setting up a linked server to use my domain credentials to access the share, where the Access db is stored? Or do I ...

sql web administrator question

Mangesh Deshpande - 17 Mar 2005 11:15 PM - 1 message

Hi I installed sql web admininstrator on one of my test machine Intention was to access the database over the web from any client machine. I could access the database locally where the sqlweb administrator is installed. But when I go to any other machine and use the URL if says ...

Upgrade

shortchick - 17 Mar 2005 10:41 PM - 3 messages

I just upgraded a SQL server from Win 2K advanced to W2K3 Enterprise. When the developer attempts to run one of her DTS jobs, she gets the message "The procedure entry point GetTextExtentPointI could not be located in the dynamic ...

SQL Query

Terry Matthews - 17 Mar 2005 10:38 PM - 5 messages

Hi, I'm not sure what the correct newsgroup is to post this to, if this is not right please let me know. I'm very new to writing SQL queries and I have a couple questions. My situation: I have a table that has a ton of applications in it listed by name, ...

Log shipping a distribution server

SQLDBA - 17 Mar 2005 10:31 PM - 1 message

Hi, I'm trying to get log shipping to work with a distribution server used in transactional replication. Shipping the distribution database is no problem but the issue is in failover getting the distributor to talk to the publisher. The replication monitor won't display anything - distribution or ...

GUI tools for Query Analyser

Paul - 17 Mar 2005 10:25 PM - 4 messages

I am new to SQL but have some experience with MS Access. Instead of writing codes in Query Analyser, is there any GUI tools (maybe 3nd party) for designing queries ? ...

Getting stored procedure output into a table

Doug Little - 17 Mar 2005 10:20 PM - 6 messages

Hi, I trying to use the system stored procedures to do some job processing. I want to run the sp_help_job and get the output into a table/cursor Any thoughts on how I might accomplish this. Thanks ...

SQL Server 2000 Transaction Log not being truncated!!

Stu - 17 Mar 2005 8:31 PM - 5 messages

Hi all, I'm running SQL Server 2000, and I noticed that the transaction log for my main database is now at 7.2 GB in size! The main database file is only about 3.8 GB, so something is definitely not right here. ...

Recovery of Database 'xxx' (Complete in 68,395 more seconds)

Michael C# - 17 Mar 2005 8:14 PM - 6 messages

I'm having a problem with a SQL Server. Every time I stop and restart the SQL Server service I get a message similar to this one. What do I have to do to force checkpoints during the load process? Thanks ...

MS Access Front end offline

Anonymous - 17 Mar 2005 8:13 PM - 2 messages

Hi, Is it possible to work offline wth MS Access frontend, then synch the changes to the SQL backend database? Any suggestions would be greatly appriciated. VJB ...

Data Transformation Services

Pete Sklarow - 17 Mar 2005 7:36 PM - 3 messages

Does anyone know how to distribute a DTS package to a server that you cannot connect to? Can it be put on a CD? ...

SQL Mail with 64 bit!!

JMKitts - 17 Mar 2005 7:15 PM - 7 messages

I am trying to setup SQL Agent mail on our 64 bit machine. I have created a profile in Outlook Express. The profile is the same account as what the services are running under. When I go into SQL Server Agent properties, the mail profile option is ...

What is 'tempDB' and I should I isolate it?

Jackson Houndmugger - 17 Mar 2005 7:03 PM - 2 messages

Hello, I've read that it's wise to isolate TempDB on its own drive. Could someone explain what TempDB is, what it's used for, and why it's preferable to have it located on it's own volume? Is the rationale similar ...

File timestamps not advancing

Bob H - 17 Mar 2005 6:44 PM - 6 messages

Our production SQLServer has automated nightly reboots. Last week, after one of these reboots, SQLServer came up, then immediately crashed. The log has a bunch of errors saying things like "Problem creating symptom dump file due to internal exception" and "Invalid ...

Serious performance issues in production SQL. Neeh help.

mytechsup - 17 Mar 2005 6:34 PM - 2 messages

Hi, We are experiencing serious performance issues in our production SQL server. It happens that from time to time that the CPU's jumps to 100% use and stays in average of 80 to 90% of CPU use for long periods of ...

update not working as expected

DBA - 17 Mar 2005 6:11 PM - 3 messages

I am try to update a field in one table based on data from another table what I want the field in the first table equal to the sum of the field in the other table and grouped by the field that joins the two tables. somthing ...

Scalability

SP - 17 Mar 2005 5:53 PM - 2 messages

I'm a newbie to SQL sever. I have questions about "Scale Up and Scale out" in SQL Sever. Can I use Blade Server as a method to scale up SQL Server 2000? Basically, can I keep adding more blades when database keeps growing or more demanding? ...

Loopback Adapter Hides Instance Names

Shane Lim - 17 Mar 2005 5:28 PM - 1 message

I have laptops that require the loopback adapter when they are not connected. However when they connect back to the network the networked servers display just the computer name not the / instancename. Any ideas? It only happens on network instances. The local instances are ...

SQL statement for adding column description

Doug - 17 Mar 2005 5:21 PM - 4 messages

I'm fairly new to SQL Server and can't seem to figure out how to add a column description! I know you can do it in the GUI, but I want to know how to do it via a SQL statement. I've looked through the syntax of the create table ...

SQL Server 2000 Enterprise Edition install on win2k3 SBS

JasonNCS - 17 Mar 2005 5:21 PM - 1 message

I have Win2K3 SBS running and when I attempt to install SQL 2000 enterprise it give me a warning "Microsoft SQL Server 2000 Enterprise Edition server is not supported on this operating system. Only client components will be available for installation." And after hitting Ok the installation will only ...

How can I cancel a backup?

Jonathan R. Karp - 17 Mar 2005 5:01 PM - 3 messages

I'm running SBS 2003 Premium. I've got several databases set up to be backed up nightly, but I have deleted one of them since I set up the backup jobs. Unfortunately, even though the database is deleted, it still tries to back it ...

Working with an older version of ss 6.5

Newbie - 17 Mar 2005 4:25 PM - 2 messages

Hello, When trying to expand the data file in ss6.5 because it had ran out of space, i created a new database device with 500mg. Mistakingly I "expanded now" a database device with a different name from the drop down then the one ...

file autogrow in SQL 6.5 ?

Leon Shargorodsky - 17 Mar 2005 4:17 PM - 3 messages

Is it possible to set up database files to auto expand in SQL 6.5? Thank you so much for your help! Leon Shargorodsky ...

error 16389

Tom - 17 Mar 2005 3:47 PM - 2 messages

Hello, We have a active x script that has been running for weeks from sql server agent and all of sudden last night we are receiving "ActiveScripting specific error 16389 occurred" on the jobs. I have search both BOL and newsgroups but ...

SA Login

nospam - 17 Mar 2005 3:00 PM - 4 messages

Hi, Is there a way that I can be notified whenever someone successfully logs in as SA? Thanks, Terry ...

Help needed

Jim Wile - 17 Mar 2005 2:32 PM - 6 messages

Hello I am trying to insert records into a lined server (Oracle RDB database) from a sql database using Tsql. I cannot get past the error: Server: Msg 446, Level 16, State 9, Line 4 Cannot resolve collation conflict for equal to operation. ...

Graphics and SQL-Server

Mario Reiley - 17 Mar 2005 2:04 PM - 1 message

Greetings group I wanted to expose my following case: I have an application that uses Microsoft SQl-Server like Backend but I am presented the following problem: I should keep and to recover in some columns files in format Word, Excel, PDF, Text, and graphics as Autocad or ...

Stripe size for SQL server. Is 64k stripe not wrong?

Crappy - 17 Mar 2005 11:46 AM - 5 messages

Hi All, I got a dev server with 2* 140GB SCSI, RAID 0. Now from what I read here and a couple other places, the best stripe size to make for SQL is 64k. Here's where I get confused. ...

Server Performance Comparison

Steve - 17 Mar 2005 11:07 AM - 6 messages

Hello experts, We are going to upgrade onto our server shortly, and the powers that be have decided they want figures on performance improvements under load (average times for sp's etc). I am not sure how to achieve this, but presumably for ...

Enterprise Manager Port?

Shabam - 17 Mar 2005 11:06 AM - 2 messages

What port does SQL Server Enterprise Manager need open to connect to a remote database? I'm not finding documentation on this. ...

Problems with SQL mail

Gav - 17 Mar 2005 9:31 AM - 4 messages

I have just setup a Windows 2003 Server with SQL 2000 (sp 3a) and Outlook 2000. I am trying to get SQL Mail working on this box but keep getting the following message. Error 18025: xp_test_mapi_profile : failed with mail error 0x80040111 ...

Cursor - Structure of.

SQLCatz - 17 Mar 2005 5:55 AM - 4 messages

I wanted to know the internal workings of a 'cursor'. What happens inside SQL Server from the time that it is declared, opened, when it is used and finally closed and deallocated? Have searched the web - but apart from examples and the pros/cons of using ...

How to find out CPU saturation in SQL server

Igor Marchenko - 16 Mar 2005 11:45 PM - 3 messages

Hello, I was wondering if there is a way to find out in T-SQL how busy CPU is. I would like to get the same information as shown in CPU usage graph in Task Manager. Thanks, Igor ...

How does this qeury works ?

Jason - 16 Mar 2005 11:04 PM - 4 messages

I get a query from a contractor with a number of LEFT JOIN. Since I am new to SQL, I would like to seek your advice on how it works: select t1.Field1, t1.Field2, ...

Reclaim space back

Dave - 16 Mar 2005 9:04 PM - 18 messages

If you create a database with the initial space of 10 GB and later find out that the database will not grow beyond 2 GB, how can you reclaim the 6-7 GB space back on the same database? Thanks. ...

sql job failure

ishaan99 via SQLMonster.com - 16 Mar 2005 4:37 PM - 4 messages

Is there a way to check if any sql job failed on any server? Lets say we have 5 servers and of which 1 job failed on 2 servers. I am looking for some script that gives me details of servername followed by job name that ...

KDC Problem

Harrison Midkiff - 16 Mar 2005 3:43 PM - 10 messages

Hello: A while back I started getting KDC errors in my System log on my domain controller. The error is: Event Type: Error Event Source: KDC Event Category: None Event ID: 11 Date: 3/16/2005 Time: 9:34:08 AM ...

This is probably a simple question, but...

SA Development - 16 Mar 2005 3:18 PM - 22 messages

Hi, I'm trying to access a MS 2000 SQL server across a WAN using SDAC ([link]). One machine I run my app on connects just fine, but a second one will not. I installed the MDAC on the second one, but it ...

restoring SQL backup on non SQL server???

J Hotch - 16 Mar 2005 3:11 PM - 4 messages

I'll try to keep this as simple but clear as i can. i have a backup on an SDLT tape taken from a SQL server using the SQL backup to a locally attached device. i now want to restore the *.BAK file from this ...

AND and One to many relationships

Chris Kennedy - 16 Mar 2005 1:02 PM - 7 messages

I have two tables in a one to many relationship, customers and invoices. The invoices can be a variety of types marked by an invoice flag column (for instance 1, 2 or 3). I want to retrieve customers, which only have invoices ...

Archiving

Uhway - 16 Mar 2005 3:39 AM - 4 messages

What's the best way to archive tables with binary data? Flat files/bcp/DTS may not work if need to import binary data(not a fixed length column) with quotes etc. What I am thinking is to export to another database and back it ...

Perfmon - Average latch wait time constantly high

James - 16 Mar 2005 1:17 AM - 4 messages

We are monitoring our SQL server with perfmon and one of the counter keeps consistently hight. The Average latch wait time (ms) is always at 1000 level, which means the average time it takes for a latch to be granted is about 1 ...

Re: Enterprise Manager Databases

Daniel@tamc - 15 Mar 2005 9:53 PM - 9 messages

I get the same thing as well. Only change I made recently was the install some recent MS security patches, but none that related to SQL server. Have you found out anything new on this? ...

SQL Server 2005 - Still not upto it

rkusenet - 15 Mar 2005 5:35 PM - 4 messages

Trolling before someone else does -) [link],1759,1776048,00.asp ...

Determine cause of Timeouts

Running SQL database off of SAN -- is it feasible ?

SQLH2

What does SQL Server do on the back end of Log Shipping?

Got my SQLIO Results... Now what?

what to restore?

Unknown Error message