Search results for query: *

I have recently been asked to amend the server IP address of an access .ade file as the Source Sql database was being moved. As the source code (.adp) file has been lost, I opened the .adp file and changed the connection. I know this worked as I then could see all the tables from the Sql DB. the...

Yes, I think it is best, really doing my head in and about to go live with it. Can see that instead of scheduling it in a job I am going to have to be the human scheduler and run the store proc manually every day ! It's kind of big though... SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO...

Yes, basically Sql server ignores the transaction name on the commit statement,merely decrementing the Trancount by 1. In my case as I only have one Begin tran it will decrease the trancount to 0 and then commit (or not as it is my case !) I must be missing something for sure but not in this...

Although I don't normally work with case sensitive collations, to me what yor DBAs told you makes perfect sense. If the database you are talking about was created with a case-sensitive collation ,the schema itself as it is also stored in database tables (system tables)as data ,will also be...

...and I think you may have missed mine. In the real code I have given it a proper name and used it always, both on Begin, Commit & Rollback. Forget that I put Tran A in my example. Apologies if it was misleading .

I have actually name all the transactions commands but it is irrelevant as you don't need to use the name at all and I only use it for code readibility. The code will only go to the Err section when @rc <> 0 therefore I know I want to rollback and that is why I do not use an If statement.

Sql Server 2000 and Transactions - Must be male as it won't commit. I have been using Sql Server for God knows how long and have this problem with transactions which has got me miffed ! Nothing extradordinary in my Sql. I have a SP which contains various Insert & Update commands within a...

Excellent. Didn't know that. You have to be a member of the Sysadmin or DBCreator groups but that's ok. Does it rename the data & log files as well ? I don't suppose it does...

I am trying to return the results of a query in Sql Server (to an asp.net front end but this is irrelevant) in page sets depending on a requested Page No. & Page size to reduce the network traffic. I have tried two different solutions, one using a set of nested queries using the TOP clause...

You cannot rename the Db as you rename other Databse Objects but all you need is to back it up and restore it under the new name which is quite simple.

Oh ok. I don't really think you want to use Global variables . What you want is the Dynamic properties task which allows you to set any task properties, such as the connection text file data source value to an entry on a ini file, Global variable (no point) and various other options. Drag...

Well, I don't think you can multi-select like you can with tables but you can copy and paste the source connection. in this case being the text file. So basically you would have to : Create the Source Connection of text file type Create the Destination connection as Microsoft OLE DB...

Excellent ! Providing it works that's great as any user allowed to log into this Server is allowed to access all the registered Sql servers anyway. You know, I didn't want to be ungrateful so I said nothing to the previous reply but I had seen it happen before so I thought it should be...

I have registered two SQl Servers on a server running windows server 2003 and expected all the users members of "Power Users" to be able to see those registrations when logging in under their usernames which is not the case. All they can see is the native Sql Server. Are Sql Server...

I was replacing some Stored Procedure code which acesses the System tables to get the same data from the Information Schema tables instead so as to avoid having to change them if the system tables change from version to version. However I wasn't able to find a way of getting the index names...

I am trying to use my machine as a webserver and was expecting the default file path: c:\inetpub\wwwroot ,. to be mapped to the URL http://localhost/ . Somehow this is not happening and when I type http://localhost , I get an html page pertaining to Oracle. How do I re-map localhost to the...

Thanks very much to "foolio12" for the tips. The first link was all I needed. Once I get the list of APIS it was easy.

As part of a conversion from Access 2 to Access 2000 I had to change references to DLL functions, mainly user.dll & kernel.dll by suffixing those function names with "32" and replacing both the dlls with the equivalent 32 bit ones, i.e. "user32.dll" & "kernel32.dll" . However I am still...

Thanks to both BillyRayPreachersSon and ggriffit ...and I thought my pseudonym was bad ! Just for the record, the Lotus Notes setting was already defaulted so that was not enough in itself. I managed, through the Services tab in Outlook to add a Lotus Notes directory and default the address...

Another question for BillyRayPreachersSon. ..sorry to be such an ignoramus but how do you register Lotus Notes as the mail client and would this then mean that all my customers would have to do that in their machine ?!