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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by forecasting

  1. forecasting

    Can you change users within a stored procedure?

    the databases are on the same server and the user just doesn't have rights to the other database. Since it appears from your answers that you can't change the connection string within a stored procedure, it appears y best best is to 'grant insert permission on that table'. Thanks for your help!
  2. forecasting

    In 1 or in 2 tables?

    What is efficient? If all you need to do is know the status of the employee, a simple boolean field (EmployeeStatus) solves the problem. Then you can add the field in a WHERE clause and get only the records you want (including any linked tables). And if you are searching for a person by name...
  3. forecasting

    Can you change users within a stored procedure?

    I have two databases in the same instance of SQL Server, DB1 and DB2. I connect to each database with a separate login that is not shared between databases (login1 for DB1 and login2 for DB2). When running a particular stored procedure on DB2 I want to insert a record on DB1. I can do this...
  4. forecasting

    Syntax for IN clause when used in Stored Procedure

    Alas! I was hoping for something easier. Sooner or later, every good idea degenerates into work. Thanks for the answer.
  5. forecasting

    Syntax for IN clause when used in Stored Procedure

    I think what you are saying is to insert the values into a temporary table in order to use them. Am I correct?
  6. forecasting

    Syntax for IN clause when used in Stored Procedure

    I am trying to write a stored procedure where I can pass in the criteria as a single string. For example, DECLARE @INclause nvarchar(20) SET @INclause = '''WA'',''CA''' SELECT City, State FROM Atlas WHERE State IN (@INclause) SQL does not interpret the @INclause as two criteria. Does...
  7. forecasting

    Does meta data list a tables last update time

    Is it possible to query meta data to get the last update time and date for all tables in the database
  8. forecasting

    ASP : global.asa file connectivity problem with sql server

    on logout if you call session.abandon variables are not destroyed until the script you are executing is finished. since no script is executing when timeout shuts the session down, I'm not certain the case is the same. is your connection string stored in the session object? if it is, have your...
  9. forecasting

    How to get mouse coordinates

    I found a method to work. <BODY onmousemove="window.name = window.event.x + '|' + window.event.y"> My vbscript then gets the value in "window.name" when it traps a double_click event. Is there any reason, however, that "window.name" is a bad place to store this value? If that is so, is...
  10. forecasting

    ASP : global.asa file connectivity problem with sql server

    I don't know the answer, but if I had to guess I would assume that the session_onend triggered after the session was closed. If so, you're connection string is gone. What code are you trying to execute?
  11. forecasting

    ASP : global.asa file connectivity problem with sql server

    I found this KB article: http://support.microsoft.com/default.aspx?scid=kb;EN-US;175671 "CAUSE Microsoft Windows NT Server is denying access to the SQL Server. This error can be caused by the way Users, Groups, Rights, and Permissions are configured. Specifically, Microsoft Internet Information...
  12. forecasting

    How to get mouse coordinates

    From within a web page
  13. forecasting

    How to get mouse coordinates

    Does anyone know how to get the screen coordinates of the mouse with vbscript? I tried "window.event.screenX", but get an error message telling me "Object required: window.event
  14. forecasting

    Recover MDF File

    Is it possible to recover a database from its mdf/ldf files? My OS was corrupted and I had to reinstall SQL Server on my work machine. I have the .mdf files but no .bak.
  15. forecasting

    TreeView scroll to first node

    Thanks I also found that I had to select the root to get to the top node once I got to the top level node without a parent.
See more

Part and Inventory Search

Back
Top