hi, altough it has been long time from the post, can you explain how you did the last part
"ConnectionString == User::MailServerConnectionString"?
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
Your ADO object may also need to mark the parameter as an "input/output" parameter
i dont need tio mark it as input/output i have lot of sored...
well in my SP its like this
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 :
but will be i able to insert this returnd value into a datetime column?
can i get the date withgout the time from getdate()??
withought to need to start breaking into pieces?
thnaks in advance
can you explain what execlly mean's publisher and subscriber
what do u mean by "recompile"?>
i am using this code :
set cm_getAcc = Server.CreateObject("ADODB.Command")
cm_getAcc.ActiveConnection = Application("conn1")
why d u say :
"Over time itÃ„s almost impossible to maintain a perfect sequence using the IDENTITY property.
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...
ok say for example i have a form with 3 question
each question has a checkbox likethis :
and i ask...
at my home i work only me and at work max2-3 pepole work!
beacuse of that i cant understanmd why it so slow where on the server on the net there are...
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...
that wont help
it isnt possible that on 2 maching with the same software/hardware it works difrrently on the same querys with so diffrent performance...
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...
but what if the changed table is contains in 20 diffrent views?
do i need then to sp_refreshview all of them?
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...
Separate names with a comma.