Search results for query: *

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

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

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

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

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

When a time stamped record is inserted from a separate application, a trigger is executed that expands the time stamp into several fields. However, I discovered that the trigger code is updating every record in the table, not just the one being inserted. Any ideas about how to stop this...

I have an asp page that is running Office Web Components. When the user mouses over a cell in the spreadsheet component, I use an event to trigger changing the mouse pointer from an arrow to a hand. The event triggers properly but I don't have the DHTML syntax to change the pointer. I tried...

I want to submit a form using an image for my submit button that changes when the user does a mouseover. When I mouseover with this code I get the error &quot;document[...] is null or not an object.&quot; Can anyone help? <form method=&quot;post&quot; action=&quot;logic.asp&quot;> <INPUT...