I tried to backup a database but failed: In EM, right click Northwind, select All Tasks, Backup a database... Enter Description, select complete backup, Add a destination to a location, set the shedule. But there is not backup after the schedule time. Anything I missed ? ...more >>

hi, does anyone know how to change a dts packeage's owner name on sql 2000? we have individuals that creates dts packages on production servers, and we would like to change the dts owner name from the individual accounts into server's own account name. many thanks! JJ...more >>

Hi, I moved jobs from a server to a new one with dts. However I cannot delete, edit, enable, ... these jobs. If I try so I get the following error: 14274 Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server. We changed the name of the server a...more >>

I'am attempting to modify an SMS 2003 web report to include data from a linked SQL server. Running the query (report) in Query Analyzer works fine, however, running the report via the web returns the error: -------------------------------------- Heterogeneous queries require the ANSI_NULLS ...more >>

I hope this is a simple enough question to answer. Every night we back up 2 large Production database files and then move them over to our testing SQL environment (different) server, so that our developers can play with one-day old production data. My boss wants me each night to export out ou...more >>

I'm trying to implement a scaled down version of log shipping by: 1. Backing up a database on server A and then restoring it to server B (using WITH STANDBY). 2. Taking tranlog backups every 15 minutes from server A and then restoring them on server B (using WITH STANDBY). I take great...more >>

Hello, I am trying to create a select where I need to return the modified the contents of a column. The type of modification depends on the columns value. This is a year 2000 problem where the full year has not been stored in the database. The column is not a date but a sample number an...more >>

As a quick and dirty solution, I implemented a logdump by running a maintenance wizard. This created a job which dumps the log from all the user databases several times a day. The problem is that some user databases are in "simple" recovery mode - no logfile to dump. The job fails and I got ...more >>

I need to grant EXEC permission to several users on my Procedures. I would like to to do this in One GRANT statement. this doesn't run. What do I need to change. GRANT EXEC ON --Proc_Clear_data_CAS_ODS --Proc_Clear_data_CMS_ODS --Proc_Clear_data_GAS_ODS --Proc_load_data_ShipperDim -...more >>

A weird problem on one of our SQL 200 Standard Servers. They are running SP3 with 4GB of Ram, and plenty of drive space, the DB's being on a SAN volume. When we try to run a Select and INsert from one table to another, it is successful only up to 500 rows. If its 501 rows or more, the state...more >>

Hi there, I am trying to upgrade our sql server db from version 7.0 to version 2000. I was successly able to restore the sql 7.0 db into 2000 server. Everything seems to be working fine except one important stored procedure. When i execute this particular stored procedure,it works fine...more >>

I 'm running sql server 2k, with service pak3a, Win2k with lastest service pak. We have a database that shows as being 9gig, with 0.00 MB free when looking at the properties of it in Enterprise manager. The hdisk where that database resides has 45gig free, with no disk quotes. Also, the databa...more >>

Hello all, I am using SQL Server 2k SP3 on Windows 2000 server. I setup db maintenance plans to backup my databases across the network to a Terrabyte NAS storage unit. The jobs execute, but then seem to lose connectivity to the NAS after about 10 - 15 minutes. I get the following errors in SQ...more >>

I've been having the same problem for 2 weeks now. If anyone has any ideas, I'd love to hear them. We are using both SQL and Windows Authentication. I was running a Profiler Trace at the time, and am going through it now but have not seen anything yet. Thanks in advance. About once a wee...more >>

Hello,I have a table (T)like the following: I Syn 1 AB 2 BC 3 DB 4 ACD 5 DBC What I want to do is replacing A with 1, B with 2, C with 3, D with 4, so I wrote like this: SELECT i as 'index', 'trans'= case when patinde...more >>

I have a server with Windows 2000 Advanced Server with SQL Server 2000. This is a cluster server. We have 8 GB of memory 5.5 GB SQL Server and the rest for the operating. We would like not to apply the /3GB switch so that SQL Server will obtain more of the lower 3 GB of memory. W...more >>

How or where does one get *meaningful* error logs from SQL Server/SQL Agent? The logs generated on SQL Server are wholly inadequate, unless I am missing something. A sample - trying to find out why my Integrity Checks job failed last night: DBCC CHECKDB (gIQInternetMaster, repair_fast) execute...more >>

Hello I try to run the following query: Update DestTable set DestBLOB = (select SourceBLOB from SourceTable where SourceTableID = 123) Where DestTableID = 321 I always get the error message that this is not possible with image data. Does anyone know a solution on how to copy a BLOB from on...more >>

Dear All, I would like to have a job that runs all the times, how should I set up the scheduler ? ...more >>

Hi, I am looking for a way to pick specific records from a view I have created. The data from my view looks like this: machineid serverdate kioskdate kiosktime ITG70000011 2004-09-30 01:59:52.000 2004-09-28 00:00:00.000 1900-01-01 02:02:28.000 ITG70000011 200...more >>

I currently have maintenance plans defined to run backups for all DB's. For one specific DB I have the reovery model set to simple. When the backup runs for this DB I am receiving the following msg in the log: Backup Failed to Complete the Command Dump Transaction xxxx With Truncate Only'. ...more >>

I hope someone can shesd some light on a problem I am having. I have a two column for new username and password to be stored in prior to an overnight stored proc to create them. The username field is a varchar(32) and the password is a varchar(30). The problem I am having is that if I select t...more >>

At an installation of SharePointPortal Server 2003 were created automatically 3 databases. The jobs for optimizations and integrity check for one of these databases produce always errors: [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL Server Driver] [SQL Server]...more >>

Hi, I have the following situation: My source server is MSSQL 2K without servicepacks. My destination server is MSSQL 2K with SP3. Both running Win2K with sp4. Assume I don't want to upgrade the source server. What are my options: 1) Is it possible to backup the database on the source s...more >>

Hi, I'm trying to get sp3a to install unattended but I don't know how to get an .iss that works correctly it's on a win2K server, standard sql server...more >>

I have some developers who require profiler access. I don't want to give them sysadmin privileges and have heard about accessing the underlying stored procedures that Profiler uses - is it possible to defer rights to these procs to a non-sysadmin person? TIA, Anon...more >>

Hi, How to set isolation level permanently in sql server and how to check my currenct isolation level? Thank you regards, florence ...more >>

Hi, Window2000 server +SQL server 2000 I am trying to migrate my current SQL server application to a new setup, my setup procedure is as below procedure: 1.Install OS win2000 + SP4 2. Install SQL server 2000 +SP2 3. backup MASTER db and MyDB on the old server, then copy these backup to new...more >>

I know that a Transaction witch contains more operations, have to finish all it(COMMIT) before an other operation can start. It's the same when I call a Stored Procedure in one of transaction operations? I have to update a field and get it with the new value in an unique transaction, becau...more >>

I want to do something like this. SELECT * FROM dbo.Contact [C] -- If any rows are returned then return to front end. IF @@rowcount > 0 Begin GOTO FinishSuccessModule E...more >>

After upgrading a computer to Windows XP Service Pack 2, I am unable to connect to SQL Server remotely. (It's the version that ships with Visual Studio.NET - I think 2000). I've disabled the Windows Firewall, and also (just in case it makes a difference) added the proper sqlservr.exe file to...more >>

Can anyone explain how I/O cost is calculated? My example: Physical operation: Clustered Index Seek Logical operation: Clustered Index Seek Row count: 1 Estimated row size: 76 I/O cost: 0.00632 CPU cost: 0.000080 Number of executes: 1 Cost: 0.006408(100%) Subtre...more >>

Hello, I ran DBCC CHECKDB on a database with some performance issues today and received several errors. I restored from a backup (from last week, the earliest one we had) as the database has not gone into production use yet. The database however does contain a considerable amount of data...more >>

I have SQL2000 Enterprise running on a Win2003 Enterprise machine, with 16GB of ram....and no other applications. I start the database up and get an error "unable to allocate 'min server memory'", which doesn't allow the DB to startup unless I bring the setting down to around 1GB.. Any idea why t...more >>

Hi, I am running Veritas Backup Exec 9.1 and I'm backing up a SQL 2000 SP3a server. Everything is working great. Now, just so you know, I know nothing about SQL. If I wanted to restore this to another machine, different name, Is restoring the databases good enough? or do I need other ...more >>

I'm trying to find a way to shutdown the SQL server service on a Windows Server 2003, SQL server 2000 SP3. Veritas Netbackup 4.5. I'm currently backuping the SQL server throught the SQL server maintenance plans and it works fine. Now when I try to backup the entire server with netbackup the ...more >>

Hi, I have a table that has different owner than DBO. When I include this table in publication, SQL Server does not allow to enable automatic identity range for this article. Any help would be greatly appreciated. Leila ...more >>

I want to access SQL Server 2000 database via VB.Net to get the list of stored procedures and their associated parameter names and parameter types (date, string, etc.). I am trying to expand a current XML file and application that provides maintenance of SP's to run for related Crystal re...more >>

We have a plan to set up log shipping to a standby database and then fail over to that database as a means of migrating our production environment with minimal downtime. Our front-end servers (this is a MS Sharepoint system, by the way) currently access the database via a virtual hostname...more >>

Hi Has anyone out there had experience of using IBM Tivoli Storage Manager for databases to replace the normal SQL backups using database maintenance plans or SQL backups through scheduled jobs. I have a non-uk office that is no longer using Backup Exec and tapes and is using the above for b...more >>

Hi, Did somebody know if I can set an Email alert in SQL Server when some connection is block by somebody else? Thanks, Sylvie ...more >>

I'm trying to remove duplicate rows from a table. tableA has 2 cols. acctid and col1 When I run: select count(distinct accid) from tableA I get 10 as a result(I guess there are 10 distinct rows in the table, correct?), but when I run: select distinct acctid, col2 into #temp from tableA (tho...more >>

Hi, I change the filegroup of my table's BLOB using EM. How can I do that without EM (using TSQL). Many thanks, Leila ...more >>

Hi all, can anybody please how to reset passwords for an DTS? I need to edit and run it...but the former DBA left without giving us the passwords... Thanks, Tudor ...more >>

I installed Service Pack a3. It seems that Windows Automatic Updates is not able to catch any patch(not sp) for SQL Server. Is there anyway that I can make the patching automatic(at least notify me when a patch for SQL Server is available)? Thanks in advance! Bo Sun...more >>

In Query Analyzer is there anyway I can tell if Backup Exec is running? Environment: Windows 2000 server, SQL 2K, BackupExec 9. Thanks, ...more >>

I wish to kill all the processes for a given database. have written the script that gives me all the spids for the database, however I get an error when trying to execute; KILL @spid; (Incorrect syntax near @spid) where @spid is declared as a smallint. Can anybody help? TIA ...more >>

Our SQL Server 2000 running on NT 4 was installed on Windows 2003 Server. All the databases were attached to the new installation. Now, when I try to run a program loading data in a database I get an error: Login failed for user 'username'. In the SQL Server log there is a message Login failed...more >>

To figure out which licensing option for SQL to recommend to our customers, we need to know how many processors we need. On MSDN I ran through a couple of capacity planning tools, but it keeps saying I need 2 CPUs, which costs 40K if you go with the Processor license (versus Server with User C...more >>

We want to create a reporting database from our OLTP database. We are thinking to take an initial snapshot and then use transactional replication. However, we also want to keep the OLTP database with only one year of data. If after one year, we remove records from OLTP, the transactional replic...more >>