Monthly Archives: July 2011

Insert all data from one table to another with table Stracture

    with Stracture select * into newtablename from oldtablename     With out Stracture(only Data) select * into newtablename from oldtablename where (1=2)

Posted in Sql | Leave a comment
Posted in Sql | Leave a comment

check free disk space in windows using sql query

   

Posted in Sql | Leave a comment

login failed for user ‘nt authority network service’

1>   Go to Start 2>   Click on Run 3>   type SQLWB(press ok button) 4>   Connect the Server 5>   Go to Security option 5>   Explore the Logins option 6>   if user ‘nt authority network service’ is not created.(if user is already … Continue reading

Posted in Sql | Leave a comment

if table exists in sql drop it and then create by using OBJECT_ID()

  OR      

Posted in Sql | Leave a comment

Comma Sepreted List of Column value in SqlTable

   

Posted in Sql | Leave a comment

Sending Email From JavaScript using OutLook Automation

1.1          CODE   Copy the code in a notepad file and save the file as “testemail.asp” and put it somewhere in IIS and run from there. Make sure all the three attachments are available before you run this code. <!DOCTYPE … Continue reading

Posted in JavaScript | 3 Comments