Search results for query: *

Hi, Everytime we do changes to the settings on the 2d map against an NES Agent and do a file save preferances afterwards, the next time time the machine is rebooted all of our changes have been lost. Please could someone tell me what we are doing wrong. Thanks.

I know that this is a daft request, its just that I can't for the live of me remember how to view the last sql statement a user performed using t'sql. Could anyone please put me out of my missery.

I have a spreadsheet sent to me from an outside company. They have put all of the addressess into one field that they wish us to use. Now for us to do the required work I need to split out the address field. into Addr1, Addr2, Addr3, Addr4, Zip code, Country. This is how they have it but all in...

Hi, I'm a complete novice when its comes to VPN, and I need some advice. We have a client that has given us VPN access into their site between 0900hrs and 1730hrs. We are in the process of setting up SQL Replication between the 2sites and as we loose connection each night I was wondering if I...

I'm trying to use replication across the VPN to another companies SQL Server 7 machine. I'm running SQL Server 2000 and wish to do a pull snapshot subscription from them. The Replication is all set-up, just one thing seems to be standing in our way. The agent on our machine has been unable to...

SQL Server 2000 Std. W2K OS Something strange happens to our system after a reboot with the quoted identifiers. All the on the server databases do not have the quoted identfiers checked, within the Stored Procedures we set the quoted Identifiers ON when required. Now after a reboot it appears...

Hi, Is there anyway in SQL Server that you can see when a stored procedure was modified. I have a stored procedure that was working and now will not just not work. Thought is might have been a quoted idenitifer problem but the system has not been restarted,

I have 3 databases on the same server, country specific databases. I have the same stored procedure to run for each database. This does a BCP export out to a text file onto another W2K box. 1 database exports all the details no problem. The other 2 databases manage only to create the txt file...

Hi I'm trying to set-up a stored procedure that will run through a number of tables and export the data into a text file on the server. I believe that the easiest way for this is to use bcp. But have hit on a problem with my stored procedure and wondered if anyone can see the answer. Thanks...

Running SQL Server 2000 with SP3 The Debug runs code immediately. Running SQL Server 2000 which appears to have no SP applied Debug runs as you would expect, allowing stepping etc Is the SP3 a red herring, is there a global setting to dictate the behaviour of debug. I would be most grateful...

I need to send an email from a select within a stored procedure and that the attachement is appended to the mail. I also need a copy of the file to be placed into a text file on the system. I can send the result when setting the @attach_result=True in xp_sendmail I can also copy the result to...

Rather than putting SQL Query Analyzer on my bosses machine just cause he wants access, I was thinking about using the microsoft query that was on NT does anyone know if a copy of this is available for windows 2000 or does anyone have any better idea's. Thanks Clive

Hello I need to do a form / report in fox and would like to parse the stored procedure that I have created but need help in doing this. (Not a true fox user yet) I know I can use the sql statement but would like if posible to use the stored procedure Thanks Clive

Hello I need to do a form / report in fox and would like to parse the stored procedure that I have created but need help in doing this. (Not a true fox user yet) I know I can use the sql statement but would like if posible to use the stored procedure Thanks Clive

Posted on behalf of the programmer Stupid but Annoying I'm a fox developer and have been tasked to use SQL Server 2000. In fox you can assign a variable with '2+3' then run this, for example jnk = '3+2' ? EVALUATE(jnk) which results in 5. I want to do the same in SQL, but can't. I have...

I'm trying to set a relationship up between 3 tables. The parent table (table1) A child table(2) and (table3) The relationship between table1 and table2 links okay with the insert and delete and cascading in the update and delete. The when I try to link table2 to table3 I get the following...

How can I stop other developers / DEPTS from accessing specific stored procedures and possibly changing them Ie. Ones that they have no involvement in. I would like to assign the access rights for their databases only.

Hi, I'm trying to import a Foxpro database into SQL2K, I have come across a problem trying to import 1 table. It has 15 fields and fails to import anything more than 790 rows at a time. The error message is dbdatetime overflow error. I have 325000 rows to import and don't want to do them in...