-
- copying tables DTS vs SSIS - speed!!!
by Kolf
- 9 Replies
- Last post
by Jamie Thomson
- Hi, I'm trying to create a package with SSIS to replace the DTS process that we have in place already. DTS package copy four table content from one server to another. I have created a simple SSIS to do the same processes but the process it alot slower than DTS!! I did ran the SSIS package using ctrl+F5 and also from command prompt but still it's quite slow. SSIS uses SMO to access to server and bo
-
- Ignore Duplicate over linked server
by emarkovi
- 2 Replies
- Last post
by emarkovi
- Hello,
I am trying to insert rows to a table with a unique index that has the ignore duplicate property.
My program is running fine if running locally but the entire transaction failed if it is over a linked server.
The following is an example:
create table t1 (c1 int,c2 int)
create unique clustered index i1 on t1 (c1) with IGNORE_DUP_KEY
if running locally :
s
-
- suppressing subreport based on some condition
by Rohitb
- 2 Replies
- Last post
by a_shyam41
- I have one main report which has 5 subreport. i dont want to show all the sub reports all the time. i want to suppress any subreport based on some conditioned. can i do it in case of the SSRS. How
-
- grouping on date without time
by VSempoux
- 11 Replies
- Last post
by virtual
- Hello,
I have the following problem.
I a making reports based on a database that i do not control.
In that database i have a table with statistical data including a field with datetime informtion.
The format of the data I receive is "5/04/2007 7:43:27".
In my report i want to create a group which groups my event by date : "05/04/2007"
In my output i al
-
- Changing the ownership of a object
by jkmurty
- 2 Replies
- Last post
by Jens K. Suessmeyer
- Hi all,
I have a problem while executing a stored procedure. I have created a database called "cpd" and created some stored procedures. for all my stored procedure the owner is "CPDUSER". when ever i am executing any stored procedures i have to write the user name first else it is not working.
let's say i have a stored procedure called "cp_checklogin". it tak
-
- Help:Complex sql query
by Erhan
- 4 Replies
- Last post
by Umachandar Jayachandran - MS
- Hi "Product" Table ProductID ProductName 1 Cellphone1 2 Cellphone2 3 Cellphone3 "Features" Table FeatureID FeatureName 1 GPRS 2 Radio 3 Camera "ProductFeatures" Table ProductID FeatureID FeatureDescription 1 1 available 1 3 5 megapixel 2 1 available 2
-
- BULK INSERT: marked for deprecation?
by fleo
- 9 Replies
- Last post
by Matt Masson - MSFT
- I read in Microsoft SQL Server 2005 Integration Services by Kirk Haselden that the BULK INSERT task was provided for backward compatibility and its use is disrecommended.
But after looking on the web I cannot find information supporting this.
Do you think the BULK INSERT task should be used for new development
Thanks
-
- Connect to SQL named instance from another domain
by PalMavin
- 2 Replies
- Last post
by Jayanth J Kurup
- Hi,
I have two domains setup with two way trust in place. SQL server 2005 is installed in domain A.
Is it possible to log in to SQL server using machine account of a machine in domain B
I have been told that you cannot access SQL server from another domain using machine account. But I cannot find any resource or references about it.
If this isn't the right MSDN forum for this I apolog
-
- Repetitive tasks across databases
by dhaveedh_Joe
- 4 Replies
- Last post
by Chris Howarth
- Does anyone have any piece of sql that can help with the following.
1. I have to perform repetitive tasks across about 13 databases on 13 different servers involving
a. Alter table drop constraint
b. Alter table drop column
Is there anyway i can pass the database connection details into a procedure and run the task from one database and execute these tasks
This means I d
-
- SQL database restore
by Zombie9
- 6 Replies
- Last post
by oj
- I have to restore a database that i got in the form of a .bak file. The file is 7.5 gigz big and after i started the restoring it only shows that its restoring. how long does it take to restore a database this big Using sql server 2005
-
- First CTP and spatial
by Konstantin Kosinsky
- 7 Replies
- Last post
by Gail Erickson [MS]
- I just download and install first CTP. When I execute query
Code Snippet
select * from sys.types
i don't see any spatial data types
May be i do something wrong Or spatial unsupported in first CTP
-
- SQL does not install
by Verles
- 4 Replies
- Last post
by Verles
- What is this as I get this from both SQL Server 2005 Express as well as Office Accounting Express 2007. And I get no help from anybody on the phone at Microsoft.
TITLE: Microsoft SQL Server Setup ------------------------------
SQL Server Setup cannot install files to the compressed or encrypted folder: c:\Program Files\Microsoft SQL Server\. To continue, make sure that your installat
-
- Previous Month To Date Calculation
by AdamAtAirNWater
- 14 Replies
- Last post
by Deepak Puri
- I am currenty attempting to add a calculation to get previous month to date calculation. I currently have the following calculation in to calculate previous Year to Date and am having trouble adapting it. Any help is appreciated. Please note I am fairly new at this. Previous Year To Date: ([Time Calculations].[YTD Pr Yr]= Aggregate( Crossjoin({[Calendar Year].[Current Period]}, PeriodsToDa
-
- We are hiring in Service Broker
by Rick Negrin
- 0 Replies
- Last post
by Rick Negrin
- The SQL Service Broker team is looking for talent!
If you think SQL Service Broker is an interesting technology and you want to contribute to its success then come and join us!
As a member of the SQL Service Broker team you will have an opportunity to shape the evolution of service broker and get to work with an incredibly talented team of systems engineers.
SQL has beco
-
- Returning Table (rowset) from Dynamic query
by IsmailErhan
- 9 Replies
- Last post
by IsmailErhan
- I would like to prepare a query from the arguments of the function and have a return rowset as the result of the prepared query:
To simplify the matter the following prepares a simple query
create function Test(-----------)
Returns @ResultSet Table
(
au_lname varchar(40)
)
AS
Begin
declare @sql varchar(500)
select @sql ='insert' + @ResultSet + 'select au_lname from
-
- Truncation Warning
by BigHairyMonkey
- 4 Replies
- Last post
by BigHairyMonkey
- Hello,
I'm having a problem with one of my packages due to a truncation warning that I can't get rid of. It's not the end of the world, because the package still works. It's just extremely frustrating.
The problem arises in a derived column item in a data flow task. There is a postcode field in the data flow which has space for 20 characters. I create a derived column from this which
-
- Hello? Left Join?
by Telos
- 7 Replies
- Last post
by DanR1
- Am I missing something I thought LEFT JOIN made the first table return a value even if there was nothing in the second table. Yet this query:
SELECT b . name , isnull ( c . call_no , 0 )
FROM business b
LEFT JOIN call c ON b . business_id = c . service_business_id
WHERE b . business_id = 1000634
AND c . create_time BETWEEN @startDate AND @endDate
I
-
- rsReportNotReady Error
by shao
- 14 Replies
- Last post
by SonosDataGuy
- I have rs2005 installed. I created some reports through SQL Server Business Intelligence Development Studio. I can preview reports fine in the studio. But after deploying it, on //localhost/reports, when I click the report, it takes a while to calculate and then give me error: "An internal error occurred on the report server. See the error log for more details. "
The weird thing is if
-
- Do I need these OLEDB properties when opening a database?
by J Shaddix
- 2 Replies
- Last post
by J Shaddix
- Howdy folks! If I set the following three properties when creating a database, do I need to set the same properties when I open the same database later sscedbprop[0].dwPropertyID = DBPROP_SSCE_AUTO_SHRINK_THRESHOLD; sscedbprop[0].dwOptions = DBPROPOPTIONS_REQUIRED; sscedbprop[0].vValue.vt = VT_I4; sscedbprop[0].vValue.intVal = 100; sscedbprop[1].dwPropertyID = DBPROP_SSCE_MAX_
-
- Column space utilization
by Navaneeth
- 6 Replies
- Last post
by Marcel van der Holst - MSFT
- Hello I created a table with column name "description" as varchar(8000) . My doubt is if I am not storing 8000 characters in this column, will SQL Server use memory space needed for 8000 characters or will it use only the space that needs for my text. Thanking You Navaneeth
-
- how to import MySQL data into SQL2005
by khanhmy264
- 0 Replies
- Last post
by khanhmy264
- Hello everybody, I'm a new SQL2005 user. I'm trying to import data from MySQL version 5x into my SQL2005 by wizard. I created a DNS file and tested successfully using MySQL Connector/ODBC v5. Everthing seems fine but at the last step selecting data source. The SQL2005 wizard forced me to choose using SQL command option instead of selecting tables/views from a list. Anyone can tell me why My coll
-
- How one can genrate objects scripts with DROP and Create in same file in SQl Server 2005 Like in SQl Server 2000?
by adrshen
- 4 Replies
- Last post
by adrshen
- Hi seniors,
i oftenly genrate scripts of stored procedures and save that code in a txt file,in develpment envoiments its very crucial becuase to overwrite stored procedures any other developemt db.
For my this task sql server 2000 was very good it genrated drop and create statmentments implicity.But now in sql server its very difficult and in our development envoirment there are mo
-
- SQL BI Development Studio
by TausifAlam
- 1 Replies
- Last post
by Satya SKJ
- Hi Good day,
Seeking for help to resolve the issue about BI Development Studio (BIDS) installation.
Whenever I try to install, it says BIDS is already installed in my system. However, when I go and check it at Visual Studio .net Professional, I cant find it out.
I get following error:
Name: Microsoft SQL Server 2005 Tools
Reason: Your upgrade is blocked. For more in
-
- MultiLanguage data in cube
by vandewst
- 2 Replies
- Last post
by vandewst
- Hey,
I have a cube with al lot of translations for company names.
The structure of this cube is:
- company_translation (key)
-language (en, nl, fr, ....)
-company_name_translation (the translated companynames)
Now what I want to do is: Whan set the translation of my cube to English, I want only to return the English translations, when I set it to Dutch I only want to r
-
- Quick question to check NULL values in input parameters in a stored procedure
by MA2005
- 7 Replies
- Last post
by Umachandar Jayachandran - MS
- Hi:
I have a stored procedure that calls 3 stored procedures. If some of my input parameters are NULL, I would like to skip the call to another stored procedure. Can you someone please help me with this I would like to find out what is NULL, before I execute the other stored procedures. Thanks so much.
MA