Search results for query: *

I've been asked to create a database where a stipluation is that a table entry can have 0,1,2,3 documents associated with it - these documents are unique to each entry - I modelled it but I wondered what designs others have used / would use in this instance. Any advice much appreciated

I've inherited a DTS package that populates a table with close to 1 million rows. The table has a clustered index and several non-clustered indexes. The DTS package issues a truncate table comand and then data is copied into the table with a SELECT. Should I then re-index or as the data is...

Thanks for the reply - I found a solution: I had to change the NLS_LANG registry key on the database server hosting the job / DTS package. This was because part of the query ( third party code created for discoverer) used a join that checked the language setting for the session. This was an...

XML is case sensitive and I noticed AuthStatus in the XML and your XPath authstatus do not match - hope this helps

Thanks for taking the time to reply - the field that's missing is VARCHAR2 in the oracle database and I'm trying to save it as VARCHAR - the strange thing is the package runs fine on the old server - I'll try the convert. Thanks once again

I'm migrating DTS packages that copy data from Oracle to a Sql server. I've installed the Oracle 10 G client on the server and I'm using the Microsoft Ole DB for Oracle provider to connect to an oralce database - the package runs but only selects part of the data and excludes data of type...

I'm migrating DTS packages that copy data from Oracle to Sql server using the Microsoft Ole DB for Oracle provider - the package then only selects part of the data with data of type varchar2 missing - on the other server the package runs completely - has anyone else experienced this before? Any...

Thanks for replying - I managed to stumble through and get the provider up and running. The only thing I had to do was to rename a registry setting NLS_LAND - why is this? Any help appreciated

Thanks for replying - but I'm sure I need some Oracle-related software on the server - that's what the MS site says but it doesn't say what. Thanks anyway.

I want to extract data from an Oracle database using DTS / Microsoft OLE DB Provider For Oracle - what oracle related software do I need to install on the server hosting the instance of SQL Server?

Matt, Sorry to bother you, I've heard Microsoft provide a management console ( Microsoft Operations Manager 2000 / 05 ) have you any experience of this product? Cheers Mick

Matt, cheers for replying - I should have added some more detail. Need to monitor health of server CPU, memory etc. Whether scheduled tasks have completed successfully. Locks etc. Hope this helps. Mick

forgive my lack of knowledge but is there a web-based system available for monitoring SQL Server instances and the server they are installed on? If yes could you point me in the right direction

I'd either: delete the OnClick="SubmitBtn_Click" code and double-click on the button in Visula Studio to create the event handler. Or if you've created an event handler - select the button and right click to view it's properties, then in the properties window click on the icon that looks like...

Hi, a shorter way is: string addressBar = Request.Url; Cheers

Hi saw the posting and thought I'd add my twopenneth - with a problem like this wouldn't it be better to do the work on the database - with something like SQL server you could add: ISNULL( val1 , '')) to your select statement and then you do not have to apply the conditional for each line in...

I've just tried <customErrors defaultRedirect="Error.htm" mode="On" /> and it works for me - are you using "Smart Navigation" on any of your pages? If you are there is bug that stops defaultRedirect working. Hope this helps.

Hi, I noticed you have the RemoteOnly tag set in the web.config therefore if you are working locally you will always see the detailed error screen - try substituting RemoteOnly for On. I hope this helps. Mick

Hi, I may be misunderstanding your requirements but this might help to get a string representation of the contents of an xml doc. XmlDocument docXML = new XmlDataDocument(); //here you could make your xml doc docXML.Load( Server.MapPath( "MyXML.xml" ) ); XmlElement nodRoot =...

Have you tried setting the tab-order in the code-behind file in response to whatever controls are visible? It's not something I've ever tried before but should be possible. Hope this helps