I have a table with 17 fields out of which 8 are of Char datatype. While retrieving the records from this table, found that all the fields with char datatypes are filled with padding zeros. Because of this reason, my application doesnt allow me to edit any of this field values. Kindly prov...more >>

Hi I want to know how can i Pass tow Dates to Stored Procedure in sql server 2000 by using vb6. here below my code i used northwind database ,when i run the code i got error in the cmd.excute . i thing my problem in passing date, can any when tell me what is the problem Private Sub Co...more >>

Could anybody remind please, how can I get the current database size having the full access to this database and server? What's the SQL query? What else helpful about the current database can I get using queries? Load, statistics, what else? Thanks, Just D. ...more >>

I have been using MS Viso (the one that integrates with Visual Studio .NET) to generate ddl script for my database. It uses the following update trigger code to enforce the referential integrity, but will only execute the code for one row updates, it will throw an error for multi-row updates. ...more >>

I am trying to write a query which when run can tell what courses a department require and what courses were taken by the employee /* create table #temp(people_id int,course_taken varchar(50), date_taken datetime,full_name varchar(50), assign_id int,dept_taken varchar(50),jobcode_taken ...more >>

Is is possible to create a query to do something like this: For each "Record" from {SELECT field1 FROM table1} SELECT * FROM table2 WHERE field2='Record' next "Record"...more >>

trying to connect to remote MSDE database to manage it --msde instance with DISABLENETWORKPROTOCOLS=0 is installed and working. --local connection works to confirm username and password --firewall ports are configured correctly and listening --remote telnet connection works to confirm ip and ...more >>

Say I have 4 applications which each use their own database. There are two SQL Servers involved and the databases are split across servers like this: SQLServer1 - BigApp1 - SmallApp1 SQLServer2 - BigApp2 - SmallApp2 The above helps balance load. If I want to store inf...more >>

I have to store in some cases more than the 8000 character limit. And i have read about the text in row option. Seems like that will do what i need. But i dont really get how i enable it. I have searched google and google groups for some idea as how to enable it - and all i find is EXEC sp_tab...more >>

Hi I want to know how can i Pass tow Dates to Stored Procedure in sql server 2000 by using vb6. I need samplr code Best regards ayman ...more >>

I wasn't really sure where to post my question, so if I'm off-topic, could you please refer me to a more appropriate newsgroup? I'm quite new to MS SQL Server 2000 stored procedures development and I'm finding the Enterprise Manager to be quite difficult and cumbersome to work with. I'm looki...more >>

Hi, Can anyone tell me if it is possible to run an office application such as MS Access as a result ofsay an insert trigger occurring. Many thanks in advance. Mark ...more >>

Hello, I'm using this stored procedure: <code> CREATE Procedure ProductInsert ( @ProductID int OUTPUT, @CategoryID int, @Reference nvarchar (50), @Name nvarchar (50), @SmallImage nvarchar (50), @Image nvarchar (50), @OnSale bit, @UnitCost money, @Stock int, @Description nvarchar (3...more >>

Our VB6 app uses RDO to access our SQL server. I have created a stored procedure that performs a union of a couple of select statements and returns either 1 or 0 records, depending on the parameters passed in and the data retrieved. I call this sproc using the rdoConnection object's OpenResul...more >>