I have a requirement in SSIS to connect to a remote ftp site, download all files to a local drive and then remove only the remote files that I've transferred. The file names will be different ...
I am recently unable to connect to connect to the MICROSOFT##SSEE SQL instance using SQL Management Studio. It houses my WSUS 3.0 databases. Upon starting the server I see this error in the ev...
GOAL
Need to set a variable (@LookupKeyFieldValue ) to a value looked up in database, where the lookup is accomplished like this:
select @LookupKeyFieldValue = [idContextHistoric] from [tlk...
I have just created a SQL Server 2005 Express instance running on Windows Server 2003.
I need to connect to this server over the internet using an ODBC connection. Although I am able to co...
Just installed SQL 2005...I am trying to setup a user so that they have a default database that I will use in the connection string in my .net ASP code...I have created the login, gave them ac...
When I created linked server in sql server 2005 for connecting Oracle server, I got the error message:
Cannot initialize the data source object of OLEDB Provider"OraOLEDB.Oracle" for the link...
This question is regarding SSIS:
I am trying to loop through a directory of directories that contain directories which contain files. i.e:
C:\databases\client1\client1.mdb
C:\databases\cl...
I want to import a files into a temp table and select a substring of the first record as the FileID. I then want to compare this FileID to the FileID column in my Pharmacy.PDEFileLog table. If...
How to send email notification from SQL 2005 without having to install MS Outlook on the server?
OS is Windows 2003
Thansk,
Kuntal
I'm trying to restore a back up database into sql server 2005. And I'm having an error message says;
"Too many backup devices specified for backup or restore; only 64 are allowed. restore dat...
Hi there I have a integer which is milliseconds representing a lap time
I would like to convert this to the hh:mm:ss.ms format to show the lap time properly using MSSQL or even vb.net
c...
I have the following query as attached below. Right now, if the story has 0 votes associated, instead or return voteN: 0 and voteB: 0 , it returns null or no results..
however if there is j...
IN MS Access I have a query to get time
AS
SELECT Now()-[intake_dt] AS [Time] FROM Table
How do I do that in SQLServer 2005
Hello,
I had a server crash on my old SQL2000 server. I was recover the database files and I attached them in a new SQL 2005 server. But I got only one problem. Most tables were created ...
Hello, I have a database that I incorrectly configured using a collation of SQL_LATIN_GENERAL1_CS_AS. Can someone please tell me how to change the collation to SQL_LATIN_GENERAL1_CI_AS? I ne...
How do I install 'Microsoft SQL Server Management Studio' on a Windows XP workstation? I want to have a user be able to manage SQL databases from their workstation so they dont need to use the...
Hi I Currently have a website that stores information like images and description of it to a database.
I can reterieve the image that is uploaded but what i want to do is reterieve multiple ...
Hi Experts,
Can someone please give me step by step clear instructions on how to recover a sql 2005 database using MDF and LDF files ?
Cheers
I know there have been plenty of people asking the same question, and I have tried to follow instructions and do what have worked for others. Problem is I dont seem to get it to work. It shoul...
Hello,
I have a C# App that accesses a SQL Server 2005 Database using SQLClient.I frequently back up, Detach and attach the database from Management Studio Express.
I am trying to figur...
When my default.aspx page loads I get this error for the connection to my SQL 2005 DB.
An error has occurred while establishing a connection to the server. When connecting to SQL S...
My server crashed due to SQL writing a lot of trace files, which filled the server disk, and caused the server to crash.
So my first question is: How do I disable creation of Trace files - as...
I currently have a functioning SQL 2000 Cluster in VMware ESX. Now, I would like to also install SQL 2005 on the same Cluster as a named instance. By the way, this is for testing.
I'm hav...
I am currently importing data back into a database after it was accidently deleted. However the source that I am importing from also contains data that still exists in the destination database...
i'm new to writing sql reports in visual studio. i'm coming from crystal reports....
i'm working in the Layout view of report design... i have a table and i right click on a square within ...
