There was a place I worked for that had a special database for developers to put data they wanted saved. It would delete anything created over a month ago on...

you should be able to strip out the go statements. I missed the part where you need to create a txt file. sorry about that. DTS is the way to...

as long as your code works, you should just be able to drop a SQL connection and an execute SQL task in a DTS package and execute it. If you...

I guess autogrowth could be off as well.

it means the tmpdb doesn't have enough disk space to grow as big as it needs to.

you can run this to see where your tempdb is and make more...

select name, crdate from sysdatabases

Create a temp table and fill it with the data you will need (names, emails, etc)

then create a loop to loop through that table and use sp_send_dbmail for each row.

Alternatively,...

in SSMS, right click the login and go to properties. Choose user mapping on the menu that is on the left side of that screen. It will show you what...

I would try it both ways and see what is faster. Indexes would change the efficiency of both queries. I like the first one based on readability.

you will have to do a restore with recovery on each database. this will allow you to do your testing. Afterwards, you will want to restore your last full backups...

it's not possible to take a backup without the security included in the backup.

Just a matter of preference and performance. The 2 queries will produce the same results, but different query plans. I would suggest testing both to see what one performs better.

select distinct empID from

(select empid from emp1

union select empid from emp2

union select empid from emp3) as emp

do you gen an error msg back?

basically, you just want to perform an exists on the inserted table to check for the 12 value, and send the email querying the inserted table again to produce the...