Viewing 15 posts - 16 through 30 (of 30 total)
use sp-help and sp_columns
sp_help will give u list of tables from database
sp_columns <table name> will give u list of columns from table.
October 10, 2001 at 10:11 pm
Creating vbs of asp is simple.
1. Remove <% and %> from the code.
2. Also if u have included the adovbs.inc file, remove include statement and declare all the...
October 10, 2001 at 9:57 pm
Use:
sp_password @old = 'Old PAssword' , @new = 'New Password', @loginame = 'Login Name'
October 10, 2001 at 12:53 am
The other solution can be :
Create the vbs script instead of asp file
because most of the time the ASP page gives Time Out Error for such type of bulk mailing.
...
October 9, 2001 at 11:20 pm
Do u mean to say that u want to use threading? like when database search is going on , the intermediate page is displayed?
Alternative could be
1. Get the record count...
October 9, 2001 at 11:13 pm
Check if the same file is used by the application currently open.
September 27, 2001 at 10:19 pm
Check your SQL Server ODBC Driver. ver 6.5 below has a limited lenght of varchar field i.e. up to 255 chars. So it exports only 255 chars even if u...
September 20, 2001 at 10:11 pm
U can also use
Format ("01/01/2001", "MM-DD-YYYY")
September 14, 2001 at 12:36 am
The Encrypt function encrypts the data but it is intended to use sys tables only. So even if u r writing
Select * from login where username='ABC' and password=Encrypt('Password')
or
Select...
September 4, 2001 at 11:59 pm
The temporary tables gets dropped automatically once the execution is complete.
Isn't they get dropped?
September 3, 2001 at 5:13 am
Try
DBCC SHRINKDATABASE (tempdb,10)
This will decrease the size of the files in the tempdb database to allow 10 percent free space in the files of tempdb
Deepak
September 2, 2001 at 10:31 pm
But then how do i encrypt the data. Is there any encryption function available? I dont mind sending data unencrypted but data should be encrypted when it is stored.
August 8, 2001 at 4:36 am
SQL Server 6.5 varchar field can contain max 255 characters . Thats why the problem is. Update your driver to 7.0 or above.
July 23, 2001 at 5:50 am
The stored procedure is executed simultaneously and independently, and they doesnt block each other locking of the data.
July 19, 2001 at 3:38 am
Viewing 15 posts - 16 through 30 (of 30 total)