Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
list your database table indexs.
select so.name as TableName, sind.name as PKName, case when (sind.status & 0x800) = 0x800 then 'PK' else 'IX' end as IndexType, sik.keyno, col.name as ColName , case when sind.indid = 1 then 'Yes' else '' end as 'Clustered Indexes' from sysobjects so inner join sysindexes sind on...- mickyang
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
-
When I use Crystal Report 9 , how to assign server name in RAS.
When I use Crystal Report 9 , how to assign SQL server name and Database name and User ID and user password in RAS. i can use Session("oClientDoc").DatabaseController.Logon "sa", "password" assign userid and password , but how to assign SQL server name and...- mickyang
- Thread
- Replies: 0
- Forum: Business Objects: Crystal Reports 2 Data Access
-
RetrieveStoredProcParams & Not enough memory for operation ?
My Visual Basic code: '======================================================== Set Crystalreport = CreateObject("Crystal.CrystalReport") Crystalreport.ReportFileName = "C:\182.RPT" MsgBox Crystalreport.RetrieveStoredProcParams...- mickyang
- Thread
- Replies: 0
- Forum: Business Objects: Crystal Reports 4 Other topics
-
How to export to DHTML ,when i use crystl32.ocx(8.0)?
How to export to DHTML ,when i use crystl32.ocx(8.0) ? my VB code : Crystalreport.PrintFileName = RepOutFileName CrystalReport.PrintFileType = crptHTML30 Crystalreport.Destination = 2 crystl32.ocx can export DHTML(HTML4.0) ?- mickyang
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 4 Other topics
