Sorry I written the question wrongly in sql 200 identity columnds not apdatable?. I mean by this is not updatable. any one succeded by doing this? I think the...
Is it possible to enable identity property of a column (Integer data) in a table with some amount of data, using SQL Scripts ? We cannot do this by script but...
Babu, Let me correct myself. You cannot UPDATE the value of an IDENTITY column even with the IDENTITY_INSERT Setting ON. So what you have to do is 1. Copy all...
Hi, In My DataBase ,some queries are taking so much time to give the result. I need to kill the long running queries by user.I have thought wt ever we...
Hi Spy, I know all these, but why i am confused is, in the original answer Roji suggested to add a new identity column to the existing and copy the data to the...
Thanks Roji, sorry i have made so much noice here with typos. I am not good typist. It is also in (My) wish list for 2005. Because we face some problems with...
Try this one SP_who2 or You can view your SPid just about the status bar in QA. Try using NOlock option this will improve the query's performance. Select *...
Hi All, We have ASP.net 2.0/LLBL Pro Gen application which is hitting a SQL 2005 Standard Edition(SP 2) Database on Windows 2003 SP 1 . While searching a...
Hi All, While Defining Procedure,Function & Trigger either possible to use Is or As ...Can anyone help me out what's diffence between this For example Create...
Nope. "Create procedure pn Is" is not valid syntax. Regards Roji. P. Thomas http://toponewithties.blogspot.com ... From: nic_santosh To: sqlcon@yahoogroups.com...
Santhosh, I dont know much about ORACLE, but as I understand it, AS and IS is interchangable. But speaking about SQL Server and ORACLE, I have link to share ;)...
Ok, one more pointer on this which I think could be useful. when you get the actual SPID, you can execute dbcc inputbuffer(SPID) to check what the SPID is...
Hi I have a table which gets inserted with the error log. I want to shoot a email when anything get inserted in that table to a specifice person with that...
Hi, Install a extended procedure from attached file. Just find last inserted information from inserted table by using Trigger(for Inserted) and pass this as ...
Can anyone tell me what i m missing? /* The purpose of this article is to demonstrate how to use a simple trigger to send an email. This is a simplified...
Have you gone through the attached file...? You will add attached extended procedure and this procedure does not need to configure SQL Mail... you will this...
Hi All, I'm facing a problem while designing a reporting system. Here is my case: I have have 2 databases MartA & MartB, both have same structure & either one...
Hi, Could you post the full physical architecture (a) All these three Database are on Single Instance/Single Server ? (b) If not, are they member of same...
When i migrated my databases from 2000 to 2005, some of my jobs failed with below error- ... Msg 7339, Level 16, State 1, Line 1 OLE DB provider 'SQLNCLI' for...
Ex : /* CREATE TABLE Hierarchical (Child int , parent INT, Status INT ) -- SELECT * FROM Hierarchical INSERT INTO Hierarchical VALUES (1,0,3) GO INSERT INTO...
Hi all, Can anybody explain to me the causes of log file growing so large within a short period? We are in the development stage of ab application so all we...
Hi, There is nothing to worry. It is how SQL Server functions. SQL Server follow the Write Ahead architecture. Ie. Whatever the transaction is occurring in the...
hi how you are doing migration whether transfering all tables from sql 2000 to sql 2k5 or how. regards kumanan mohd rizwan <mo2riz@...> wrote: When i...
Is this 'COMPASSSERVER' sql 2005 ? ... '[COMPASSSERVER].[compass].[dbo].[Table_Currency].symbol'. ... Aneesh R. SQL Server MVP, Expert Exchange.com Genius SQL...
Hi, There are few possibilities it is very clear that you have a linked server configured and it is not been able to connect to COMPASSSERVER. so first check...
Hi Madhu, Thanks a bunch for your response. Yes, All 3 databases are in single instance of a server. Here are the details you needed about the architecture. We...
Hi Senthil, Existing Data Enviornment Server Name OS / SQL/Drive Spec DatabaseName Database Size Server A Win 2003/SQL2005 MartA ?? MartB ?? StagingDB ?? ...
Hi all, We are planning for a SQL Cluster Active/Passive installation with 2 nodes on a new Server. Please guide me with per installation checklist and...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
