Search results for query: *

Create a text box and submit button, on click use method ="post" next page use request.form("Name of tHE text field") u can use ADO to connect to ur database % Set Conn = Server.CreateObject("ADODB.Connection") ' The following line must be changed to reflect...

You Can use DTS to do these. Create a DTS which fires up the query and using DTS export to csv file. You can automate this by scheduling the DTS Package

Hi I have a table Emname preference Location David 1 Canada David 2 Italy Michael 1 USA Michael 2 Japan what iam trying to achive is empname preferenc1 preference2 David Canada Italy Michael USA Japan without creating...

Thanks a lot this was helpful

Strangely enough the same error popped into our system, but we were not able to connect to our Shared drives. The problem was because there was no memory free on our servers, caused by running of norton antivirus. A simple reboot did the trick, hope it works for you too, best of luck.

I assume ur id column is the identity one. In this case yoy have to set the value explicitly means like 3, 4 or some value. You will not be able to do a select ID select id ( Needs an explict value like 1,3,4 etc) See BOL SET IDENTITY_INSERT (T-SQL) Allows explicit values to be inserted into...

Whats the exact use of .ldf files? If we have the back up of .mdf file, we ca attach it any time, so why do we need the log files? Also which option to choose for recovery? Full, Simple or Bulk-Logged, in SQL Server 2000

CREATE PROCEDURE getAuthors @Name varchar(20)='' , @FirstName varchar(20)='', @Title Varchar(40)='' AS SELECT Name, FirstName, Title from Authors WHERE ( @Name = '' or Name like +'''+@Name + '%' + ''') and ( @FirstName = '' or FirstName like ''' + @FirstName + '%' + ''') and...

Try this it may work Schedule The DTS package by right clicking the Package in the DTS Design Window. Now go to Jobs and Locate the Job the code, which shd be something like DTSRun...

Hi Can anyone sugges some good books and websites to prepare for MCDBA exam, particularly exam 70-229. Can someone help me on this? Thanks Anil

if its in same domain u can try \\ipaddress\pipe\sql\query

The client and server machine shd be in the same domain or the 2 domains should have a trust relationship between them We had this problem and we had to TCP/IP as there were in 2 different domains. Anil