take a look at this forum post;

in the middle of it I've produced a script that exports all the database mail settings and profiles;

the only tough part is the SMTP...

here's one way to do it, but at some point, you have to make a logical decision about what database to use.

by using synonyms, you can reuse the same code,...

yes, you'll need either a VPN or a firewall hole to get to the DMZ server;

the whole purpose of the DMZ was to isolate it from contact for security purposes....

here's a couple fo examples:

note the end date, you might want to change that to be just lss than, unless you want to include midnight on 01-15-2012

--Hardcoded:

SELECT * From [SQLTable]...

or even better:

I've only done this for testing,but not in production:

research a little deeper on how to rename the sa user to something else, and create a regular user named...

with all the concerns about losing customer data, it's a pretty big liability hole;

how about putting them on a seperate SQL instance,instead of that production server, and that would...

what you posted originally was using an explicit connection string, and no DSN; did you ever confirm that you can connect from another machine?

bump it to the groups that handle the contracts and RFP's;

for example bring the issue up with the contracts/legal department; check to see if the contract explicitly states they...

dwain.c (6/14/2012)

Lowell - Another nice learning experience from you. That's now 2 in as many days!

I see this was introduced in SQL 2005. Any idea if it can...

If you have all the descriptions ready so you can script them; I would drop if exists and re add themback no matter what forget if the values are there...

if it exists at all, even with old values?

this example would use IF EXISTS (i think!) to check if it's already there:

IF NOT EXISTS(SELECT 1

...

i think either of these will do what you are asking:

SELECT *

FROM tbl_usermain FirstGuy

INNER JOIN tbl_user_friends FirstFriends

ON FirstGuy.user_id = FirstFriends.user_id

LEFT OUTER JOIN...

something like this i think?

select

Rented.make,

Rented.model,

Rented.year,

Rented.location,

Rented.agent,

Rented.status,

Returned.status

from Rentals Rented

LEft Outer Join Rentals Returned

ON...

i would probably tackle it with a scheduled job, or in a service broker fired on database restore or database creation.

it depends on what exactly you are trying to do,...

you can use a case statement to return a specific column value based ont heparameter passed:

CREATE TABLE [dbo].[ExRates](

[ID] [int] IDENTITY(1,1) NOT NULL,

[ratedate] [date] NULL,

[USD]...