Hi..
basically I want to execute the SQL file from my client application. I need a T-SQL statement to execute the temp.sql file.
Thanks in Advance..
Hi All,
I developed SSIS package in sql server 2005 where my need is to import rows from text file to database table.my column deliminator is ";" but due to some features that not carried f...
We are trying to figure out how to set up a load balanced SQL environment. Here is our situation:
We have two load balanced .NET application servers set up to interact with our primary databa...
The files in a Document Management system (DMS) are on a file share. The associated meta-data (properties) are in a database on an SQL server. For consistency of the DMS it is desireable that ...
I am trying to apply conditional formatting to a field in Reporting services. The field data type is DATE and I am trying get the text to turn the color red if the data is more than 72 hours o...
Hello, I'm trying to get my SqlConnection plugged on my local database.
I imported the database in C# Express, no need to say I also have SQL Express 2005 installed.
Since the file is ...
I have a strange SQL express 2005 question. We have installed SQL express 2005 as a back end for a work order tracking software system. The problem I am experiencing is that after the server ...
Hi,
I've got some work which involves reporting the time taken between completing 2 events. The way the business works is that there are various Trigger events which are used to start the ...
I have a query that returns all rows with a single identifier:
select ParentLink_RecId
from TASK
--where (RESOLVEDDATETIME) = 2008
Group by ParentLink_RecId
having count(Par...
Experts,
I'm building an SSIS package using the template from Visual Studio. I have my source and destination, but a table on the destination server is not showing up in my list of options...
I need to build an archive job for SQL 2000, sp4. The mechanics of the actual archiving are pretty straightforward, but I need to limit the archiving to data that older than the 1st day of the...
HI
I know that I can convert xml file to xml variable by (see code snippet 1)
The problem is that OPENROWSET does not allow the file name to be a variable (see code snippet 2)
How can I...
I'm trying to copy a set of tables from a sql server 2000 db to a 2005 db. I've been using enterprise manager but it wont connect to the 2005 db. I've got MS SQL server management studio exp...
I have a query that returns income for each year
2004 950 1713.513513513513513 ABC
2005 786 12327.777777777777777 BBB
2005 950 20562.162162162162156 ABC
2006 786 21133.3333333333333...
I have this code, which is showing error
SELECT DISTINCT JobNo FROM #UpdateReceiving (INDEX(XI_UpdateReceiving), NOLOCK)
Error:
Msg 1018, Level 15, State 1, Line 1
Incorrect syntax near 'I...
We have installed a new Windows 2003 server on an existing system. This unit replaced an older one with SQL 2005 running on it along with the Great Plains software. We could not locate the pro...
I want to import ~100 tables from MS Access database but I get "Too many sessions" error message.
I want to use "Optimize for many tables" check box on "Select Source Tables And Views" dialog...
Hi, this is my first ever question on Experts Exchange. Please be kind.
I have a client running MSSQL 2005. It looks as though someone has restored a rather old backup of one of the live da...
I need SQL query language statement help
I need to update a field in one table with the value of a field in another table using a query statement where both tables have a common employerID, e...
I need to get a list of MAC addresses out of a database but they're in this format "001873c0a822" and I need them in this format "00:18:73:c0:a8:22"
Is there a way to do this with the sql q...
Can I disable interactive logon for the SQL server service accounts?
Hi Folks,
What is the latest version of MDAC.
How can I check my computer has the latest version
Is it possible to alias a database name in SQL 2005 or 2008? I know you can alias instance names and I know you can create synonyms on database objects, but I need a way to abstract the datab...
what permissions other than sysadmin do i need to execute the following statement.
DECLARE @xml XML
SELECT @xml =CONVERT(XML, bulkcolumn, 2)
FROM OPENROWSET(BULK '\\SERVERC\SHARE\PATH\DA...
need to delete some rows in a table what is the script to do this
thank you
