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. ...
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...
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)...
sqlcon@yahoogroups.com
Jul 2, 2007 5:53 pm
5425
Good Collection. Thanks. Veer Ji Wangoo <veerw@...> wrote: FROM THE DESK OF VINOD KUMAR::: As usual, my customary links to interesting tit-bits. Recently,...
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....
It is documented in Books in Online "Performing an Unattended Installation" .. very easy methodology... Just when you are installing.. there are simple steps...
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...
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...
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...
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...
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...
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...
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...
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 ...
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...
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' ->...
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...
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...
Have you installed sql client network utility on the client ? ________________________________ From: sqlcon@yahoogroups.com [mailto:sqlcon@yahoogroups.com] On...
no we install on the prowatch client utiltiy.... no network utility..... i works ... but donno first time we gettign this error... with regards, basavaraj ......
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...
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...
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 ...
please still waiting for reply... client machine we load only our client applicaiton application. no sql client utility... ... From: "Basavaraj mailar" To:...
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 ...
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...
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...
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.
