Search Results | SQL Server Performance Forums

How to create dynamic or tempary table in sql server 2005

Thread by: mpolaiah, Sep 28, 2010, 2 replies, in forum: SQL Server 2005 General Developer Questions

Hi all How to create dynamic or tempary table in sql server 2005

How to add date and time

Thread by: mpolaiah, Sep 28, 2010, 1 replies, in forum: SQL Server 2005 General Developer Questions

Hi alll, i am using sql server 2005, How to add date and time for exampleeeeee my date file is 2010-09-29 11:53:00 and add these file 01:00:00...

how to reduce the memory useage of the sqlserver.exe process

Thread by: mpolaiah, Dec 11, 2009, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi all how to reduce the memory useage of the sqlserver.exe process

How to consuming web service in sql server 2005

Thread by: mpolaiah, Dec 9, 2009, 2 replies, in forum: SQL Server 2005 General Developer Questions

Hi all How to consuming web service in sql server 2005? please help meeeeeeeeeeeeee. regards pols

Function Problem

Thread by: mpolaiah, Aug 18, 2009, 1 replies, in forum: SQL Server 2005 General Developer Questions

Hi All my function is --drop function priority create function priority ( @nRequestDetailsID int ) RETURNS int AS begin declare @pre int, @a...

Named Pipes Provider: Could not open a connection to SQL Server [2].

Thread by: mpolaiah, Aug 7, 2009, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi All, i am run the sqlcmd the following erros is came how to slove...........like....... SET @SQLCmd ='sqlcmd -d SMS -q "set nocount on;Select *...

how to text file append?

Thread by: mpolaiah, Aug 5, 2009, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hello, I have several sql scripts to be executed on a set schedule, with the output directed to a text file. If the schedule triggers this process...

How to replace existing text file in sql server 2005

Thread by: mpolaiah, Aug 5, 2009, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi All, i am execute the command declare @SQLCmd varchar(500), @FilePath varchar(200), @nRequestid varchar(100) set @nRequestid=186 --set...

export data from sql server 2005 table to text file

Thread by: mpolaiah, Aug 5, 2009, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi All, i am using the sqlcmd -d expot the data into text file at save the file 186.txt and once again run the sqlcmd -d and save the same path i...

Trigger Problem

Thread by: mpolaiah, Jul 31, 2009, 3 replies, in forum: SQL Server 2005 General Developer Questions

Hello, Does anyone know how to get a trigger to fire while you are uploading multiple records into a SQL Server 2005 Express DB using the DTS...

Bulk Insert Problem

Thread by: mpolaiah, Jul 30, 2009, 3 replies, in forum: SQL Server 2005 General Developer Questions

I have a proplem with BULK in stored procedures. I want to do a BULK from a file (.CSV) wich name changes every day. So I have an attribute...

The mail could not be sent

Thread by: mpolaiah, Jul 27, 2009, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi all, i am sending the mail but it is not sending the following error came like........................ how to slove the problem The mail could...

Remaining Time Calculation

Thread by: mpolaiah, Jul 24, 2009, 1 replies, in forum: SQL Server 2005 General Developer Questions

Hi All, How to calculate remaining time like one day my shecudle is : DATE APPFROMTIME APP TO TIME 07/24/2009 12:18:00 PM 1:18:00 PM 07/24/2009...

Job Creation Problem

Thread by: mpolaiah, Jul 23, 2009, 1 replies, in forum: SQL Server 2005 General DBA Questions

when i going to create a new job, after i click on "OK" prompt up this error msg.... [ Unable to cast object of type...

Job creation problem

Thread by: mpolaiah, Jul 23, 2009, 1 replies, in forum: SQL Server 2005 General Developer Questions

when i going to create a new job, after i click on "OK" prompt up this error msg.... [ Unable to cast object of type...

SQL Server Agent: Unable to cast object of type â€˜SimpleObjectKeyâ€™ to type â€˜JobObjectKeyâ€™.

Thread by: mpolaiah, Jul 22, 2009, 1 replies, in forum: SQL Server 2005 General Developer Questions

Hi All, i am using Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation...

How to create job and schedule it run on daily basis

Thread by: mpolaiah, Jul 22, 2009, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi all, i am using sql server 2005 How to create job and schedule it run on daily basis. here my table run at on daily 1AM then select the...

How to create job and schedule it run on daily basis

Thread by: mpolaiah, Jul 22, 2009, 2 replies, in forum: SQL Server 2005 General Developer Questions

Hi all, i am using sql server 2005 How to create job and schedule it run on daily basis. here my table run at on daily 1AM then select the records...

How to write for trigger

Post by: mpolaiah, Jul 22, 2009 in forum: SQL Server 2005 General Developer Questions

how to write procedure or job plz help me Adriaan.

How to write for trigger

Thread by: mpolaiah, Jul 21, 2009, 4 replies, in forum: SQL Server 2005 General Developer Questions

Hi All, i am using sql server 2005 how to write trigger for each day when time is 1AM then automatically fire on my table then select...