rishgup (10/24/2008)

---

[quote-0

It might effect. It depends on the rate of the data modification statements. According to the trigger that you posted, all of the triggers are updating the...

jennifer_l_hogan (10/24/2008)

---

I am getting a data feed from a sql database that is provided to me in access.

It is 7500 rows of data with no unique identifer (I have asked...

rishgup (10/24/2008)

---

I figure out the error in my trigger. That was silly error. now Trigger is working fine and I am getting the result which I was looking for

But my...

pprajapati (10/24/2008)

---

I have created one login 'test' . give the database role db_datareader, datawriter, db_ddladmin on perticular database.

I want user is able to create/alter table , view and store procedure...

I also think that it is a great article. Unfortunately it can’t be mandatory to read it before the first post (as other pointed out even if before first...

Arul Manoj (10/22/2008)

---

Hi,

Actually my table has below structure:

RowNumber UserId UserNmae TimeDifferenceInMinutes

1 ...

Arul Manoj (10/22/2008)

---

Hi,

I have the below table structure:

RowNumber UserId UserNmae Date

1 ...

Just to add on michal's answer. Few months ago Itzik Ben Gun published 2 articles in SQL Server Magazine about derived tables, CTE, table varibels and temporary tables. ...

GilaMonster (10/20/2008)

---

Adi Cohn (10/20/2008)

---

From your attachment it looks as if there was another full backup that was done between the full backup that you did and the first...

oliver.morris (10/20/2008)

---

Gail,

Thanks again.

No I made sure that I did not miss any logs since the full backup. I understand the the veritas backup does do a database backup as well...

oliver.morris (10/20/2008)

---

Adi,

Thanks for your reply. Over the weekend I tried to restore the database, I wanted to restore it to say a couple of hours earlier so I clicked the...

Check if the connection attempt made it to the SQL Server or not. You can use profiler to catch failed logins. If there isn’t any failed login when...

oliver.morris (10/20/2008)

---

Good Morning,

Many Thanks for your help in advance for this. I set up a maintenance plan last week and because its a active database used by about 20 people...

Sirish (10/17/2008)

---

Create Table #employee

(

Empid int,

Employee varchar(20)

)

Create Table #employee1

(

Empid int,

Employee varchar(20)

)

Insert into #Employee values('1','Sirish')

Insert into #Employee values('2','Sateesh')

Declare @Strquery varchar(100)

SET @StrQuery='Select Empid,Employee from #Employee'

EXEC('INSERT INTO #employee1 (Empid,Employee) SELECT ''+@Strquery+''')

Select * from #Employee1

Getting...

No you...