hi Andy

i have procedure in sql server s follows

ALTER proc testing

as

begin

--select 'testing'

delete from obj

INSERT INTO Obj(objName,blnisvalid)

SELECT NAME,dbo.fn_IsValidObjectName(NAME) FROM sysobjects

WHERE XTYPE='V'

SELECT objName FROM Obj

WHERE blnisvalid = 1

ORDER BY objName...

Thanks

IS_SRVROLEMEMBER function is working

thanks once again

EXAMPLE IS QUESTION WAS POSTED!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!:D

SEE I HAVE EMS_SOURCE DATABASE AND EMS_DESTINATION DATABASE I AM COPYING SOME RECORDS FROM EMS_SOURCE DATABASE TO EMS_DESTINATION DATABASE WITH SOME MORE JOINTS. MY PROBLEM IS THE SOURCE AND DESTINATION...

Matija Lah (5/22/2008)

---

That's simply...

In update statement derived table is not allowed, alternate you can use temp table to store derived table record and then you join the temp table

bye

premnathk.chn (5/15/2008)

---

Hi ,

I thought of dropping and adding primary keys but the problem is that the script turns out to be more complex since there are certain tables...

Lata Patel (5/13/2008)

---

I have solved my error :

i have put following code before appending the parameters.

For C = 0 To cmd.Parameters.Count - 1

...

yes you are right, drop the constraint and after updation ADD the constraint

cheers

Obiviously CASE statments in WHERE clause will improve performance issues. i think you can use temp table to extract records for the CASE conditional records and finally JOIN THE TABLES...

Hi Gila,

I don't understand, Are you spend all of your day in...

Hi Premnath

i think you no need to enable and disable the indentity . and not need to call any function for auto numbering . please see the following code, i...

Hi Premnath

i think you no need to enable and disable the indentity . and not need to call any function for auto numbering . please see the following code, i...

jonp (5/5/2008)

---

Hi,

I'm running SQL Server 2000 and PHP.

I believe the problem I have is SQL Server based and not the PHP, but I have no idea where to look.

If I...

Torsten Schüßler (5/9/2008)

---

Hi shamshudheen,

did you mean something like this:

EXEC sp_MSforeachdb @command1="print '?' DBCC CHECKDB ('?')"

sp_MSforeachdb is an undocumented stored proc., will put each database and accomplish DBCC CHECKDB for each...