Search results for query: *

Hi there. I have an application that calls a stored procedure which creates new databases on the fly (don't ask, legacy code). My problem is that the application user becomes the database owner of these new databases. I need to be able to execute sp_changedbowner 'sa' in the same stored...

Hi. I am using OpenRowSet to query a Foxpro database from SQL. The query works fine, however, SQL maintains a connection to the file long after the query completes and the query window is closed. The only way to release the connection is to stop the SQL Service. This is a problem because...

Has anyone else had any issues with this? I use a DTS package to export data to a text file. I need to import this data back into SQL but I'm running into trouble because the DTS package exports my bit fields as 'True' or 'False' instead of 0 or 1. When I attempt to reimport this, the import...

Hi all. I work for a company that is developing a client/server application with a rather large and complicated database. I am told that we should not use identity columns as primary keys because "There are no advantages of using them with related tables" and "They are designed...

Hi there. I am having trouble understanding different graphical execution plans for one of my SELECT queries. I have tested performance of this query using different joins and indexes and have noticed that the "subtree cost" could increase significantly even though the query execution...

Hi there. I am researching a solution using a TEXT datatype for data that will exceed 8,000 characters. I know that there is a limit to what can be returned in a simple SELECT, UPDATE and DELETE statement but BOL seems to contradict itself on the exact limit. Maybe I'm misinterpreting...

Has anyone had any experience using the query option "Option (FAST n)"? BOL says this: Specifies that the query is optimized for fast retrieval of the first number_rows (a nonnegative integer). After the first number_rows are returned, the query continues execution and produces its...

I am considering a solution using partitioned tables and local partitioned views. According to BOL, a set of partitioned tables must have check constraints on each primary key of each member table which allows a specific range of values. Inserts to the partitioned view must contain a primary...

I have a Crystal 8.0 dictionary which uses a User DSN connection to a VisualFoxPro database. Some of the tables have related ID fields with mismatched datatypes. For example, the Collector_ID field in the Assets table is numeric but the Collector_ID field in the Collector table is an integer...

Hi there. I have an Access2000 database with local and linked tables. The linked table source is a foxpro database and all data is static. No other users have access to either database but when I execute queries that join the local tables to the linked tables, I get inconsistent and incorrect...

Hi there. My question is: When using application role security to access a SQL2000 database from (lets say) a VB6 application, is it necessary to connect to the database first using a valid SQL or NT user account? In order words, does the application first connect by 'sa' or another user and...

I have a SQL2000 server which has a FoxPro linked server named Fox_link. I am trying to execute queries against these foxpro tables from Query Analyzer but I can't seem to make them work. Books Online indicates that I need a fully qualified table name including the linked server name, catalog...

Hi all. One of my clients is sending me a SQL6.5 backup file. Will I be able to restore that file using SQL2000? Thanks.

Hi there. I am working for a software company that releases product upgrades to their clients twice a year. I am using SQL Server 2000 and I'm currently using ERWin to create the necessary scripts to upgrade one version of the database to the next. I am interested in finding out how others...

I know there is a system stored procedure sp_MSforeachtable but is there one for stored procedures?

I know I'm missing something obvious but this has been giving me a headache for over an hour now so I have to ask... I'm trying to send my backup files (SQL2000) over the network to another server on the same domain. I have mapped a drive from the SQL server to this machine. I am using Windows...

Malcolm - are you out there? I was hoping you could help me with running totals. I read your FAQ but couldn't seem to make it meet my needs. I'm either completely missing the boat (entirely possible X-) ) or maybe it just can't be done the way I'm trying to use it. Is it possible to return a...

anyone know if there is a function in SQL2000 to convert a javascript timestamp into a real-date format? the javascript timestamp is stored in a numeric field of length 9 (here is how it looks: 989363130671) and it represents the number of milliseconds in Universal Coordinated Time between the...

hi there. i am converting a large table from visfox to sql2000. this table stores values from a complicated data entry form. in visfox, it has a memo field that stores an array that represents all of the form's required entries and the user's value for these fields. the visfox sample data...

Other than the typical limitations of text datatypes, does anyone know of other potential issues when using multiple text fields in a single table? I need to convert a foxpro database to SQL2000 - many of the tables have multiple 'notes' fields. While varchar(8000) would probably meet the...