Search results for query: *

Hi! Can anybody help me in prividing the links for MDX Tutorial. I am very new to it. Thankx in advance. TapKs

Hi! I want to use the Users & Groups of Active Directory of Win 2K in MS-Analysis Server. But in Database Role Manager Window of MS-Analysis Manager I can only acces the Users not the Groups. But I want to use the Groups of Active Directory as Roles in Database Role Manager Window of...

Hi! I am getting an XML output in Query Analyzer which is more that 8000 character, hence unable to see the whole output. CAn I save the output to a text file so that I can see the output ot is there any way I can see the total output in query analyzer. Can anybody help me.. Thanks in...

Whatever U have mentioned, I have tried all in the above. But the error persists. Any other solutions ? Tapks

Hi! while inserting image type data to a table, I am getting the following error : 'Server: Msg 7133, Level 16, State 2, Line 6 NULL textptr (text, ntext, or image pointer) passed to WriteText function.' My table Test is having the colums id int, img image I am executing the following...

Why the output of the following calculation is shown as 0 in query analyser, where as the output should be 0.207 (approx)? select 61*4*31/36500 Can anybody help me out? Thankx in advance

Does Oracle 10g supports Windows NT or Windows 2000? Pl let me know. ANy links are available on it? Thanks in advance. tapks

Hi! It is not possible to define DECLARE @myVar TEXT inside a procedure. Any other way.

Dear friends! I am facing a problem while I am trying to read an xml string inside a stored procedure. The length of the xml string is more than 15000 characters. Is there any way I can declare a variable in my stored procedure so that I can use that XML string to read. Please help me in this...

Following is the way to reset the identity seed after deleting all the records. DBCC CHECKIDENT ('table name', RESEED, starting value-1)

Hi! I have created the linkd Server for Server2. I can able to make a SELECT query on the required table & also able to INSERT data into that table. But unable to DELETE or UPDATE the table. It is throwing the following error while executing the DELETE statement : Server: Msg 7306, Level 16...

Thats ok. I want to know that whether it is bug of MS SQL server or not. Did Anybody face this before ? Pl let me know.

HI! In SQL Server 7.0 I can create a table with wrong syntax i.e. create table Test (id int, descr varchar(10),) Can anybody tells me whether this whether it is a feature in SQL Server or so. Pl help. Tap_Ks

Thanks a lot ClaireHsu. The problem was with the @dataSrc. After changing the same it is working fine. Thanks once again. TapKs

I am wkoing in a Server from which I have to access the other Server also. Both the SQL server are of version 7.0. I can able to access the Server2 data from Server1 through Enterprise Manager. But throught a Select statement how can I access the the data of the Server2? I hve added the...

HI! The SQL statement which you have written will display as follows: If for a date you have got transactions with TransSts 'C' and 'D' then it will display 2 rows for that date i.e. one row for the TranSts "c' & one row for TranSts 'D'. So this is not solving the problem. However...

HI! I have one table called TRAN_DET with the following columns : TranDate Date Not Null, TranDesc varchar(50) Not Null, TranVal decimal(10,2) Not Null, TranSts char(1) Not Null The TranSts column stotes either 'C' or 'D'. I am unable to find the summary of the transaction for each date...

Thanks for the vsluable answers. But can any body tells me what are the advantages of Oracle 91 over SQL Server 2000 ? Thanks in advance. TapKs

Can any once let me know the difference in the features between SQL Server 2000 & Oracle 9i ? Thankx in advance. TapKs

Hi Nathan! I have checked that it is inserting the record by generating the identity key. But after that when I use the @@identity function to know the identity value it is returning nothing. The same code was working fine for sometime. But I was facing the problem 3 /4 days back. I am also...