How can I tell (preferably by a version attribute on some DLL or EXE) that Service Pack 3a has been installed on a client PC? KB articles such as 321185 do a great job of showing how to use SERVERPROPERTY to determine what version the SERVER is running, but that's not my question. I need to ...more >>

A problem occurred while attempting to logon as the Windows user 'SQLAgentCmdExec': The parameter is incorrect. The step failed. There are a few jobs that developers create and they run under there accounts, I do not want to give them sysadmin access, but they need permissions to CmdExec. I e...more >>

Hi I am running a software package that access SQL Server files. I am getting these messages: * "Invalid pointer operation" * "The RPC server is unavailable" * "Access violation at address 40006834 in module 'rtl60.bpl'. Read of address FFFFFFFF" when deleting an event * "Access vi...more >>

Timestamp is a data type that exposes automatically generated binary numbers, which are guaranteed to be unique within a database. timestamp is used typically as a mechanism for version-stamping table rows. The storage size is 8 bytes. let's say there is a table CREATE TABLE ExampleTable (...more >>

I am trying to execute the following stored procedure by the following ways but failed to do so ... can you add some comments regarding this. First Attempt: DECLARE @ErrorCode INT EXEC SPUpdateAssignProduct @AP_AssignProductID = 1,@AP_LockedID = 'A73E0831-8FCA-459B-BBAA-C7E72AC75A1',@ErrorC...more >>

Can any one guid me like I have a billions of records and I want to see only 10th record and I want to fetch the 10th record through rowid not the Unique primary key. Let's say Table primary key id start from 6380, 7066, 7067, 7131, 7896, 8042 and so on .... If I wanna fetch third r...more >>

For some reason, when I try to generate a script for Triggers off of a View using DMO, I get back garbage like: ??VIEW1 That's the complete text coming back, nothing more. I can see it clearly using MSEM just fine. Any thoughts? -- Lee ...more >>

Are there any tools that allow you to compare two sql server databases to find out what is different between them (the database structure, including tables, relationships etc)? Thanks, - Gabe ...more >>

SQL Experts, I have a compute problem in SQL Server 2000 SP4. I have the following SQL Script to derive a %. According to the example below, the iSQL returned a 0.000% while the actual result is 45.91836% Example: declare @i numeric(9,5) set @i=(45/98)*100 select @i --The above ex...more >>

Dear Professional, Image saved in the table and I wanna copy that image into any folder let's say... D:\Image\MineImage.gif Is it possible ? Thanks ...more >>

I just downloaded this product & it looks like it could be a very good solution for a large number of users at our company. However, I believe there are a couple of things that if modified would make it much better for our usage. They are: 1. The tool does not have a way to store your ser...more >>

Can I have both SQL 6.5 client (Enterprise Manager, ISQL_w etc) and SQL 2000 (Enterprise Manager, SQL Analyzer) installed on the same machine?...more >>

I am reading a list of tables from a table and wish to execute a SQL statement for each table from this list. I tried declaring @table_name, depositing the table name from my table-list data. However, the "Select * from @table_name" SQL fails. Any ideas?...more >>

hi everone i have question about DBCC SHOWCONTIG results of Table we have table with huge amount of data in it. When i run ''dbcc showcontig('<TableName>') with fast, ALL_INDEXES,TABLERESULTS '' i saw that most of indexes have logical fragmentation over 80% then i run DBCC dbreindex and...more >>

I try change database's collation. What is the right way to do this? Now I have script which 1) Drop indexes 2) Drop pk:s 3) Alter all character -type columns: "alter table xx alter column datatype(len) collate new_collation null|not null" 4) Create PKs again 5)Create indexes again It'...more >>

We've got SQL 2000 clients (standard install, no sp) who are connecting to our SQL 2000 Servers with Named Pipes even though we've disabled named pipes in the client network utility. They should be connecting via tcp/ip. Any ideas on what could be causing this? ...more >>

Is it possible through front end like I can call DTS package on demand like on button click.. for instance on button PUSH click I want to call Package1 and on button PULL click I want to call Package2.... how can it be possible? any help is available ? I would really appreciate..... Thanks ...more >>

I have one customer.dbf file and in SQL Server I have a customer table. Now the problem is that I don't have Dbase install in my computer. I want to push the sql server data into the customer.dbf file. I am trying to do this through DTS export wizard but failed to do that... Can any one guid...more >>

Hi, I'm trying to migrate a database from Sybase to SQL Server. As far as I understand (I'm not a db exert), it is not possible in SQL Server to reference an alias for a column name that is defined in the select-clause in the where clause. With Sybase this worked, so this kind of thing is wide...more >>

You are the DBA for a busy order entry database. You want to provide a method for automatically backing up the transaction log for you database in case it becomes more than 90 percent full prior to the next regularly scheduled transaction log backup. What is the best way to accomplish this? ...more >>

If Table1 is going to be joined on 90% of the time on ID, and used to generate lists 10% of the time, which of the following combinations of indexes would provide the best performance to the most queries? 1.. Clustered unique inde on ID; non-clustered index on LastName, FirstName 2.. Clus...more >>

If Table1 was used in an inner join, with the ID field being the inner join index, which of the following indexes would provide the best performance? 1) CREATE UNIQUE CLUSTERED INDEX foo on Table1(ID) 2) CREATE UNIQUE INDEX foo on Table1(ID) ...more >>

Are UNIQUEIDENTIFIER & TIMESTAMP data type are uniquly identified in the database? Thanks ...more >>

I'm wondering if there's a slower running time between IN and EQUAL in the WHERE clause. SELECT * FROM CUSTOMERS WHERE CUST_ID = 123; vs SELECT * FROM CUSTOMERS WHERE CUST_ID IN (123); TIA. ...more >>

For ORG_ID: I have the query below.. can anyone help me with it.. this is the first time I am creating SPs.. thanks in advance 1. First Join between [RAS].[dbo].[EXPENSE_ENTRY] AND [EDGE].[dbo].[tblCustomerFile] Common Column: TransId IF [RAS].[dbo].[EXPENSE_ENTRY].TransId = [EDGE].[d...more >>

I am in a situation where I need to find out unique field names with different values in a table having 200+ columns. Let's say I have two rows with 200+ columns ( I exported these rows from Lotus Notes to SQL Server) I am not sure what columns makes unique of these rows. It's going to be t...more >>

Is there anyway to auto increment the primary key column like you can in access but for SQL 2000? Thanks, - Gabe ...more >>

Where I can found information that what indexes are primary keys, and where is the information of constraints type in sysconstarint table? I readed drom help that field sysconstraints.status should tell it, but I have mystique values in this field, such as 3105, 2069, 133141 etc... Data type is...more >>

Where can I found index_name and index_keys of indexes in SQL Server? I know that there is table sysindexes but there aren't index names etc. I need information of table's indexes, such as SP_HELPINDEX return. So I tried something like this: Select index_name, index_keys from (sp_helpindex t...more >>

Hi Folks, I have developed a Setup Program. I have also created an MSI, to which I make a call from within this setup program. The Point is that in this MSI, if i add a Dialog Box manually, I see a property called "Banner Text". However such a property in not present for Default Dialog Boxes. No...more >>

I have too many connection from one user, Can I limit this user's connectiion num? I can't change his code. Thanks Jack ...more >>

Here I have a question like I have created one stored procedure which InsertCustomer and call that stored procedure in the customer form.... the problem is that when more than 50 - 60 people access the same form simultaneously then it gave me some time time out error or some times gave me primar...more >>

Unable to understand licensing. We have a 25 user windows 2000 server as a member of windows small business Server 2003 std edition domain. We would like to install SQL on the W2K server. Do I need to purchase SQL CAL's or would the windows CAL's suffice....more >>

Hi, I am using sql server 8. I have a table with a column whose data type is set to Float with a length of 8. Whenever i am inserting the value ending in .1 it is storing the value .10000000000000001. Why is that? Thanks ...more >>

I have a copy of Data File and Log File, named pms_bak.mdf and pms_bak.ldf. May I restore them into my new sql server? How can I do? thank u ...more >>