Are there any tools to quickly test network reliability to a SQL server? We are receiving error reports from a particular customer who has a random "connection failure" message popup throughout the day. We have identified a few spots where this error might occur, but at different times of the day the code executes perfectly. Some other ...
Is there a jdbc driver for SQL Server that can search for database instances on network? Just wanting to emulate "OSQL -L" from the JDBC driver. Dont want to have to call OSQL from JNI or something. I also don't want to have to write my own code for scanning a UDP port. I want my Java application to be able to search for live SQL S...
Since I believe this should be a basic question I know this question has probably been asked, but I am unable to find it. I'm probably about to earn my Peer Pressure badge, but I'll ask anyway: Is there a way in SQL Server that I am not aware of for using the wildcard character % when using IN. I realize that I can use OR's like: sele...
Hello - We would like to force encryption of the data going to and from our customers' SQL databases. Currently, we access the customer databases via ODBC DSNs, using both SQL Management Studio (Query Analyzer) and our custom applications. Yeah, I know this is not "best practices", but I have to deal with it for now. Anyway, I have b...
We're building a simple ADO.Net infrastructure, and looking for the best practice for creating one or more objects/methods to handle queries to SQL Server. Such a method could for example, take a connection string and a query (or stored proc), and return a datatable, dataset, etc., with the query results. How has this worked best for...
Out of curiousity, is there any way to edit an existing synonym? That is, change which table the synonym is pointing to... Thus far I seem to have had to delete and re-create them, because they're locked from being edited. It's not a big deal, but at the same time it's a little irritating. GUI or scripting, but preferably GUI. ...
Hi, We are in process of completing the migration of Oracle to SQL Server 2005 (schema, data and programming objects). We have about 1220 stored procedures to be tested. What would be the best way to test them? Is there any automation possible here? We are thinking of writing a small window tool which would take the stored procedure na...
can triggers be created in assemblies ? ...
Hi! I'm looking for a tool (best for free) which can synchronize two SQL Server 2005 databases. I have a sql database that is hosted on a server and another sql database that is hosted on aclient. Both have the same database schema. Each client has its own sql server because the application needs to run offline. The client is being co...
I was just prototyping a new system for deferring certain operations until out of hours on one of our databases. I've come up with (what I think) a pretty simple schema. I was first prototyping on SQL Server 2005 Express, but have confirmed the same problem on 2008 Developer. The error I'm getting is: Msg 8646, Level 21, State 1, Pro...
I am trying to produce SSRS reports to integrate with a MOSS Dashboard. Reporting Services 2005 only seems to be able to render .xls out of the box. Does SSRS 2008 have the ability to render in xlsx format? ...
Hello, In Sql Server 2008, many options are available for database paging via stored procedure. For example, see here and here. OPTIONS: ROW_NUMBER() function ROWCOUNT CURSORS temporary tables Nested SQL queries OTHERS Paging using ROW_NUMBER() is known to have performance issues: Please advise, which paging method has the best ...
Hi there, I'm querying a mssql 2008 database via odbc and stubled upon a strange behaviour. The following code is used... $datefrom = "2009-06-01"; $dateto = "2009-07-01"; $clientno = "01"; $sth = $db->prepare("select count(*) from tbl WHERE v_valid_from <= ? and valid_from <= ? and (v_invalid_from >= ?) and (valid_to >= ? or valid_to...
Would you consider it bad practice to store various user data in a database as serialized binary? Is it a good, bad or really ugly idea? I'm talking about pretty much arbitrary things, like the last splitter distance on a form, the last value in a search text box, prevously selected checkbox indexes, et cetera. Things that should be rem...
SQL Server 2008 Profiler always profiles all databases. I want to restrict profiling or output to a single database. How can that be done most easily? ...
I am trying to create Update trigger which should be invoked only if the ReturnedOn column is clicked. I have used the following code-snippet but it generates the error: CODING: CREATE TRIGGER trg_ForUpdateOnBookIssuedDetails on BOOKISSUEDDETAILS For update as begin declare @Rows1 int,@Rows2 int if(update(ReturnedOn) begin IF EXISTS(...
I have 2 tables requests (ID, company_id, amount) companies (ID, name) with FK constraint (requests.company_id -> companies.id) requests.company can be NULL I need to get all requests and replace company_id with appropriated company name or left it blank if no company was specified. I have next query: SELECT R.[ID], C.[name] AS [c...
I have a serious problem. One of our servers crashed. Now I reinstalled the server from scratch and want to restore the sql server 2005 databased. I chose "Databases -> Attach" to do this, which worked for most of my db files. However, with one mdf file I get a error message during recover: The error message is in german, I haven't tran...
This is one of those "I probably should know this, but I don't" questions. How do I make a copy of a table in Enterprise Manager? Not export the data into a different database, just make a copy of the table within the same database. At this point, I don't care whether the data comes with or not, but the table definition should definitely...
I have a couple of questions. 1) Why cannot we see system tables (like sysobjects) under Master/Model/MSBD etc.? But we can query. Are we basically querying the views, because as they are the main tables that holds a value able informations? Like "SELECT * FROM sysobjects". are we basically querying some views? 2) Why cannot we add ...