no you cannot. backups are forward compatible, but not backwards compatible...meaning SQL 7 could restore a backup from version 6.5, but not any backups from 2000/05/08.

instead you'll want to...

i think your confusing parent-child relationships;

businesswise, the students and the table associated to them are the key/primary table.

information about the parents may or may not be available, so the table...

when you do a backup that does not include the WITH INIT clause, the new backup is appended to the same physical file. So after two...

I'm nearly the same winston; the only info that is in the master database that is special to me is logins, and I've created a script that pulls those out...

AFAIK there is no issues with leaving print statements in place; I've never seen or heard of an application suffering due to print statements.

even from an application you can read...

this is inside a procedure, right?

is @TodaysDate a parameter with a default of NULL?

if that's true, I'm thinking parameter sniffing is the problem, and a bad execution plan is being...

your query is good, all you need to do is change the ORDER BY in order to get it in the desired visual representation.

order by category,price desc;

I've gotten a Gmail account to work just fine; they use an alternate port for SMTP, but the rest was a typical setup:

in simple mode, the log would only have uncommitted transactions in it, right?

could there be a developer or some process that is starting a transaction, but never issuing the COMMIT?...

clearly!

A lot like you, I'm trying to anticipate the requirement and provide a solid example, but obviously...

using my magic hat and mind reading glasses, i read your request two ways differently than mazzz did:

1. that you really meant "create an empty table with the same column...

As Criss Morris suggested, using the OUTPUT clause is the best, especially if you want to capture multiple rows.

here's a prototype/best guess based on the SQLs you posted; this might...

you have to convert the field to a datatype that is allowed to be grouped, like a varchar()

SELECT ID, COUNT(Txt1) AS Txt1, Txt2, CONVERT(varchar(2000),Memo1)

FROM myTable

GROUP BY ID, Txt2, CONVERT(varchar(2000),Memo1)

HAVING (ID...

the mail runs from the msdb database, so you have to fully qualify everything, like

EXEC msdb..sp_send_dbmail

@profile_name = 'reports',

...

just change your plan to use a stored procedure.

a function cannot change data. No DML operations allowed, no dynamic SQL and a lot of other restrictions.

a stored procedure does not...