Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mystical_sun2000
Starting Member
5 Posts |
 Posted - 2006-06-07 : 09:11:50
|
| Hi There,I have a software where the frontend is created in VB and backend is created in SQL server. Our HO sends a file, this file has only one month validity. It has 2 files one is parent and one is child file. while uploading the file using software it creates the following filesClipboard Clip File, Cursor File, DBE file, EXM, GLB file, MOD File, SQL server subscription file, MTB file, PAT file, PSK file, PTD file, QCM file, QTY file, SEM file, SMO file,STR file, TOP file and a VLP file.This files uploads questions and answers in database. and in SQL Profiler it runs the following queriesselect dbname from master ..syslogins where loginname =UPPER ( 'S' ) select convert ( varchar ( 10 ) , getdate ( ) , 105 ) from sysusers where uid =0 select convert ( varchar ( 10 ) , getdate ( ) , 105 ) + ' ' + convert ( varchar ( 8 ) , getdate ( ) , 108 ) from sysusers where uid =0 select convert ( varchar ( 10 ) , getdate ( ) , 120 ) from sysusers where uid =0 All of them returns date. But after this it throws error file expired. I dont understand from where it checks date. and which file contains questions and answersCan anyone please tell me which file might contain date validation and how do i remove it. I can mail the files for your kind reference.Thanking you and waiting for some kind repliesmystical |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-06-07 : 09:43:30
|
| Those SELECT statements seem to just be selecting today's date (formatted in various ways), but depending on whether USER uid=0.The "file expired" error looks to be something the VB stuff is generating - doesn't sound like anything at the SQL end.It might be that USER uid=0 no longer exists??Kristen |
 |
|
|
|
|
|
|
|
Date Validation in SQL server