Database Mail only sends SMTP email messages and logs problems connecting to the mail server. However, I also need to log bounced emails (bad...

Manny Klystron

04-25-2007 09:19 PM
Greg D. Moore \(Strider\)

Hey guys - I need your help. We are using SQL Server 2000- do you think, we should upgrade to some later release of Microsoft SQL Servier or Migrate...

mark_smith

04-25-2007 06:11 PM
Erland Sommarskog

Hi, I'm designing a new database and I have a doubt in which surely you can help me. I'm storing in this database historical data of some...

Nacho

04-25-2007 06:08 PM
Erland Sommarskog

Hi All I am updating a local table based on inner join between local table and remote table. Update LocalTable SET Field1 = B.Field1 FROM...

rshivaraman@gmail.com

04-25-2007 05:49 PM
Erland Sommarskog

The Puget Sound Oracle Users Group is hosting, May 17th, a database agnostic one day seminar by Joe Celko titled "Thinking in Sets." While this...

DA Morgan

04-25-2007 05:00 PM
DA Morgan

I'd like to use Database Mail to contact subscribers, but need to know if Exchange couldn't deliver an email (bad address, etc). With SQL Mail you...

Manny Klystron

04-25-2007 04:49 PM
Manny Klystron

Hi All I am updating a local table based on inner join between local table and remote table. Update LocalTable SET Field1 = B.Field1 FROM...

rshivaraman@gmail.com

04-25-2007 11:45 AM
rshivaraman@gmail.com

Hello, I've a problem where some data gets updated but I don't know which process (SP) is responsible for it (it's an old installation which...

Joerg Gempe

04-25-2007 11:31 AM
Erland Sommarskog

Hey guys - I need your help. We are using SQL Server 2000- do you think, we should upgrade to some later release of Microsoft SQL Servier or Migrate...

mark_smith

04-25-2007 08:19 AM
mark_smith

Hi, When I debug our sp by using T-SQL Debugger, I got following error. Server: Msg 229, Level 14, State 5, Procedure sp_sdidebug, Line 1 EXECUTE...

Rahul

04-25-2007 07:58 AM
Greg D. Moore \(Strider\)

Hi, When I debug our sp by using T-SQL Debugger, I got following error. Server: Msg 229, Level 14, State 5, Procedure sp_sdidebug, Line 1 EXECUTE...

Rahul

04-25-2007 06:32 AM
Rahul

Hi, When I debug our sp by using T-SQL Debugger, I got following error. Server: Msg 229, Level 14, State 5, Procedure sp_sdidebug, Line 1 EXECUTE...

Rahul

04-25-2007 06:27 AM
Rahul

Hello, I'm trying to create a simple back up in the SQL Maintenance Plan that will make a single back up copy of all database every night at 10 pm. ...

Rico

04-24-2007 11:24 PM
Greg D. Moore \(Strider\)

I am looking to populate a Schedule table with information from two other tables. I am able to populate it row by row, but I have created tables that...

Nate

04-24-2007 11:01 PM
Plamen Ratchev

Hi! I have a stored procedure that takes 22 minutes to run in one environment, that only takes 1 sec or so to run in another environment. Here is...

Dmitri

04-24-2007 06:28 PM
Erland Sommarskog

HI, Can anyone tell me abt the following error while i was running my ASP.net project and codes were in vb.net? Line 1: Incorrect syntax near...

sharmin.sdconsultant@gmail.com

04-24-2007 06:08 PM
Erland Sommarskog

Using SQL Server 2000 I need to extract all the grants made to a user created role so that I can recreate the role in another version of a database...

Mark D Powell

04-24-2007 06:07 PM
Erland Sommarskog

I have a problem that I would like to resolve through scripting, but I'm not sure how to go about it (or if it's even possible.) We're trying to...

pk

04-24-2007 12:34 PM
pk

I am attempting to compile a list of questions that will enable me assess 'at risk' stored procedures that need to be remediated in order to minimize...

Umar Reyi

04-24-2007 11:02 AM
Jack Vamvas

Hi all, I am dealing with a very large database, and as soon as a record is submitted I need to run a full-text query against it. I believe it might...

Pacific Fox

04-24-2007 10:56 AM
Jack Vamvas

guys, I have a project need to move more than 100,000 records from one database table to another database table every week. Currently, users input...

Lee

04-24-2007 04:07 AM
Erland Sommarskog

We are running on SQL 2000 on Windows 2003. We have active-passive clustering set up. We have 16 GB of RAM on each box. This past weekend, we...

astrohorse26@hotmail.com

04-23-2007 05:27 PM
Erland Sommarskog

Hey guys - I need your help. We are using SQL Server 2000- which version do you think we should upgrade to. Also, wondering if you tried any Open...

bhuta.darshan@gmail.com

04-23-2007 05:13 PM
Plamen Ratchev

I'm trying to get the execution plan for a single stored procedure from Profiler. Now, I've isolated the procedure but I get all execution plans. Any...

TheRealPawn@gmail.com

04-23-2007 11:17 AM
TheRealPawn@gmail.com

Hi, I have a table that I insert a member's country into every time someone signs up. What I'd like to do is pull information from the DB such that...

Erik Lautier

04-22-2007 11:03 PM
Erik Lautier

SQL Server 2000 SP4. Running the script below prints 'Unexpected': ----------------------------- DECLARE @String AS varchar(1) SELECT @String =...

Dimitri Furman

04-22-2007 05:37 AM
Erland Sommarskog

I have been programming access databases for 8 years. Well today I find out that I need to know SQL. HUH LOL well I don't have a clue as to how...

sparks

04-22-2007 01:55 AM
Ed Murphy

Hello everyone, There's an interesting SQL problem I've come across that I'm currently banging my head against. Given the following table that...

Anthony Paul

04-21-2007 11:32 AM
--CELKO--

Our database is running in full recovery mode and we backup the log file every hour and the database file every night. I notice the timestamp of...

akkha1234@gmail.com

04-21-2007 08:43 AM
Erland Sommarskog

I have a query..if you look at the bottom of the where clause you'll see an "NOT IN" statement that is really hanging up the query..i'm trying to...

Jimbo

04-21-2007 08:28 AM
Erland Sommarskog

Hi, I'm trying to outer join to a maximum date value using a subquery in order to return company information and the last activity date associated. ...

Chris H

04-21-2007 05:16 AM
Erland Sommarskog

Hi, I'm trying to outer join to a maximum date value using a subquery in order to return company information and the last activity date associated. ...

Chris H

04-21-2007 12:12 AM
Chris H

Is this command, which I know can be executed on a per-table basis, the same as the Rebuild Index Task in the SQL Server Management Studio for...

tlyczko

04-20-2007 06:19 PM
Erland Sommarskog

Hi, I am writing an in house utility to attempt to compare different aspects of databases. I am currently writing the queries to list all of the...

Paul

04-20-2007 08:18 AM
Erland Sommarskog

Is there a certain way of adding users to access a linked server? I linked to an Oracle server but somehow, I'm unable to add any users, even after...

Danny

04-20-2007 06:58 AM
Paul

Hi Guys n Gals, I am going to migrate an Access VBA application to SQL Server 2005. Essentially, what I need to do is to: * open a recordset * grab...

bubbles

04-19-2007 08:44 PM
bubbles

Hello everyone, I am involved in a scenario where there is a huge (SQL Server 2005) production database containing tables that are updated multiple...

Anthony Paul

04-19-2007 06:02 PM
Erland Sommarskog

Hi How can I create a job in sql agent to create a new snapshot every hour? I have, for eg a T-SQL that does it manually. create database...

MPD

04-19-2007 05:39 PM
Erland Sommarskog

SQL Server 2005 SP2 question: The SSMS "Activity Monitor" provides a column "Net Address". In most cases, this is the MAC address of the client's...

Larry Bertolini

04-19-2007 09:57 AM
Larry Bertolini

I want to create a table with member id(primary key for Students,faculty and staff ) and now i want to create issues with foreign key as member...

Chirag

04-19-2007 07:06 AM
nehajain.cse@gmail.com

Hello, I am getting the rather odd error below; hope you can help. RESTORE DATABASE is terminating abnormally. File 'C:\Program Files\Microsoft SQL...

GitarJake

04-19-2007 02:53 AM
Erland Sommarskog

Is it possible to have spacing within a column name? Something like "column name." I can do it from EM but won't let me do it in query analyzer. Can...

Danny

04-19-2007 01:13 AM
Plamen Ratchev

I have a database column that stores a comma delimited list of foreign keys. Would someone show me how to do a join using the values from a list...

Chris

04-18-2007 06:22 PM
Erland Sommarskog

osql command is not executing on Remote server(by using link server) osql -S ucmain -U sa -P abc -l 2 -Q ucmain is remote abc password After...

ahsan kabir

04-18-2007 06:17 PM
Erland Sommarskog

Okay, here is a real mellon scratcher. I've got a server I've got semi-automated backups on. A typical backup looks like: BACKUP DATABASE...

Utahduck

04-18-2007 06:01 PM
Erland Sommarskog

Kinda new to SQL, using SQL Server 2005. I have some foreign keys in a couple of tables. I need to drop these tables, but can't since I'll get the...

apax999@gmail.com

04-18-2007 05:58 PM
Erland Sommarskog

Database consists of the following 4 tables with respective attributes: CUSTOMER(C#, CUSTOMER NAME, ADDRESS), the key is ITEM(I#, ITEM NAME,...

tizmagik@gmail.com

04-18-2007 05:54 PM
Erland Sommarskog

Hi. How does one return a range of rows. I know that "Top 5" will return rows 0 - 5 but, how do I get 6 - 10? thanks

pbd22

04-18-2007 03:41 PM
pbd22

Hi everyone: We received a error message "Log File to Database is Full. Backup the transaction log to free up space." I have a Access 2000...

eighthman11

04-18-2007 01:42 PM
MPD

(SQL Server 2005, express edition) I have a list of table names that I need to translate according to a naming convention. I'm doing this using...

bbcworldtour@hotmail.com

04-18-2007 07:27 AM
Dan Guzman