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 9GB!!!! morethen that - i have change the recovery from full to bulk but still...
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 .... @Id int as ..... that all
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 : set...
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 peleg
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") cm_getAcc.CommandType =...
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 : [checkbox] blue [checkbox] red [checkbox] green 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.
