Hi All, Can someone please help me to get tutorials on DB2 Universal Database for OS/390 Version 5 please. to get something on above would be a great help. ...
5423
Veer Ji Wangoo
vwangoo
Jul 2, 2007 4:44 pm
FROM THE DESK OF VINOD KUMAR::: As usual, my customary links to interesting tit-bits. Recently, the SQL Server 2005 Best Practices site was updated with some...
5424
sqlcon@yahoogroups.com
Jul 2, 2007 5:53 pm
Enter your vote today! A new poll has been created for the sqlcon group: Are you ready to deploy Windows Server 2008 (Longhorn) & SQL Server 2008 (Katmai)...
5425
smart chip
knowledge_chip
Jul 2, 2007 6:34 pm
Good Collection. Thanks. Veer Ji Wangoo <veerw@...> wrote: FROM THE DESK OF VINOD KUMAR::: As usual, my customary links to interesting tit-bits. Recently,...
5426
JeeLani bASHa
basha_21_99
Jul 2, 2007 6:46 pm
Hi folks, Its been a long time used the group. now im in a requirement for installing sqlserver and sp3a automatically anybody have any procedure to do this....
5427
Veer Ji Wangoo
vwangoo
Jul 2, 2007 7:52 pm
It is documented in Books in Online "Performing an Unattended Installation" .. very easy methodology... Just when you are installing.. there are simple steps...
5428
Vinay C Reddy
beeravolu
Jul 2, 2007 10:01 pm
Hi, I have around 250 tables in the Primary File Group, the disk space is full. I have 40 more tables in a Secondary file Group. I want to change some large...
5429
Madhu K Nair
madhuotp
Jul 3, 2007 2:07 am
if you want to transfer tables from one filegroup to another without droping and recreating, the only option is to drop the existing clustered Index and...
5430
Shyam Sunder
shyam_k25
Jul 3, 2007 2:34 am
Hi, here one more option is there. copy the entire table with different name to other group. and drop the original table and rename the created table and check...
5431
vijayasekar shanmugha...
vjsekars
Jul 3, 2007 1:46 pm
Hi,
I had copied the below given script on automatic installation long back
some website but not tested it.
thanks
vijayasekar
On 7/3/07, JeeLani bASHa...
5432
jeelani basha
basha_21_99
Jul 3, 2007 2:38 pm
Hi, I have gone thru the BOL and found out the steps, i tried to do the same with the sqlserver image wich i have in my share folder but the advanced option...
5433
mohd rizwan
mo2riz
Jul 3, 2007 3:31 pm
One more option to change the filegroup of a table. EM -> Database -> table -> right click on the table and click 'Design Table' -> click on 'Table and Index...
5434
Vinay C Reddy
beeravolu
Jul 3, 2007 6:54 pm
Hi Rizwan, I think this is an option for SQL 2000 and not for SQL 2005. Correct me if im wrong. Regards Vinay C Reddy ... -- Vinay C Reddy [Non-text portions...
5435
Veer Ji Wangoo
vwangoo
Jul 3, 2007 8:02 pm
No it is still there in SQL 2000 From: sqlcon@yahoogroups.com [mailto:sqlcon@yahoogroups.com] On Behalf Of Vinay C Reddy Sent: Tuesday, July 03, 2007 2:54 PM ...
5436
Santhosh
san_spy
Jul 3, 2007 8:23 pm
Vinay, you are right, we dont have that option in SQL 2005. In 2005 we have to move the clustered index by dropping it and recreating it to a different file...
5437
Madhu K Nair
madhuotp
Jul 4, 2007 4:00 am
Basically, internally EM do the same thing what i mentioned. It drop and recreate the clustered index to the new filegroup. Madhu ... click 'Design Table' ->...
5438
mohd rizwan
mo2riz
Jul 4, 2007 10:48 am
Dear Santosh and Vinay, This option is still available with SQL2005. Instead of 'Table and Index Properties' now the button name is 'Properties window' thru...
5439
Basavaraj mailar
bmailar_engg
Jul 6, 2007 1:09 pm
Dear Friends, Thanks for you guys support, i had solved any issues with u guys help. i need it again.. Actually i am setting cleint for one of our softwares. I...
5440
Sunil Kak
buntykak
Jul 6, 2007 1:13 pm
Have you installed sql client network utility on the client ? ________________________________ From: sqlcon@yahoogroups.com [mailto:sqlcon@yahoogroups.com] On...
5441
Basavaraj mailar
bmailar_engg
Jul 6, 2007 1:28 pm
no we install on the prowatch client utiltiy.... no network utility..... i works ... but donno first time we gettign this error... with regards, basavaraj ......
5442
koushik roy
koushikroy_2001
Jul 6, 2007 4:29 pm
Hi Team, We are planning to upgrade some of our SQL Server 2000 Service pack 3(SP3) to SP4. Presently we are using Microsoft SQL Server 2000 Data Store...
5443
Veer Ji Wangoo
vwangoo
Jul 6, 2007 5:08 pm
Actually most of the issues before and after SP4 are related to Merge replication but in transaction replication I did hear some issues on Log reader but not...
5444
harsh kumar
harshism
Jul 7, 2007 5:13 am
Dear All, How to update this table as 1 to 0 and 0 to 1 in single query statement without using any temp table or cursor. Table structure like this Table col1 ...
5445
Prakash SSM
talk2prakashuk
Jul 7, 2007 8:49 am
Hi Harsh, Try this update tab1 set col1=case when col1 = 1 then 0 else 1 end Hope this helps. cheers Prakash ... ...
5446
Basavaraj mailar
bmailar_engg
Jul 8, 2007 1:09 am
please still waiting for reply... client machine we load only our client applicaiton application. no sql client utility... ... From: "Basavaraj mailar" To:...
5447
Veer Ji Wangoo
vwangoo
Jul 8, 2007 2:15 am
There can be two issues 1. Either the username / pwd or NT login doesn't have access to SQL Database 2. Or it can be very much possible that...
5448
aneesh
aneeshattingal
Jul 8, 2007 11:01 am
Here is another methos if it is a bit column DECLARE @ta TABLE (i bit ) INSERT INTO @ta SELECT 0 UNION ALL SELECT 1 SELECT * FROM @Ta UPDATE @ta SET i = ~i ...
5449
sree
vemuri_sree
Jul 10, 2007 3:43 am
Hi Team, please help me in this. when I open SSRS datasource , it is throwing error "Could not find file 'C:\WINDOWS\TEMP\8jocwobp.dll'. " , its changing the...
5450
vemuri sreenivas
vemuri_sree
Jul 10, 2007 3:50 am
Hi Team, please help me in this. when I open SSRS datasource , it is throwing error "Could not find file 'C:\WINDOWS\TEMP\8jocwobp.dll'. " , its changing the...
5451
sree
vemuri_sree
Jul 10, 2007 4:19 am
Now i am getting below error when i edit any of the report or DATA source. " System.IO.FileNotFoundException: Could not find file...
