Viewing 13 posts - 31 through 43 (of 43 total)
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...
===============================================================
"lets do amazing" our company motto..
November 24, 2011 at 2:28 am
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...
===============================================================
"lets do amazing" our company motto..
November 21, 2011 at 7:25 pm
hkflight (11/21/2011)
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...
===============================================================
"lets do amazing" our company motto..
November 21, 2011 at 7:08 pm
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',...
===============================================================
"lets do amazing" our company motto..
November 21, 2011 at 1:00 am
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...
===============================================================
"lets do amazing" our company motto..
November 21, 2011 at 12:11 am
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...
===============================================================
"lets do amazing" our company motto..
November 20, 2011 at 11:40 pm
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...
===============================================================
"lets do amazing" our company motto..
November 20, 2011 at 11:34 pm
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...
===============================================================
"lets do amazing" our company motto..
November 20, 2011 at 11:26 pm
if error occurs it rollbacks right?
===============================================================
"lets do amazing" our company motto..
November 2, 2011 at 3:23 am
np siri.. 😀
===============================================================
"lets do amazing" our company motto..
November 2, 2011 at 2:44 am
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.
===============================================================
"lets do amazing" our company motto..
November 2, 2011 at 2:07 am
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...
===============================================================
"lets do amazing" our company motto..
November 2, 2011 at 2:00 am
hi!
you may refer to this site for configuring Database Mail!
===============================================================
"lets do amazing" our company motto..
November 2, 2011 at 12:44 am
Viewing 13 posts - 31 through 43 (of 43 total)