Viewing 15 posts - 3,196 through 3,210 (of 6,676 total)
GilaMonster (5/23/2011)
SQL 2005 32 bit or 64 bit? Are you installing 32 bit or 64 bit?
Good call - would be my next question also. But, just to verify I...
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
May 23, 2011 at 10:21 am
ofirk (5/23/2011)
Tracing to that level however, may...
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
May 23, 2011 at 10:18 am
SVR (5/23/2011)
Thank you very much.Can you suggest any ways that I can use to group the remaining logins.
I am not sure what you are asking here - if you are...
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
May 23, 2011 at 10:13 am
What I would do is create a server side trace - or login trigger to capture logins. Review the logins and disable any logins that have not accessed 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
May 22, 2011 at 7:01 pm
Well, there is no way to determine the activity on a trigger solely. You have to look at the activity on the table which will tell you what activity...
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
May 22, 2011 at 3:59 pm
I am not sure I follow what you are trying to identify. Triggers are fired when the table they are associated with are either updated, inserted or deleted.
If you...
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
May 22, 2011 at 3:39 pm
Welsh Corgi (5/22/2011)
Why do you need the Surrogate Key ID when you have a Natural Key ClientID?
How...
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
May 22, 2011 at 1:20 pm
prashantcomp90 (5/22/2011)
my problem is solved. how I tell u.
after so long discussion between us. I thought that if we can combine multiple tables in sql and create...
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
May 22, 2011 at 1:08 pm
Lucky9 (5/22/2011)
Create Table Status
( ID int Identity(1,1),
ClientID int,
StatusStartDate Datetime,
Status Int)
Insert into Table Status(ClientID,StatusStartdate,Status)
Values(100,'2010-01-28',1)
Insert into Table Status(ClientID,StatusStartdate,Status)
Values(100,'2010-03-20',1)
Insert into Table Status(ClientID,StatusStartdate,Status)
Values(100,'2010-05-30',2)
Insert...
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
May 22, 2011 at 12:47 pm
One of the things you should look at is using sp_updatestats instead. This procedure will identify those statistics that need to be updated and only run against those.
With that...
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
May 22, 2011 at 12:22 pm
What is the Edition of SQL Server 2005 and what is the Edition of SQL Server 2008 R2?
And finally, what is the OS version that you are installing on?
If you...
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
May 22, 2011 at 10:57 am
My mistake - I switched the ON/OFF for IDENTITY INSERT.
My statement about varchars does not have anything to do with LOB data. When you update a row - 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
May 20, 2011 at 7:05 pm
Lee Crain (5/20/2011)
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
May 20, 2011 at 5:53 pm
Welcome to the new and improved security in Windows Server 2008 and SQL Server 2008. When you installed the system, there was a barely noticeable check box to use...
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
May 20, 2011 at 4:45 pm
On the new system - did you just install reporting services, or do you have a new instance with new databases?
If you just installed reporting services, then you are going...
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
May 18, 2011 at 5:56 pm
Viewing 15 posts - 3,196 through 3,210 (of 6,676 total)