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!
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...
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...
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...
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...
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...
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?
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...
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
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.
I am building a treeview from a list that requires building the children before the parents. I seem to have the reconstruction of the Tree down pretty well, but when I open the list I am not at the first node. What's more, the first node isn't even shown on the screen.
Since I seem to have...
D'Arcy,
Don't know if you had any luck, but I found that the Nodes parameter does not work with Windows Common Controls v6, only with v5. If you previously used the nodes paramete, you might want to see what the recent version of TreeView is that you are using.
The way around it is to declare...
Once @datestring gets beyond the intitalization, it pulls the record from the database and includes the time. So I don't think that is the cause.
I never could figure out why it wouldn't work. Eventually, I converted the sql to a stored procedure and executed that. All of the records get...
Sorry about being vague. My question is whether I have failed to configure ADODB.Command properly and that is the reason it fails to insert the proper number of records. Is there a property with ADODB.Command that would cause it to exit a While loop before its condition is met?
I am trying to insert a time series into a table. The table consists of two fields, a time stamp that increments 15 minutes for each record and a second time stamp that is 15 minutes later than the first stamp.
TT15_Stamp TT15_Stend
1/1/2001 00:15 1/1/2001 00:30
1/1/2001 00:30...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.