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...

linq usage doesn't need to be less secure !

Using linq as an excuse for open doors is the summum of laziness

some refs on using sprocs with linq:

http://www.mssqltips.com/tip.asp?tip=1542

http://weblogs.asp.net/scottgu/archive/2007/08/16/linq-to-sql-part-6-retrieving-data-using-stored-procedures.aspx

http://blogs.msdn.com/b/zainnab/archive/2007/10/25/linq-and-stored-procedures.aspx

http://msdn.microsoft.com/en-us/magazine/cc500645.aspx

GilaMonster (5/27/2011)

---

Elliott Whitlow (5/26/2011)

---

Jan Van der Eecken (5/26/2011)

---

GilaMonster (5/26/2011)

---

One very uncomfortable PM sent...

From the posts the person has made, they are totally out of their depth. 6TB DBs, major perf...

You clould find some info on the web, but I propose to just capture the full xml to investigate the availability of data and then have a look at bol...