Search results for query: *

First of all, forget for this simple question but I have no idea why the data type size of the SQL Statement being passed from the Microsoft JDBC Driver to SQL Server is different than what it should be. I have the following java codes: PreparedStatement updateTemplate = con.prepareStatement...

First of all, forget for this simple question but I have no idea why the data type size of the SQL Statement being passed from the Microsoft JDBC Driver to SQL Server is different than what it should be. I have the following java codes: PreparedStatement updateTemplate = con.prepareStatement...

I have retested the application, with the same data getting updated but with database size increased (using alter database cmd, dbreindexes, and update statistics) so no db growing takes place during the transactions. The result is still the same. I even made the db 170% bigger with dummy...

The questions that I have for the DB2 USB (Windows) are: 1)Security - can i use Windows Authentication but still limit certain group of users (i.e., developers) to certain databases? 2) Backup - can a complete backup be done on a database while users are using it? 3)Can the data files (database...

We're using SQL Server 7.0. I like to remove any index that is not being used by any applications, but I don't want to do a profile on the database and run every possible functions in all applications. Is there a better way? Thanks!

Thanks for taking the time to read this by the way. We're a small company (less than 220 employees), and we are currently using SQL Server 6.5 - 2000 in our databases. The biggest database has a just over 5 GIGS of data, but it's growing. We are an NT shop, and main systems are written in VB...

Thanks for taking the time to read this by the way. We're a small company (less than 220 employees), and we are currently using SQL Server 6.5 - 2000 in our databases. The biggest database has a just over 5 GIGS of data, but it's growing. We are an NT shop, and main systems are written in VB...

Thanks for taking the time to read this by the way. We're a small company (less than 220 employees), and we are currently using SQL Server 6.5 - 2000 in our databases. The biggest database has a just over 5 GIGS of data, but it's growing. We are an NT shop, and main systems are written in VB...

I have been using Window's Performance Monitor and the SQL Server's Profiler to examine performance problem or to evaluate execution plans. Both tools can be helpful on a very simple querries (or SP). I need tools that can point out indexes to add, most costly SPs, and I want something...

For example: select OrderID, Order Descr from Order where OrderID IN(execute uspOrderByDemographic)

Occasionally the ADO object calling the stored procedure will cause SQL Server to submit the query with the SET FMTONLY ON command, and according to Microsoft this is supposed to be fixed by the MDAC 2.6 Service Pack 1. We have been using the Service Pack 1 for a while now, so we are left to...

Getting error when trying to run an exe file created in earlier versin of fox (not sure which version it was). The error is "cannot locate FoxPro Support Library". We've just moved all all files into a new application server and that's when we are getting the error. I am guessing...

Everyone is suggesting not to refer to a view in a Stored Procedure because the precompile version of the SP does not include the execution plan for the views that are being used in the SP. Is this true? I don't see why referencing a view in a SP is any different that referencing tables...

I can see that the SQL document says that you can have up to 256 tables in a query, but I am having a problem to get any data to return when my query has more than (inner and outer joins, and with subquerries) 28 join-clauses. As soon as I take out the last left outer join clause (which is left...

Hi, I need to make sure that the transaction log files will not get full because we'll have many transaction through a day, which will involve an update of image data type column. We'll be using ADO Recordset object to do an update, and while testing I can't figure out if SQL Server is logging...

Someone told me that I we wouldn't need the CAL for the VB application, because unlike MS Access the VB front end is not directly browing a table. Isn't the license for connecting to the SQL Server? Thanks in advance.

The first process that happens in my VB application is calling a stored procedure (from an ADO object)that submits a BEGIN TRANSACTION statement, an INSERT to table-A, and exits the SP without a ROLLBACK statement. The VB app then destroys the ADO object so no connection object is active. A...

i need to control the editting buttons (vieww,add,delete,update) and limit menu options to users base on their rights. I will use tables to store what screens and menu selections a user has, but I have never employ this setup in Visual Basic. Has anyone gone down this road or has other ideas...

Hi, We have been experiencing performance problems in our SQL 6.5 databases (about 9 databases) in one NT Server. We are reviewing stored procedures and indexes, but at the end I am guessing that we will continue to have problems because some of our users are using MS Access to browse and edit...

I have restored a database from a disk file, and now i want to add a user to the database but I am getting an error saying that the user already exists. I user does not appear in the user list, but it does appear in the list for the public role. How can I remove the user if it's not in the...