Recent content by vganeshbabu

I found it.. it needs administrator privilleges.. my login did not had it.. now it is fixed.. Thanks guys.. Ganesh

Hi George, Still I am seeing the index tuning wizard - disabled after writing the query or load the query thru a sql file also.. Looks like INdex tuning wizard is not install, is there a way to install it separate ? Ganesh

I checked it.. but it is disabled.. Ganesh

Hi hmckillop, I went there but it is not listed there.. it only shows "Register Server Wizard".. Ganesh

Hi, How do i install the index tuning wizard?? I have installed the sql 2000 enterprise edition both client & Db. But now ablt to find the Index tuning wizard.. Please Help Thanks & Regards, V.Ganesh Babu

this should be ok.. Ganesh

Try using triggers for that table. u will be able to get the old values and the new values, u can update them to a new table.. Ganesh

yes u can, create a macro and do the vb code to run the stored procedure from Excel

Try this sSQL = "Insert into TLogin (Firstname,lastname,username,password) Values" & "('"& Ucase(Request("firstname")) & "', '"& Request("lastname") & "', '"& Request("userid") & "', '" &...

enjoy your learning.. for self solving these issues u can always search things in http://www.google.com

i would always prefer windows authentication. if windows authentication - it uses the authentication of the user who runs it..

check this link.. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp it returns the output of date in a specified format for 107 it is Mon dd,yy

there are ways u can have server names in variables and form the whole SQL as a string an execute. but u will have so many issues in it and maintaining them.. It is always good to use the hardcoded server name..

try this out UPDATE dbo.Execsum set AP=(SELECT sum(amt_1 + amt_2) from APOPNFIL_SQL) WHERE convert(char,datefield,107) = convert(char,GETDATE(),107)

hi, check this link.. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cdo/html/_denali_bcc_property_cdonts_newmail_object_.asp