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 strongm 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. is47501

    Cannot replace this?

    I came up something that may work well for you. As I understand it you need to update the data in the table, so I designed this with that in mind. I also did this in a hurry and on a limited set of data because I need to leave for the weekend. Please check my work carefully. WHILE EXISTS...
  2. is47501

    Find if Windows User belongs to a windows group for a SQL server?

    If I understand what you need this may work. I created it as a stored procedure and call the sp from VB. You may be able to find a way to execute only the SQL. One of the main keys though is the server settings in the first comment. create PROCEDURE dbo.csp_getUserApp2...
  3. is47501

    can I execute a sp in a select statment

    I found the end run. A long way around but it gets you there... SELECt * FROM OPENROWSET('SQLOLEDB','server';'id';'password', 'EXEC database.dbo.sp @parms') AS a
  4. is47501

    Finding a particular field name within hundreds of stored procedures

    I found a utility that does what you need and much more. Including searching any object in the database for text strings, global search and replace and compiling the code. It is called SQL Editor and you can find it at; http://www.sqleditor.com/ Check it out and post back your thoughts. Regards
  5. is47501

    List tables and fields used in Views

    I found a utility that does what you need and much more. Including searching any object in the database for text strings, global search and replace and compiling the code. It is called SQL Editor and you can find it at; http://www.sqleditor.com/ Check it out and post back your thoughts. Regards
  6. is47501

    Report states "No rowset was returned..." after deployment

    Bruce, Here are some thoughts, As suggested before by roadkill150, make sure that the database connectivity dlls are the same on all machines. On your second e-mail, I agree it sounds like the report once deployed to the new machine is still trying to access the original database. I have...
  7. is47501

    SQLSTATE=24501 in a query on a linked server.

    I found that an OPENQUERY(DW,'SELECT...') worked.
  8. is47501

    SQLSTATE=24501 in a query on a linked server.

    Hi all, I am receiving this error "SQL0501N The cursor specified in a FETCH or CLOSE statement is not open. SQLSTATE=24501" when running a query against a linked server in Sql Server 7.0. The linked server is an UDB (DB2) database linked with the OLE DB provider for ODBC. I do...
  9. is47501

    Linked server query

    I am receiving this error "SQL0501N The cursor specified in a FETCH or CLOSE statement is not open. SQLSTATE=24501" when running a query against a linked server in Sql Server 7.0. The linked server is an UDB (DB2) database linked with the OLE DB provider for ODBC. I do not get...

Part and Inventory Search

Back
Top