It is best to always post your exact question documented with your actual code.

The more actual info we get, the better advise we can give you.

If you would have posted...

Seems to me to be the way to use a clr fn just to actually use one.

Why don't you use a regular tsql derived column ?

Once you have the script, you can use SQLCMD to deploy it to all your environments, or if you can group connect to the required instances ( SSMS registered servers...

river1 (6/3/2011)

---

🙂 the problem is taht i don't know what is the better for me.

I have SQL Server 2000 and i need that a job send an e-mail every time...

Please read the description and pick the one that suites you best.

http://www.sqldev.net/downloads/xpsmtp/default.html

keep in mind datetime holds date and time.

Your predicate looks for yourdatecol="2011-06-02 00:00:00.000'

edited.

Oh please don't use a date conversion function because it will avoid an index being used in the...

we have been using Gert Drapers smtp proc on our sql2000 instances for years. No outlook client needed !

Have a look at http://www.sqldev.net/downloads/default.html

start from scratch or restart form the point where it failed ...

I don't know what the effect is on the "network" problem, but at one time when I had...

also to keep in mind: you can "restart" a restore !

restore database ...

with

, RESTART

I recall using this a couple of time on win2003 os with sql2005sp2 with a...

Phil Factor (5/31/2011)

---

Yes. Nice to see them again. Many of these are unforgettable. I love the comic strip of Derek the Robot DBA being virtualised into coffee machine at Teched...

If you have enough space on the drive, copy the backup file locally and then perform the restore (using the local file).

does your service account have the needed windows auth to process the restore command using the file location of the back file ?

Please post the (generated) restore statement and the...

talismc (5/28/2011)

---

So I changed the identity increment to yes, I even put set identity_insert <tablename> on in my sqlcommand statement that is in my program and set it back to...

for your default trace info, have a look at http://www.mssqltips.com/tip.asp?tip=1739

On the other hand, it depends how you used sqlexpress.

If you use a User Instance, these databases will not show...

brom BOL: http://msdn.microsoft.com/en-us/library/ms191495.aspx

A copy-only backup is a SQL Server backup that is independent of the sequence of conventional SQL Server backups. Usually, taking a backup changes the database and affects...