Hi all.. i m having a problem in understanding select query select em,empname from empdetails into #TempTB where 1>2 i'm unable to understand the condition in...
Hi Santhosh, In this case I think PSSDIAG tool might help you. This tool is similar to profiler but a backgound process. Go through the following link for more...
Thanks Kishore.. in that stored procedure they are creating that temporary table and after complition of all operation they are droping that table... but that...
Hi Prashath, A small mistake in the query:It should be like this SELECT em, empname INTO #TempTable FROM empdetails WHERE 1>2 (case is not the emphsis.. INTO...
Hi Virendra, please go through the link below that will give the answers to almost all your questions. http://support.microsoft.com/kb/314515/EN-US/ Dear Veer,...
Hi All, Our application was running with SQL Server 2000 for a long time where we used IDENT_CURRENT(Tablename) in one of the stored procedures to capture the...
Hi Prashanth The query select em,empname from empdetails into #TempTB creates a temporary table #tempTB with 2 columns em and empname. If u require the temp...
select A.fktable,a.pktable,a.fkcol,a.name from (select a.*,b.name from (select object_name(fkeyid) as FkTable ,object_name(rkeyid) as PkTable,b.name as fkCol...
Hi anybody has worked in SQL Server 2005 reporting services. Basically from the reportserver link i am not able to upload a file. Can anybody tell me what may...
Hi All! what is the collation for Unicode datatypes like (nvarchar,ntext). can you write a create table statement and send it across. Thanks Shyam Koti...
Hi, try to upload using the reporting services development studio. See that you are the part of the site administrator or content manager group. with smiles ...
Hi,
Mindblowing expertise in MS Word.... Just goes on to show what wonders u can do with MS word. MUSIC IN MS WORD!! No Need of Speakers, No need of Sound...
Hi, Im trying to configure the distributers/publishers/subscribers. When I try to add a distributor in the publisher its giving the below error. <servername>...
1. Goto Server Properties and select the Replication Tab. 2. Click on Configure 3. Drive thru the wizard and configure the server as a distributor. Follow thw...
Navaneeth, I am able to configure the distributor but my problem is like I have around 50 servers registered in my EM but the I dont see any of those servers...
Mr Chandra, Before giving expert advice, it is better that you test the crap you post. ... Will throw an error. SQL Pundit Of all the pleasures in life, I like...
Hi, I have a doubt in creating the foreign key constraints. Can I create a relation like, many-parents-one-child ? I mean there are 3 PK tables, related to...
Virendar, You have to create UDF that concantenates the Country for each given Id. Note that for Concantenation you dont have to use a CURSOR. Here is a sample...
Hi Babu, You can always create a table with foreign keys something like this create table tbl( col1 int , constraint fk_t3_1 foreign key (col1) references...
Babu, It is NOT possible to implement a DIRECT multiple parents foreign key relation. AFAIK, there are three alternatives. 1. Create the Parent columns and...
HI Babu, For this design, I would like to introduce a master table which will have the primary key. The three tables (Many-parents) you are thinking of may...
Hi Guys, Hope many of you might have read many books on SQL 2005. Can you please suggest me some good book in a DBA prespective. with smiles santhosh ...
Hi All, Thanks for your feed-back. I'm planning to go ahead with implementing triggers on child tables. Since the wirte operation is less and the read will be...
Mei, What is the point in having a foreign key to two diffent tables, when both the tables needs to have the same data? Regards Roji. P. Thomas ... From:...
