Search results for query: *

Consider this: foo.asp opens an ADO binary stream, reads binary data and then uses response.binaryWrite() to write that data to the response stream. All the prep is done (response.buffer=true, no other extraneous data written to the response output, etc.) It doesn't work. But I've seen...

I click on a site (Payroll site, in this case). There is a form library called Absentee Forms. I click on the Absentee Forms link. The Forms Library opens in a view called "AF Summary". There is a column called "Approval Status". But "Approval Status" is not one of the defined columns...

I have 6 tempdb_N.ndf files in a folder. We know they are in use (can't rename them, and task manager shows them in use by SQLSERVR.EXE). The problem is, we can't find which database owns them. I've looked at the filegroups for all the databases on the server, and none of them claim to be...

When multiple jobs are scheduled to begin at the same time, how does the Agent handle this? Does it attempt to run all sequentially in a single thread? Or does it multi-thread and run the jobs simultaneously? Thanks!

String[] abc = {"N",nPage.toString(),text}; vBarcodes.addElement(abc); Is there a way to condense this into something like: vBarcodes.addElement(String[] abc = {"N",nPage.toString(),text}); I've tried about every combination of parends that I can think of!

In my attempts to escape the static dungeon in which I seem to have found myself, I've modified my previous attempt at this to the following: import java.io.BufferedReader; import java.io.File; import java.io.FileReader; import java.io.IOException; public class FileToConsole { String...

For some reason, the line "FileToConsole.fileToConsole(cInputFile);" is generating that pesky "non-static method fileToConsole() cannot be referenced from a static context" error. But I cannot figure out what makes it think .FileTest() is static. Does it consider all constructors to be static...

Really stuck on this one... I am about to .setText() on a textfield, but just before I attempt it, I need to check whether the field exists or not: the jFrame form that it is on may or may not be open. Any ideas? Thanks

Is there a way to, at the database level, create an INSTEAD OF trigger (or anything else) that will prevent a query from returning the actual content of a row, but instead, return alternate data? Specifically, I want to grant developer access to query the "login table, but I want to return...

Endpoints are goners. For whatever reason. My question is, are SQL 2008's "Service Brokers" the same thing as 2005's "Endpoint Services?" Are Service Broker's also going away?

I'm getting to the point where I feel almost overwhelmed at all that I have to do. I'm both developer and DBA. And lately, I'm moving a LOT of stuff that I would normally code into an application or website, into the database itself. For instance, I recently added a whole line of email...

I need to create an AFTER UPDATE trigger. I've seen it suggested that the record being affected will be determined by joining the table being updated with the internal "INSERTED" table that is provided. Very briefly: UPDATE tbl_a where tbl_a.PrimKey = INSERTED.PrimKey. My question is, is...

I'm thinking about building a three node failover cluster, just for gits and shins... er, I mean, learning purposes. ;-) I have three licenses for Windows Server 2008 and SQL Server 2008, and three identical machines, and some extra time on my hands. We think this may be a supercool (er...

I have a script that does various maintenance things to a database that's kept on a backup server. It resets all passwords to blanks, empties certain temp tables, drops and readds all users, etc etc. It creates a test system from a backup of the live system. USE [master] ALTER DATABASE...

Hi All! I need to transform this: in this example, the type is 1=vac, 2=sick, 3=paid leave Date Hours Type 8/21/2009 3.5 2 8/21/2009 4.5 3 11/16/2009 8 1 11/17/2009 8 1 11/18/2009 8...

I've wracked my mind enough on this. Time to bring in some experts. I'm absolutely a beginner on handling JSON text that has been parsed into an object. In the following image, you will see at the bottom of the drilldown a reference to "LineItemKey". I've tried every variant of...

This isn't critical, I'm just wondering if anyone can explain this. I have an ASP (classic) page that is displaying info from a SQL Server 2008 table. The table column in question is a varchar(16) and contains data that is a text representation of a dollar amount - including the dollar sign...

Tried to pack as much as possible in the title. ;-) I can disable website anonymous access, and cause IIS/IE to obtain current user name in request.servervariables(AUTH_USER). No prob. The problem is that when the user hits this site, they are prompted to login using their windows name and...

I need to do an SQL 2000 to SQL 2008 upgrade on an existing server this weekend. What I'm wondering is, will an upgrade in place actually do what it claims? Will the database accept all application connections using their existing connection strings and continue to work properly? Or does...

Can anyone tell me if the following update trigger is the most efficient way to do what I'm doing? or is there a better way? I'm particularly concerned that the way I'm doing this requires me to make three selects to get three columns from the same table (deleted). ALTER TRIGGER...