is the specific syntax error possible version related? something that would be fine in, say Version 90 or above(2005+) but not in SQL 2000? could it be somethign as simple...

the problem is the substring you are looking for does not exist in every field....you have to use a where statement or a case statement to filter them out. specifically,...

could the backup job be writing additional backups to the same file? ( does the script feature WITH INIT or not)

you might have a big 10 gig file with 10+...

when upgrading to a higher version, you'll want to rebuild the indexes and update statistics.

There are a lot of similar posts, where the upgraded server performs poorly until those two...

Jack Corbett answered in another thread that prompted me to question my sanity.

it's the wrong view, but i still cannot use sp_helptext on a server trigger?

select * from sys.server_triggers

Bill Hansen (11/23/2011)

---

The AUTO_CLOSE option is a server option in the model database and not a setting of the database. You can update the setting on your local server with...

that's a feature of express; by default, a database is autoclose = true in order to conserve resources.

since the setting is visible in master.sys.databases, and not INSIDE the database,...

not sure where your issue likes, i'm able to convert to a varchar(40) no problem:

create table Example(id int identity(1,1) not null primary key,myUQ uniqueidentifier)

GO

insert into Example (myUQ) VALUES (newid())

GO 10...

only if you can put a UNIQUE constraint on that one column of the primary key;

a foreign key (REFERENCES) can only point to a PK or UQ.

I've been using this to generate the 2008 style alter commands, instead of the deprecated? sp_change_whatever

--USE HDSTEST1100;ALTER USER [hds] WITH LOGIN = [HDS];

SELECT

CASE

...

memymasta (11/23/2011)

---

Lowell (11/23/2011)

Your example involving user and Education tables is really at odds with an email campaign.

here's a rough example i just sketched out that woudl use a cursor to...

the SQL browser service needs to be running, otherwise you'll have to "know" the machine name and instance name if it is a named instance...

try any of these variations

...

i know it's not much help, but that error number is an automation error..implying the DLL being called either does not exist or is not registered.

http://social.msdn.microsoft.com/Forums/en-US/vbinterop/thread/7c5c16d7-4029-4b6f-9a29-55a1c27718b5/

it kind of make ssense...

exactly...when UserA or UserB get fired or move...

memymasta (11/23/2011)

---

Yes, i am aware of that. I am trying to build a mailing service for our customers, using database mail. A weekly report email that needs nested loops to...