A trigger is a special kind of stored procedure that automatically executes when an event occurs in the...

devammehta (12/3/2008)

---

Hello,

I am using the Web App to show my report which sucks in one param i.e. "ContactId".

The param data type is Integer.

But when I run the Web App...

Roust_m (12/3/2008)

---

Hi,

We are having multiple people and multiple opinions, so the situation is that we may have two DDL database triggers logging schema changes to two different tables. Can...

may be it is due to that you dont have permissions to create the table or...

thusi (12/3/2008)

---

Hi All

I'm going to have multiple databases with the same table structure. I want to create a set of 'global' SPs/UDFs in SQL Server where I can simply pass...

Sanaullah (12/2/2008)

---

Hi all,

When i am openning my table in design view in enterprise Manager i am getting this error.

Table could not be loaded ODBC Error[Microsoft][ODBC SQL SERVER][DBNetLIB] connection read(rec()).

[Microsoft][ODBC...

lav (12/3/2008)

---

Suppose I Want Maintain All Trans. Information In My DataBase .For Eg. A User Insert a Record In a Table I Want To Store Which user insert a...

Breach of security is mandatory as only this lead to the improvement in the security practices.

im my organization at the time of auditing, i create a backup of the database upto the required date...

bhushanhegde (12/3/2008)

---

Hi,

I want check a perticular table is blank or having any rows? is it possible with using exist keyword? itried with isnull. but it is not working.

select isnull(empid,0) from...

rajesh_281984 is a lucky guy, as gets lots of updates regarding his problem.

rajesh_281984 (12/2/2008)

---

I am trying to write a stored procedure to insert values into a table which is already created.

my code is

Create procedure name

@value varchar(50),

@value2 varchar(150)

as

begin

declare @myValue int

Select @myValue...

fausto usme (12/2/2008)

---

Hello People,

i need to do the next.

I have with follow data:

Table: Rooms

IdRoom

101

102

103

104

201

202

203

301

302

303

304

401

402

403

and it will be so:

101 102 103 104

201 202 203

301 302...

welcome

Mohammed Imran Ali (12/2/2008)

---

Hi,

I am getting the following error while accessing data from SQL Server 2000 from SQL Server 2005.

OLE DB provider "SQLNCLI" for linked server "hqserver" returned message...