hmm is this even possible with older version of SQL like 2000?

anyway, the first suggestion is good, but i think ill go for trigger on insert. so every time...

tell them to try creating a user same as yours when you where still there.. it should work.. because it has the right credentials 😀

Theres only a problem with...

hkflight (11/21/2011)

---

Hi Ron,

I follow your logic perfectly and expect the same results. Could this issue have to do with the fact that I am querying a view? In the origional...

CREATE TABLE T(Date_Stamp DATETIME,KW1 DECIMAL(5,1), KW2 DECIMAL(5,1))

INSERT INTO T

SELECT '12/10/2010', 5.3, 3.1 UNION ALL

SELECT '12/10/2010', 5.3, 3.1 UNION ALL

SELECT '12/9/2010', 4, 2 UNION ALL

SELECT '12/8/2010', 3, 1 UNION ALL

SELECT '12/7/2010',...

switch to simple recovery model. Backup database then shrink the log.

Sample below:

USE testdatabase

DBCC shrinkfile ( Employees_log, 1)

DO BACK UP FIRST!

mind you that if your using FULL recovery...

its pointless trying to calculate Log Shrink when your main goal is to have it small in the first place. 😀

shrinked data are pointless anyway. if there is a...

try using the NT account. I'm pretty sure you did not specify the right user credentials when installing SQL server. coz if you've done it right you'll never receive errors...

as per your story.. your not migrating from an TOO earlier version of SQL server(eg. 07, 2000, 2005) so there will be not so much problem about this.

BUT! if...

if error occurs it rollbacks right?

np siri.. 😀

copy paste the codes for each process.. i dont think there is such thing as converter for that.. its easier and safer that way rather than converting if ever.

hi you may use the technique below from todd engen.

In SSMS select Database Mail under Management, right-click and Configure Database Mail. After that's complete send a test mail using the...

hi!

you may refer to this site for configuring Database Mail!

http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/