my log file is in size of almost 7 GB where the DB is in the size of
morethen that - i have change the recovery from full to bulk
i have 2 DB
and i have a USER that defined as a db_owner of both of the DB's.
when i try to activate a SP on the second Db like this :
can i get the date withgout the time from getdate()??
withought to need to start breaking into pieces?
thnaks in advance
i am using this code :
set cm_getAcc = Server.CreateObject("ADODB.Command")
cm_getAcc.ActiveConnection = Application("conn1")
i have inserted into a table with a column called id defined as Identity(Yes) line from a file.
the line in the file in the id column had a number in...
i have a text file i want to import to a db
where i have problems with the columns that have
1)default value - like getdate() - whci h iwant it to...
what is the most correct way to store a checkboxe's that were selected,and save them by there id value for example.
and if i want to make a search...
i have a website on a local server atthe office on 1 on the web.
te 1 on the web works great and responds very fast to quries but
the local server...
have addeda column to a table
in the middle of the table,when i did it and i run a view which is total independet of the new column i got wrong...
importing a visual fox pro file -dbf contians herbew
how can i do this?at the moment i recive an error message :...
Separate names with a comma.