SQL Newsgroups: Microsoft SQL Server Administration

Problem Upgrading From SQL 2000 To SQL 2005

Rick - 23 Dec 2006 4:46 PM - 4 messages

I have SQL 2000 with the latest SP that was installed with pretty much the default settings as part of SBS 2000 Premium Edition. I am using SQL to run Microsoft CRM 3.0 and want to upgrade to SQL 2005 to ...

provider list empty

PBsoft - 23 Dec 2006 9:40 AM - 2 messages

I have two PCs with "SQL 2005 Express with Advanced Services" and "SQL Server Management Studio Express" installed. If I run SSMS on both PCs and navigate to "\Server Objects\Linked Servers\Providers" I find an empty list. While I know this is not regular, I don't know how solve it. ...

Permission VS Owner

Benny - 23 Dec 2006 9:32 AM - 7 messages

Why every securable has an owner? A securable's owner is some one has full control over the securable. so the term "owner" can be replaced by some one who has full control over securable. ...

weekday diff

jack.smith.sam - 23 Dec 2006 8:54 AM - 4 messages

Hi All, Is there anyway I can find the differenct between a day "d1" and day "d2" in the terms of weekday? For example is d1 is Monday and d2 is the first Monday after d1, the datedifference between them in terms of weekdays is 5. Similarly is ...

octo-processor with SQL2000

Pete Certo - 23 Dec 2006 6:21 AM - 2 messages

Can SQL Server 2000 take advantage of the processing power of a quad-dual-core server? Thanks, Pete ...

Learning SQL Server (no software at home)

Jerry - 23 Dec 2006 3:23 AM - 6 messages

I'd like to learn more about SQL Server. I have 2000 on my work laptop but not on my home computer. My job will be mostly working with SQL Server and I'd like to learn as much as possible about it but I don't ...

Specified SQL server not found

johan - 23 Dec 2006 1:07 AM - 3 messages

I just installed cable internet on a computer at home and it works fine. However, one of the programs that was previously installed (Bisk CPA Ready Software 9.0) no longer works. When trying to open the program, three error messages pop up: ...

replicating with Active directory

GaryDean - 23 Dec 2006 12:31 AM - 4 messages

Is they any feature that allows replication between Active Directory an SQL server. I know I can write an assembly to do it but I'm checking on easier ways first. ...

Cannot View Database Properties (Express 2005)

Daniel Manes - 23 Dec 2006 12:13 AM - 2 messages

It's always great to run into problems on a Friday afternoon before a holiday weekend, but here I am. I'm not sure when this started happening, but if I try to get properties on any of the databases on my SQL Server Express 2005 server ...

SSIS package erroring through scheduled job

jeff - 22 Dec 2006 9:21 PM - 4 messages

Looking for input on how to find errors with a SSIS package that errors when run through the scheduler (database engine) but if it runs through integration services directly it doesn't error. I"m running this package on the same production server not really getting any good error ...

SQL Server 2005 Embedded Edition

Loren Z - 22 Dec 2006 8:57 PM - 2 messages

One of our clients has intsalled MS Sharepoint and it uses SQL Server 2005 Embedded Edition for the database. They would like to do scheduled backups and I could use some help on how to do this. I downloaded and installed MS SQL Server Management Studio Express. When I ...

Restoring a database

pshealy - 22 Dec 2006 7:59 PM - 6 messages

I'm trying to restore a SQL 2005 database. First I restore the last full backup: RESTORE DATABASE OnTrack_Test_2 FROM DISK='C:\b\ReportServer_backup_200612170300.bak' with move 'ReportServer' to 'C:\data\OnTrack_Test_2.mdf', move 'ReportServer_log' to 'C:\data\OnTrack_Test_2.ldf', ...

VARCHAR trivia?

Elaine - 22 Dec 2006 6:12 PM - 7 messages

In SQL Svr Mgmt Studio, the keyword "VARCHAR" does not turn blue as it does in '00 Query Analyzer. Is there some change in the datatype? Thx ...

save binary files to a SQLExpress database

Paul - 22 Dec 2006 6:10 PM - 6 messages

Hi I need to save binary files to a SQLExpress database, Just wondering if anyone has done this and if there are any writeups on it? thanks. ...

Unable to touch a folder to attach a database

John - 22 Dec 2006 4:38 PM - 3 messages

There is a database that comes up suspect. I was able to detatch the database, but when I try to drill down to the folder that contains the database to reattach it as soon as I click on the folder I receive a error ...

IO completion listener error

sam.m.gardiner - 22 Dec 2006 4:35 PM - 2 messages

hey any ideas on what the hell this means.. it comes from the evnet log message " IO completion listener (0x354) Worker 0x009dc0e8 appears to be non-yielding on node 0. Approx CPU used: kernel 0 ms, user 0 ms. interval 149999 ...

sqlservr.exe -m not single user

Marcos Paione - 22 Dec 2006 4:22 PM - 2 messages

Hello, when I start sql server 2005 std with -m the master database no set in "Single User Mode"... some ideas. Thanks. Marcos ...

SQL server self healing

Cameron - 22 Dec 2006 3:32 PM - 7 messages

We have a SQL application that is tied into a major manufacturing facility. But like any manufacturing plants some times you can get problems with the network, power outages and flucuations. What we have been finding is that when an outage occurs the SQL server isn't configured to self heal, to look ...

Full Recovery model and transaction log

fniles - 22 Dec 2006 1:55 PM - 5 messages

When I have a SQL SERVER 2000 database in a Full Recovery model, I notice the transaction log just keep getting bigger and bigger. Will doing a Complete backup and backup the transcation log as part of the maintenance plan truncate the transaction log ? ...

Question on 'load/replace" in SQL Server

DataPro - 22 Dec 2006 1:50 PM - 3 messages

I have to periodically overwrite selected tables in one environment (Prod) with the contents of the same named tables from another environment (Staging). There are about 200 tables involved. In SQL Server what would be the best way to do this and minimize ...

Path of SystemDB during SQL Server 2005 Installation

MB - 22 Dec 2006 12:30 PM - 4 messages

Hello, During SQL Server 2005 Installation I would like to change the path for .mdf on D:\MSSQL\Data\ and .ldf on E:\MSSQL\LOG\ for all the system databases. Can anybody guide me how we can do it? Thanks in advance, ...

SQL-Server 2005 and Windows VISTA

r06 - 22 Dec 2006 9:07 AM - 3 messages

Does anyone know if there are any issues (compatibility, performance or otherwise) running SQL-Server 2005 on Windows VISTA (any version)? Any info would be appreciated. ...

query for this purpose

MadhavC - 22 Dec 2006 7:14 AM - 3 messages

We have a worktran table WoNo Jobno Status 1 01 Fullfill 1 02 Pending 2 01 Fullfill ...

Server Renamed But Replication Still Looking for Old Name

Andrew Hayes - 22 Dec 2006 6:01 AM - 6 messages

Hi All, I renamed the 2003 Server that I have SQL Server 2005 installed on, and everything is working apart from setting up the Distribution for replication. It comes up with an error saying that "Cannot connect to NEWNAME. SQL Server replication requires the actual server name... Specify ...

Itanium server poor performance compare to Xeon sql server 2000 EE sp4

tamilvel n - 22 Dec 2006 3:38 AM - 9 messages

Dear all We have itanium server having 8 gb of ram and 4 Processor connected to SAN box on Veritas cluster mode. OS is W2k3 EE sp2 Sql server EE Sql server 2000 SP4 The databases we have installed about 30 GB of content. ...

Mirroring

BigSam - 21 Dec 2006 8:43 PM - 10 messages

We are moving our asp application from SQL2k to SQL2k5. I implemented database mirroring for my critical databases, which is setup & running. I modified the connection string in the Global.asa to point to my new servers. When both SQL servers are up & running I connect to the primary database. ...

Log backup does not truncate the log file

Leila - 21 Dec 2006 8:03 PM - 10 messages

Hi, My db uses full recovery model. I used maintenance wizard to perform: 1) Index rebuild every night 2) Full backup once a week 3) Log backup every night 4) Integrity check every night The log file is 1GB now and because of regular index rebuild I expected this ...

Browse mssqlsystemresource.mdf (SQL Server's Resource Database)

Chris - 21 Dec 2006 7:51 PM - 6 messages

Is there a way to have the Resource Database (mssqlsystemresource.mdf) appear in the list of Databases in SQL Server Management Studio for easy browsing of it's contents, or is the only browse option to open the MDF file with a text ...

Need to create an "offline" database, using production SQL2000 dat

pbrill1 - 21 Dec 2006 7:30 PM - 9 messages

I am tasked with creating reports that use live (or at worst, day-old) data from our MS SQL2000 ERP application, and allowing a select set of non-technical users to have the ability to view and print out data that is a ...

About difference between log shipping standby and active/passive c

Iter - 21 Dec 2006 6:54 PM - 7 messages

Hi Guys, What is difference between log shipping standby and active/passive cluster? is there any difference for the functionality? Thanks ...

Data Shaping Question (Syntax)

Radu - 21 Dec 2006 4:34 PM - 4 messages

Hi. I guess it's simple, but I think I'm really dumm... (and, on top, I can see only one example of data shaping in MSDN). How do I calculate fields ? Starting with: strSQL = "SHAPE {SELECT CustomerID, CompanyName, ContactName, ...

sql server backup.. not able to finish

Leida - 21 Dec 2006 4:34 PM - 6 messages

There is a database that has failed to backup for a number of weeks due to database being in single user mode. I have tried to alter the database to change single user to multi user mode, and it fails everytime saying it is ...

Sorting the "insides" of a UNION

Maury Markowitz - 21 Dec 2006 3:56 PM - 12 messages

I'm trying to populate a list in Access that contains a large number of stock tickers. That's easy. The problem is that our users sometimes select by ticker, and other times by name. I've "solved" this by putting two popup ...

Correlated Subquery

Ben UK - 21 Dec 2006 3:47 PM - 5 messages

Can you use a correlated subquery in a join expression, when you reference the table your joining to? ...

Package execution failed but no error (SQL2005)

Frans - 21 Dec 2006 3:30 PM - 2 messages

I made an Integration Services Package which runs well if I start it manually (also from SQL server Management Studio). Now I have created a new job for the SQL server agent which need to run my package. After starting the job, it ends after a few seconds: ...

Connection Leak

malkeshsheth via SQLMonster.com - 21 Dec 2006 3:13 PM - 4 messages

Hi, I have troubles with a threaded application on W2003 server. It seems to leave open connections behind time to time, it sums to hundreds over a day (the application make thousands). It is using the SQLOLEDB provider, ...

Annoying omission in SQL Server Import and Export Wizard

thejamie - 21 Dec 2006 2:25 PM - 4 messages

In SQL Server 2000 - using the IMP-EXP WIZ had => on the very last screen before the commit - there is a listing of the SOURCE SERVER NAME and the DESTINATION SERVER NAME. For some unknown reason, this has been removed. ...

setting a column unique in design view

arun@greettech.com - 21 Dec 2006 12:55 PM - 3 messages

In sql server, How can I make a column unique by setting some properties in the design view (Pleass note that I am not saying about the Unique key word which can be used when we create a table by an SQL ...

Getting results from 2 tables, determined by a 3rd

Ib Schrader - 21 Dec 2006 12:38 PM - 3 messages

Hi Suppose I have 2 tables that each includes 1 column of data and 1 column of some ID, like this First table ID FName 1 John 2 Martin ...

Colletions for Multi lenjuage

sqlextreme - 21 Dec 2006 12:33 PM - 3 messages

Hello every one Which intercalation works with multiples languages in SQL Server 2005? or How can I configure a collation for multiples languages? and that order for all the languages, is possible? Thank for any help. ...

What Port is Used?

Amos Soma - 21 Dec 2006 12:29 PM - 3 messages

I have a stored proc on Server A that is executing a stored proc on Server B. The stored proc call on Server A looks something like this: [ServerB\SQLServer2005].TargetDatabase.dbo.TargetStoredProc 'SomeData' Can anyone tell me what port is being used on Server A to execute the stored ...

SQL 2005 Defrag Script

Ben UK - 21 Dec 2006 10:00 AM - 3 messages

I'm doing a Defrag Script for SQL 2005.. ..I want to do differing lvls of detail on sys.dm_db_index_physical_stats depending on supplied criteria.. ...below is my query to get Detailed stats on Heaps below 10000 pages.. ..I'm having a bit of a headache confirming whether this will just run the Detailed ...

Compatibility level bug?

BerndB - 21 Dec 2006 10:00 AM - 3 messages

I think found a bug in SQL Server 2005 with respect to the database compatibility level. Scenario: 2 DBs on the same SQL Server 2005: - fbSunshore - swSunshore Both DBs with compatibility level set to SQL Server 2005 Both DBs have a table 'Steuerschluessel' ...

search phrase as google does

tolgay - 21 Dec 2006 9:57 AM - 4 messages

Hi I have been trying to find a query method in sql. Google engines search phrases and find the best suitable result . for instance if you write (play station) it can find all suitable result in "playstation" or "play station" but I could not do it in sql(2000) even in ...

Database Engine Tuning Advisor and Small Workload Files

Simon Harvey - 21 Dec 2006 9:50 AM - 2 messages

Hi all, If I'm interested in tuning a single stored procedure, does the number of executions of the Sproc in the workload make any difference to the quality of the DETA? For example, if I setup a trace in SQL Profiler and executed the sproc ...

Pervasive SQL in same box as MSSQL 2000 ?

Dennis - 20 Dec 2006 9:44 PM - 2 messages

Has anyone installed pervasive SQL in the same box as MSSQL 2000 ? would there be any problems setting both up in the same box ? ...

bcp -- queryout

Andy - 20 Dec 2006 9:29 PM - 2 messages

I have a process that does a BCP "queryout" using xp_cmdshell to a Network share. The process is being invoked by a non-sysadmin account. I receive the error Cannot open BCP file. Sql7 on a Windows N/T box. ...

Import fails on varchar field

tootsuite - 20 Dec 2006 8:37 PM - 8 messages

Hello, I am trying to import my "zip-codes-database-DELUXE" tab-delimited text file into SQL Server 2005. This file is a commercial marketing information database that contains about 76,000 rows. I converted the xls files provided into text files before the import. ...

Where are all the Procedure/Statement cache stored ?

Hassan - 20 Dec 2006 7:23 PM - 7 messages

I meant the query plans. Is it in the Buffer Pool or the mem to leave area ? This is SQL 2000 Also, how to find out if I have memory pressure in the mem to leave area ? ...

If exists

thejamie - 20 Dec 2006 7:02 PM - 10 messages

Any idea why BEGIN IF EXISTS (select * from mytable)print '0' else print '1' end works and not BEGIN IF EXISTS (select * from mytable) '0' else '1' end I am trying to put the latter into a case statement. ...

Expanding a database

Tom Reis - 20 Dec 2006 5:55 PM - 2 messages

Is there to increase the size a database datafile with using the same datafile. I do not want to create a seperate datafile. I am using SQL2000 SP4. ...

xp_cmdshell 'net use r: ' - Password Invalid

Joe K. - 20 Dec 2006 5:47 PM - 4 messages

I am trying to use xp_cmdshell to map a network drive. Please help me resolve the password invaild. Thanks Use master exec xp_cmdshell 'net use r: \\FLORIDA\e$' Output: The password is invalid for \\FLORIDA\e$ ...

How do i put column values into a single row

Rsapru - 20 Dec 2006 5:29 PM - 6 messages

Hi, How do i put different coulmn values into a single row somthing like this A1 A2 A3 A4 A5 1 2 3 4 5 ...

QUERY: 1 SQL Server restricted access according to user account...

Andrew Wan - 20 Dec 2006 5:22 PM - 2 messages

Is it possible to run only 1 SQL Server 2000/2005 and set it up so that it displays specific databases corresponding to the user account logged in? ...

Database mirroring and log growth

Jim Norton - 20 Dec 2006 5:01 PM - 2 messages

Hi all: I have implemented database mirroring and it is working great. However, the database log files are growing and growing and growing... is there a way to manage the size of the log files? Thanks ...

Database Maintenance question...

Saral6978 - 20 Dec 2006 4:13 PM - 5 messages

I set up a Database Maintenance plan for backing 3 databases, their transaction logs, running optimizations, and to perform integrity checks. I've been noticing that when I don't receive a notice when my jobs have completed via email, the Status of the jobs are in "Performing completion ...

Database Engine Tuning Advisor Wont Suggest Any Changes :-)

Simon Harvey - 20 Dec 2006 4:08 PM - 5 messages

Hi all, I'm having a problem with the DETA in SQL Server 2005. Or at least I think I am. I have an asp.net web application that invokes lots of stored procedures. There is one page that causes a whole load of stored ...

General Question about Cursor Programming

Bishop - 20 Dec 2006 3:00 PM - 5 messages

I have to make a number of modifications to a process that currently relies heavily on cursor programming (in a stored procedure). If I were building it from scratch I'd code it in .net as that is my strength. Since there are ...

SQL 2005 Defrag Script

Ben UK - 20 Dec 2006 2:46 PM - 4 messages

I'm working on a defrag script for sql 2005, and I want where possible to choose an online rebuild as opposed to an offline.. ..one of the things I want to test is whether the index contains a LOB data type, but I can't see ...

Import DB Watcom

Carlo - 20 Dec 2006 2:41 PM - 3 messages

Someone knows as it is possible to read the data contained in a Db Watcom 4.0 in order to import it in a Db Sql? Thanks from Italy Carlo ...

SQL Server 2005 DB Mirroring

Ivan - 20 Dec 2006 11:22 AM - 11 messages

We are testing the SQL Server 2005 DB Mirroring, between a 64-bit server and 32-bit server, both SQL2005 Standard with SP1 Both SQL 2005 service is started by a sqluser account with Domain Admins right. We use the Mirror option in database task, setting the Configure Security, ...

Very slow Blob inserts

JaffaB - 20 Dec 2006 8:43 AM - 8 messages

Hello, I have an application which is storing blobs within a separate blob table (just the key and the blob item). When I write the files to the server as a file (into a directory), a 100kb file takes < 1 second to ...

Can you link SQL 2005 DB to query Sharepoint?

Jason - 20 Dec 2006 7:44 AM - 6 messages

looking for a solution to be able to query a sharepoint DB from a SQL 2005 Database very much like the access Linked Table but using SQL 2005. I've been asked to develop a web application with a SQL back end and to join ...

SQL Server 2000 & Oracle 9i

Asif Razzaq Attari - 20 Dec 2006 3:58 AM - 3 messages

I want to install SQL Server 2000 & Oracle 9i on the same box. Do they work fine when they are installed on same machine? ...

sp_prepare vs sp_executesql

Hassan - 20 Dec 2006 3:30 AM - 3 messages

I see a lot of sp_prepare calls followed by sp_execute and sp_unprepare. Why is it called as such ? What does it do ? Does it have any performance issue ? How can we rewrite it to perform better ? Also what is sp_executesql and how is it different from sp_prepare. ...

Sql Server sometime starts sometime starts not when starting windows system

Rolf Welskes - 20 Dec 2006 2:41 AM - 3 messages

Hello, I have some instances of sql server 2000 and sql server 2005 on my test-system. All instances but not the problem instance have windows authentication mode. The problem instance we can name it MSSQL$INSVR has both windows ...

SQL Server Backup Job - Map Drive

Joe K. - 19 Dec 2006 11:36 PM - 3 messages

I would like to create a SQL Server database backup job to a network map drive. I would like to backup this database (NMEXICO) daily. The network map drive that I would like to backup to is: (X:\NMEXICO\Backup) ...

Install system data files on the SAN for SQL2005

Johnny - 19 Dec 2006 11:29 PM - 2 messages

We are running failover clustering for SQL Server 2000. I used to able to install SQL 2000 program files on C:\ drive and system data files on the SAN (says H:\) which is required for failover. How can I install program files and system data files (Master, MSDB etc) on ...

Select query blocks itself

Eduardo Sicouret - 19 Dec 2006 11:23 PM - 6 messages

Hello, I have the following query: SELECT sma_call_log_id, usr_name, contact_name, phone, name, rec_filename, monitor_calls, monitor_flag, app.comments, description, callref_id FROM tbsma_app_calls AS app with (NOLOCK) INNER JOIN tbsma_call_log AS clog ON app.sma_call_log_id = clog.code INNER JOIN tbpic_reclamos AS cont ON clog.contact_id = cont.contact_id ...

Security question

JJ - 19 Dec 2006 10:20 PM - 2 messages

I am completely new to the security aspect of the database, so bear with me. 1. We have an asp.net application. Right now the user that connects to the sql server 2000 has db_Owner role. Since the application only uses the ...

Backup using the proxy account in SQL2005

Chris Wood - 19 Dec 2006 8:30 PM - 13 messages

Hi, We want to use the proxy account to take backups created from maintenance plans in SQL2005. What permissions does the proxy account need to do this? It has permissions to run SSIS packages and it failed saying the package ...

Problems with Profiler on SQL 2k5

Catadmin - 19 Dec 2006 7:57 PM - 17 messages

Has anyone run into any problems with Profiler for Server 2k5 killing their applications? We have a clustered Production environment (active/passive). The database is connected to via an MS Access ADP file which in turn the end users open ...

Having trouble using timestamp as a way of determining what to pro

nickdu - 19 Dec 2006 7:38 PM - 16 messages

This is similar to: [link] ...

A differential backup that seems to darn big...

Not the Face - 19 Dec 2006 6:27 PM - 3 messages

I have a db that is currently about 7 gb. It is currently on a test instance of SQL 2005. It is not being used by anyone but me for the purpose of learning one or two things about 2005. Here is what I deem ...

Performance Monitor SQL Counters question

Catadmin - 19 Dec 2006 6:15 PM - 4 messages

I'm a bit confused, so I hope someone can help. Under the MSSQL$AAP1:Databases Object are two counters. Data File(s) Size (KB) and Log File(s) Size (KB). If I understand these correctly, they are to ...

For/Next loop to process INSERT INTO statement

Doctorjones_md - 19 Dec 2006 5:48 PM - 5 messages

I reposted this because I was unable to achieve desired results from previous recommendations. Previous Post: =================== I have the following code which does the following: 1. Deletes all rows having a value of "0" in column C 2. Uploads the data in Row 2 to my SQL Server ...

Select result into file

Franck Fouache - 19 Dec 2006 5:27 PM - 2 messages

Hi, is there a simple way to get the result of a sql statement into a file ... with doing select * from table into 'c:\myFile.txt' for example ... the aim is to get de file produced when for xml is in sql statement ... ...

evils of dynamic SQL

Hassan - 19 Dec 2006 4:32 PM - 3 messages

What are the cons of dynamic SQL as it relates to performance ? Are any of the cons improved upon in SQL 2005 ? ...

Uninstalling 2005

Emma - 19 Dec 2006 3:54 PM - 2 messages

I want to uninstall SQL Server 2005 from a server. Is there a way of saving/backing up or scripting the current installation so that it can easily be installed again? If it is possible, how do I do it? ...

what command to see all SQL Servers on the network ?

Hassan - 19 Dec 2006 3:50 PM - 4 messages

What command do I use to see all the SQL Servers in the network ? ...

Base64

Franck Fouache - 19 Dec 2006 3:47 PM - 3 messages

Hi, is there a way to extract data in base64 ... i'd like to do something like : select cast(A_PHOTO as binary base 64) from article does anyone know a way to do it. Best regards. ...

Warning: unable to allocate 'min server memory'

J1C - 19 Dec 2006 2:57 PM - 3 messages

I have a Win2k3 EE server with SQL2000EE with 8GB of RAM. /PAE and /3GB are enabled as well as AWE. Max mem is set to 6144 as is min however after a reset of the server this warning is appearing: ...

Setting permissions for a Asp.Net website using a Sql2005 database

Nemisis - 19 Dec 2006 2:14 PM - 13 messages

Hi everyone, hope your all looking forward to xmas. I am setting up a Sql2005 database on a Windows Server, running Windows Server 2003. The database is going to be accessed via users using an ASP.Net website. My website is running the normal IUSR account. And users must login to ...

Error Message 8152

Al - 19 Dec 2006 2:09 PM - 7 messages

Hi I wonder if anyone can help, I am getting the following error messages when I try to do a number of things. 1. Select Job > Script job as > create to > any option file / query editor 2. View Job History. ...

SQL Server performance over internet connection

jhall - 19 Dec 2006 1:44 PM - 11 messages

I have cable modems on both ends of the connection. I am using Access 2003 with ODBC linked tables to a MS-SQL Server 2000 db. The database is quite large with 2 million records in 130 tables. But, the performance problems occur when returning as low as 100-250 ...

Cannot Defrag Index

David Wimbush - 19 Dec 2006 11:08 AM - 7 messages

I'm having trouble defragmenting some of my indexes. Here's an example. The unique clustered index automatically created from setting a primary key constraint on this table's identity column. According to sys.dm_db_index_physical_stats the index is 83% fragmented ...

How to include more databases in DB Mainteance Plan for SQL Server 2005

Peter - 19 Dec 2006 9:27 AM - 7 messages

Hi, I have created a DB maintenance plan by using wizard to backup a production database daily. There is a request to include 2 more databases to be included in the maintenance plan. I select the maintenance plan and press "Modify" but I am ...

BULK INSERT - error column too long

Franc - 19 Dec 2006 8:55 AM - 5 messages

Hi, I need to load a data file with bulk load. I have these table: CREATE TABLE [dbo].[test_db_import]( [campo_0] [ntext] COLLATE Latin1_General_CI_AS NULL, [campo_1] [ntext] COLLATE Latin1_General_CI_AS NULL, [campo_2] [ntext] COLLATE Latin1_General_CI_AS NULL, ...

SQL2K Restore 133GB database question

Uday Shivamurthy - 19 Dec 2006 6:15 AM - 9 messages

Hi all, I've got a 133GB SQL2K database with data files on 3 logical drives. There is only one log file on the correct logical drive. I took a backup and dropped the db. Now, trying to do a restore using this syntax. ...

How do I compact the LDB database?

BJ - 19 Dec 2006 5:58 AM - 3 messages

We have a MS SQL 7.0 server. The LDB portion is about 6GB! the MDB is only 350MB. Any suggestions on how to shrink this? The database is for a MS MOM server. thanks! BJ ...

upgrade to SQL 2005

00MichaelJordan - 19 Dec 2006 5:57 AM - 3 messages

Hi, Can I use the SQL 2005 STD CD ROM and directly upgrade the existing SQL2000 server? Is there anything I need to be careful about? Thanks. ...

Linked server (Access file)

Curtis - 19 Dec 2006 5:07 AM - 6 messages

I have created a linked server with an Access file. I can run queires against the linked server if I log in to Management Studio using the domain admin account. I can't run queries against the linked server if I am logged in ...

Getting rid of unused indexes - sql server 2000

Pedja - 19 Dec 2006 4:58 AM - 6 messages

Hi, I'm analyzing index configuration in one large database (800GB). I am not familiar that much with the application. Since I suspected that bunch of indexes are not being used at all (for most of "suspicious" composite indexes, less selective column is listed first - one of the things that makes ...

Does Tlog actually contain data ?

Hassan - 19 Dec 2006 4:44 AM - 8 messages

Say I update a column affecting a few thousand rows but do not issue a commit .. I want to know if all these new values for the column, are they in the Tlog or they actually get checkpointed to the data files as well ? ...

Error in Backup

raju - 19 Dec 2006 4:35 AM - 4 messages

Hai, In our application, i want to take database backup through application. So I return code like this, i got a backup in another folder. But, when i attach that new backup mdf file i am getting error ...

object ownership question

Alex - 19 Dec 2006 4:34 AM - 7 messages

Hi Friends, How can I see an object's ownership in SQL 2005? I found I can use USER_NAME ( OBJECTPROPERTY(OBJECT_ID(N'table_name'), N'OwnerId') ). But I couldn't find anything in UI. You can see only schema in management ...

Disk permission to move SQL 2005 databases too...

Andres Perales - 19 Dec 2006 3:45 AM - 3 messages

I have a server with SQL 2000 and a name instance of SQL 2005, I am trying to use the copy wizard to move databases from SQL2000 to SQL2005, when I do this and to try to change the drive letters to my D: drive for the logs and ...

how to synchronize dataabase from SQLServer2000 to SQLServer 2005

acd - 19 Dec 2006 2:51 AM - 2 messages

Evey expert: Could anyone answer me that how to synchronize database from SQLServer 2000 to 2005: SQLServer 2000 work as publication to SQLServer 2005 work as subsricption. Pls help. Thanks a lot. ...

How to backup database

mrajanikrishna - 19 Dec 2006 2:20 AM - 3 messages

Hi Friends, I've installed SQL Server 2000 Enterprise Edition in Win 2000 server. Everything is running well. I want to backup my database. I did this way... 1. Right click on Databases in the left panel and chosen Backup ...

Regarding sp_spaceused sp

Iter - 19 Dec 2006 2:11 AM - 2 messages

Hi Guys, I have some questions regarding sp_spaceused sp. I run this sp in my database that I just restore from customer db in order for performance tuning. I got this result like: Database_name database_size unallocated_space ...

Can't change Memory in SQL 2K

Troubleshooting SQL server

Regarding sp_spaceused sp

Help with migrating jobs from SQL 2000 to SQL 2005

Linked server issues for named instances.

Backup and Restore Guidelines

Nightly Windows reboot

SQL 2005 Partial db restore from full backup?

Backing up Tables

SQL Server 2005 Security

Stored Procedure Query Problem

relationship between set ansi_defaults and set implicit_transactio

Help-Can I use 4 GB memory by SQL Server2000?

Uninstalling the default instance

SQL Server Agent not running

xp_cmdshell

Trigger Help...

Running a 3 step dts process serially in SQL Server 2000

probably a simple question. aggregating aggregates

Adding users from cursor

Backups Question?

Split Data File into Multiple File Groups..

Can 32 bit SQL 2005 run on a 64 bit processor?

how to improve memory utilization??

Application architecture

Get executed sql command with parameters

DBCC DBREINDEX

SQL 2005 Express with Advanced Services: missing providers

HELP: SQL Server Service can't start up!!!

Re Order table

How to include more databases in DB Maintenance Plan ?

query: child of child of child of...: Which are the descendants?

How to view log file

DateTime variable problem

Why is it using index scan instead of index seek???

"Multiple Cascade Paths Error in SQL Server"

Database Corruption (Please help!!)

[SQL 2005] SQLCLR UDT Comparison Methods

Where to find SQL Server Integration Services