Dear expert,
I am trying to make connection from SQL Server 2005 through OLE DB object in SSIS. How can I make the connection? What should I do on Oracle side?
Thanks!
I have a named Instance of SQL Server 2005 on a DELL Poweredge server running Windows Server 2003. I cannot get a connection to the instance from a desktop computer running Windows XP service ...
On my old (Sql 2000) box, there is an AD group in the Security folder named "ACME\Future Vision".
I want to add this AD group to my Sql 2005 server. How do I do that, exactly?
When I go...
Hi,
How do i retrieve Servername and Database name from a connection string? I need to save those values in variables and pass onto a URL.
Thanks
Ajmal
Hi have create a scalar-valued function name "fnGetHoursMinutesDateDiff". This function takes 2 arguments in parameter (StartTime and EndTime). The function return a deicmal (18,2) value.
H...
Hi all;
My problem is that I need to be able to create drop down values, free text and date picker on a datetime parameter in a SQL Reporting Services Report.
I can create the drop down l...
Using SQL 2005, we currently replicate data over secure VPN links. Is it possible / practical to replicate using port forwarding over the internet?
If so which ports should be used (TCP / ...
I have a text field that is a work log type field and each entry into this field contains a timestamp of when the entry is submitted. In SSMS and in Reporting services, the timestamp appears i...
Hi,
I have developed an application in dot net(visual c#) which connects to the sql server for databse using IP
130.146.39.182. , sql server authentication and dsn less connection string.It ...
What steps am I missing? I am logged on as Administrator so there should be no rights restriction. Is there a step by step setup I can follow?
I want to test for the existence of a view and, if it does exist, drop it.
Whether it exists or not, I then want to re-create it. I can do that as follows:
=================
use gmdemo
...
Do you happen to know how to remove a Carriage Return and or line feeds from a field when selecting for reports.
In the mm2po.sdesc field some of our users have entered the following:
F...
We have a large SQL project which we are setting up to use a cluster on SQL 2005, my question is what are the benefits of running multiple instances of SQL server on the cluster as opposed to ...
I'm using Business Intelligence Development Studio in Visual Studio 2005 environment.
I have data where the field AName repeats and I only want the first record. I thought the following co...
I am trying to execute a stored procedure from a VBScript. The stored procedure works from within a query window as shown:
exec msdb.dbo.sp_send_dbmail @profile_name = 'DBMail'
...
We are creating fairly complex views in MS SQL Management Studio. When I go over a certain number of fields requested or a certain number of rows, I get the Timeout Expired error after 30 sec...
For a SQL Server 2005 database with a table called tblNews, I want to insert a chunk of HTML.
I wrote a Stored Proc, AddNewsArticle as shown below.
To test the stored proc, I grabbed a ch...
I am installing MS SQL Server 2005 on a VMware VM server. I want to set up C: and D: partitions so that the OS is on C: and SQL is on the D: drive.
How much space do I need just to install...
When I select a date using SELECT GETDATE() the return value is 2008-09-18 14:04:19.760. How can I return this back as 20080918140419?
HI,
I've just set up a new system and I forgot to name all of my procedures with the usual sp_ prefix - not that it matters but I'm a stickler for details ;|
Does anyone know how I can a...
We have two databases, set up as a merge replication. One database recieves data from the 'outside world', the other database simply pulls the data from this database every minute. When our sy...
Hi Experts,
I got a database in Sql 2005 in which I need to make an updation to syscolumns table but I am getting the following error
Ad hoc updates to system catalogs are not allowed 2005...
Using SQL Server 2000. I have table containing resumes posted to "one" field within it. Within that field there are some resumes with multiple HTML tags in each record and other resumes wit...
I am looking for MDX expression that can give me value of a measure for prior full quarter.
I have a measure called [Measures].[Amount] and date hierarchy [Cal YMD] in [Accounting Date] Dimen...
During the setup of SQL 2005 in a cluster I receive an error message that states "sql server setup was unable to add user" domain\admin to local group domain\serveragentadmin. The admin user ...
