Developer Newsgroups: SQL Server Tools

copy database error 12291 and 208

Philippe - 1 Sep 2006 11:49 AM - 6 messages

Hi, when trying to copy a database from SQLSERVER 2000 To SQLSERVVER 2005 using Copy Database Wizard (CDW) it fails and give two errors in events: Source: SQLISPackage Event ID: 12291 and Event Source: SQLSERVERAGENT Event ID: 208 ...

SQL Mail Error

Jeff - 31 Aug 2006 12:45 PM - 2 messages

Hello, I'm running SQL Server 2000, sp4 on a 2000 Server, sp4 on a 2003 ADS domain w/ Exchange 2003 Enterprise as a mail server. When I try to configure SQL Mail and click "Test", I get the following error: ...

database mail...can't connect to mailserver

geek-y-guy - 30 Aug 2006 6:42 PM - 5 messages

Hi All: I'm trying to configure database mail in SQL2005 on Windows 2003. I have configured a public profile, users and SMTP account, but when I send a test email to the mailserver, I get the following error: Message ...

Best Practices Analyzer tool for SQL Server 2000

baref - 30 Aug 2006 4:35 PM - 3 messages

I am unable to download 'Best Practices Analyzer tool for SQL Server 2000 ' from the following link: [link] I am able to download other tools and files without issues. please advise. ...

DeadLock @ page+key (mix) level how to solve

kart - 30 Aug 2006 3:04 PM - 3 messages

Hi, We had deadlock on page level. How do we solve this issue. I identified the SP's that cause this based on SPID and ObjectID from SQL Log along with Profiler data. Here are the details of SQL Log ...

Name change, can't find origin of error

Reeve - 30 Aug 2006 2:06 PM - 2 messages

I've recently made a name change on a few database tables. I thought I got all the name changes done in the front end reference. However, this one eludes me. I've checked all the classes listed in the error ...

Reading .trc files of SQL Server 2000/2005

adkompella - 30 Aug 2006 7:54 AM - 2 messages

Hi, We have a requirement to read the .trc files generated by SQL server in real-time or atleast near real-time. We do not want to interfere with existing SQL server setup by running functions like fn_trace_get_table. The requirement is to get the events logged in .trc ...

SQL Server 2005 Activity Monitor doesn't show connections from Windows 98 clients

Rob Roberts - 29 Aug 2006 6:51 PM - 7 messages

I have a .NET 2.0 desktop application that connects to a SQL Server 2005 database located on a Windows 2003 box. If I run this application from a Windows XP workstation, the connection shows up under Process Info in the ...

differnt execution plans for same query

AnRa - 29 Aug 2006 10:55 AM - 9 messages

we have two sql server 2000sp4 on to branded win 2k3 servers. both systems have equal data in the same database on the first machine a query needs about 3-5 secondes on the other machine the same query needs about 30 to 40 sec with an ...

Why sql profiler show different values for same stored procedure

kart - 29 Aug 2006 9:41 AM - 3 messages

Hi, When we did stress testing, we found that for the same procedure the time taken is between 80 ms to 5000 ms. The procedure got executed 19929 times and out of which the value was > 1000ms only 13 times and many times it was ...

Event ID: 208

Joel - 29 Aug 2006 4:26 AM - 2 messages

I get the following error message when using Copy Database Wizard Event Type: Warning Event Source: SQLSERVERAGENT Event Category: Job Engine Event ID: 208 Date: 8/28/2006 ...

ReportMigrator

MarkNMcKay - 28 Aug 2006 9:04 PM - 1 message

Has anyone heard of this product called "reportMigrator"? It converts Crystal Reports to SSRS. The URL for it is [link] -Mark ...

SQL Management Studio "Open Table" Error

Alex Maghen - 28 Aug 2006 4:47 PM - 3 messages

When I try to use the "Open Table" feature in SQL Managment Studio (Standard), I get the following error: Class does not support aggregation (or class object is remote) (Exception from HRESULT: 0x80040110 (CLASS_E_NOAGGREGATION)) (Microsoft.SqlServer.SqlTools.VSIntegration) What am I doing wrong here? ...

Problem with auditing

Jeff - 28 Aug 2006 3:03 PM - 4 messages

We are waiting for a SAN solution to be installed and our current sql server has 8GB storage available and I am having our SQL auditing taking up tons of space. How can I disable all auditing or change settings on auditing within ...

Import Data

Alex Maghen - 27 Aug 2006 6:12 PM - 4 messages

I have installed SQL Server 9.0.1399 ("SQL Server Standard Edition") on my machine. I've also installed "Microsoft SQL Server Management Studio Express" (because I couldn't find Microsoft SQL Server Management Studio NOT EXPRESS ANYWHERE either in the SQL Server Install or to download from MS.com). ...

Setting column default

John - 27 Aug 2006 4:15 PM - 8 messages

Hi How can I make a datetime to default to current date/time? Can I set the 'Default Value or Binding' property to something to achieve that? Thanks Regards ...