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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. roswald

    CONVERTING VB TABLE TO SQL TABLE

    Yes I was referring to vb.net in this instance. I found out what I needed to know, thanks all. Hey rickyoswaldiow, I see we share the same last name. I have a brother named Rick. small world. bob
  2. roswald

    CONVERTING VB TABLE TO SQL TABLE

    Can anyone tell me how I can take a DataSet in vb and create an sql table out of the results? thnaks, bob
  3. roswald

    combine recs by date

    Hey Vongrut, That is the exact code I was looking for. I knew it could be done directly in sql but just didn't have the expertise to make it work. Abaldwin, take a look at his post because that is the solution right there. Thanks to all of you for helping out! bob
  4. roswald

    combine recs by date

    Nope! What you see here is all I have to work with. bob
  5. roswald

    combine recs by date

    Alex, But I will also have recs that aren't in order with no breaks in coverage like this... ID Start End 1 1/1/2006 2/10/2006 1 2/11/2006 3/12/2006 1 4/1/2006 5/15/2006 This should be made into 2 records, so I need something different than what you sent me to...
  6. roswald

    combine recs by date

    I have a table that will have a start date, end date, and a third field called ID. If when going through this table that is indexed by ID, start Date, I want to take all the fields that have no breaks in the date fields to be combined into 1 record where possible. For example, I have 3...
  7. roswald

    Connection failure error on sqloledb

    Line 60 is the select statement that was processing when the connection was broken. It is almost as if there is some type of threshold being met that is causing the connection to be broken, like a timeout or something, because this only happens with very long running queries, but if I run that...
  8. roswald

    Connection failure error on sqloledb

    We are on Windows Server 2003 with SQL Server 2000 Database and when running a bat file using ISQLW (which is the same as running Query Analyser) I will sometimes get the following error after being connected for a few hours already, for some reason the connection gets broken and this error is...
  9. roswald

    Can't Restrict DB w/Citrix connections

    I am trying to run the following command... Alter Database MYDB Set Restricted_User With Rollback Immediate When I run this command it works great except for the users that connect to that SQL Server 2000 server via a CITRIX connection. I can kill thier spid also and I believe the Citrix server...
  10. roswald

    Adding a DateEnd column on a table

    I have a table that contains a BeginDate field along with a Plan_id field that we will use to sort recs. What I want to do is add a EndDate column to this table or create a new table with Plan_id, BeginDate and the new EndDate column. The current table will be sorted by Plan_id and BeginDate...
  11. roswald

    Restricted DB access doesn't work with NT authentication?

    Touche Bill, I didn't think of that one. Thank you, b
  12. roswald

    Restricted DB access doesn't work with NT authentication?

    When I run this command to prevent users that have read only type permission.. ALTER DATABASE Roster SET RESTRICTED_USER WITH ROLLBACK IMMEDIATE Any login I create with SQL Server authentication is prevented for accessing the database but, if the user login is created using Windows NT...
  13. roswald

    Preventing object locks - HELP!

    All our SQL Server 2000 users are in a Read-Only group named Readers. Is there a command that will prevent any user in that group (Readers), from being granted any Lock on any Object between 3pm and 4pm? I need to accomplish the following; 1. Any users that are active when my script is...
  14. roswald

    Any alternaitves to Net Send?

    Thank you mrdenny for the History lesson. Your help was invaluable. b
  15. roswald

    Any alternaitves to Net Send?

    mrdenny, We sure do have a firewall to go through. Thank you. All I read is not to start messenger is pc is used to get on internet. No explanation though. Can you tell me how turning the messenger on would be a potential security risk without the firewall? b
  16. roswald

    Any alternaitves to Net Send?

    Hi All, I have a script that will log off any active users on SQL Server 2000 that happen to be using a particular database between 5 and 6 pm. I was going to use xp_cmdshell to launch an informational message that will pop up on their screens letting the users know that they will be logged off...
  17. roswald

    Syntax for OSQL cmd in QA

    Can someone tell me how to get the syntax right for the following cmd in Query Analyzer... set @cmd = 'OSQL -Uusername -Pmypwd -Q"select * from table"' I have tried many combinations without any luck using single quotes so that it will work in a SP.
  18. roswald

    Program to exclusively lock tables?

    We have a program that runs at 5pm each night for around 15 minutes. Sometimes if users are on the system and accessing any of the three tables that the 5 pm program updates, the updates will fail. Lets say the program updates tableA, B, and C. Is there a way to write a script that says get...
  19. roswald

    locking problems with read only users

    NoCoolHandle and SQL Sister, Thank you both for this invaluable information. My dilemma is that we have an application for which we don't own the source code, otherwise I would lock these tables exclusively for the 20 minutes that the code runs and release them when finished. There are only 3...
  20. roswald

    locking problems with read only users

    We give our users read only access to the reporting repository on SQL Server 2000. Can you tell me how a user with this type of access could ever get any type of lock on a table, page or database? Also, if a read only user is in a table will it prevent a program that has write privleges from...

Part and Inventory Search

Back
Top