Viewing 15 posts - 5,011 through 5,025 (of 6,676 total)
only4mithunc (6/17/2009)
since by default the unique identifire is non-clustured , the records should be in the same order I have inserted na..?
By definition, a table has no order. The...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 17, 2009 at 9:41 am
Flo, if you are trying to allow more than a single null, but everything else is unique there are two methods that I would recommend:
1) Use a nullbuster column (coined...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 17, 2009 at 9:40 am
GilaMonster (6/17/2009)
Yeah, I figured it out a while back. I still consider it broken.
Of course 😀
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 17, 2009 at 9:04 am
GilaMonster (6/13/2009)
And the quote button from time to time.
Interesting you say that cause I have seen it a couple of times now. I think I have it figured out.
If...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 16, 2009 at 5:18 pm
Glad you got it to work - just had to do that myself today. Installed the latest version to restore a backup on a new server. One of...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 16, 2009 at 5:07 pm
Also, since you are on 2005 you should change the page verification to CHECKSUM (once you have this issue resolved).
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 16, 2009 at 12:45 pm
Is the drive a dedicated drive for tempdb? If it is, then you really just need to identify why tempdb grew to that size and monitor for additional growth.
If...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 16, 2009 at 12:14 pm
Where are you clicking on modify? Are you trying to modify the SQL Server Agent job, or the Maintenance Plan?
For SSMS Maintenance Plans, you should not modify the agent...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 16, 2009 at 11:47 am
iqtedar (6/15/2009)
i did try that with extractor...it works..but for some reasons it is splitting the litespeed backup into 14 different sql native client backups..thanks everyone
You are getting 14 files because...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 15, 2009 at 5:40 pm
Lynn Pettis (6/15/2009)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 15, 2009 at 12:40 pm
drodriguez (6/15/2009)
I'll stick with converting it to a varchar first then a date field.Thank for your guys help.
Dave
Yeah, that is probably going to be the best option. If...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 15, 2009 at 12:25 pm
drodriguez (6/15/2009)
Yes, that worked and is slightly better. But is there anyway to convert from int to datetime?Thanks,
Dave:-)
Yes, you can convert directly from INTEGER to DATETIME. However, you cannot...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 15, 2009 at 12:16 pm
That test button is only valid when using SQL Mail. If you have set this up and cycled the agent service it should now be working.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 15, 2009 at 9:16 am
Look up sp_executeSQL in books online. You can input and output variables to a dynamic query executed with the above.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 14, 2009 at 9:36 pm
You need to configure SQL Server Agent's alert system to use database mail.
Right-click on SQL Server Agent in Object Explorer and select properties. Select the Alert page and configure...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 12, 2009 at 4:24 pm
Viewing 15 posts - 5,011 through 5,025 (of 6,676 total)