-
- Which SQL Server 2000 Edition should I install in at UAT environment
by Lyn Duong
- 3 Replies
- Last post
by Lyn Duong
- Hi,
We have a suite of applications which go through the full product life cycle and I was wondering which SQL Server edition should be installed in every each environment from Proof of Concept -> Dev -> -> UAT -> Systest...
Production is straight forward but I am just not sure about all the other environments.
thanks
Lyn
-
- Error processing Cube - The syntax for ',' is incorrect.
by RafOv
- 1 Replies
- Last post
by Darren Gosbell
- Hi guys! Could you help me with the next problem:
Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Query (1, 10) Parser: The syntax for ',' is incorrect.
I have installed sql2005 sp2, but didn't get much
Pls. help
-
- Rerunning failed subscriptions
by eksplorer
- 0 Replies
- Last post
by eksplorer
- We're using RS2005 SP1. One of our users has subscribed to a report to run the 15th of each month. This past July 15 was on a Sunday and our servers were down for backing up & maintenance. Since the servers were down, the job never ran and the user did not receive the report they were expecting
Is there anyway to have jobs that failed to run because a server was down automatically run w
-
- SQL Server Data Migration and Synchronization
by Ritesh581042
- 8 Replies
- Last post
by MohammedU
- Hi,
I need to move my database servers from one location to another. The issue is that I have over 200 databases to move and my clients can't afford a downtime. The collective volume of all the databases is over 2.5 TB and growing.
I am thinking to copy these databases in batches over the WAN to the new location and replicate them using Transactional replication till I have all the d
-
- Different Font size when browsing and printing a report ?
by Aiwa
- 2 Replies
- Last post
by Aiwa
- Hi all,
Is it possible to setup different font size when a user is browsing or printing a report
I have a lot of data to print on a report and i need tu use a font size of 7pt which is fine for printing but when the user is looking at the report on the browser a font size of 7pt is a bit too small and the bold doesn't work.
Tia
-
- Analysis Services - Step by Step: Errors related to feature availability and configuration
by R Pham
- 4 Replies
- Last post
by rt
- On page 56 of SQL Server 2005 Analysis Services Step by Step, I tried to DEPLOY the project, and it failed with this msg:
Errors related to feature availability and configuration: The 'Measure expressions' feature is not included in the 'Standard Edition' SKU.
Is it because of my Standard Edition If it is, could I change the 'Measure expressions' some how to get by this msg and go on with t
-
- SSIS Job Failed
by renching
- 14 Replies
- Last post
by matilda16
- I created a simple SSIS package. I build the package. I can run the package with no problem.
However, when I schedule a job, the job always fail. Does anyone know what is the problem
The error message of the job doesn't help at all. Here is the error message I got from job history:
Date 5/19/2006 2:02:21 PM Log Job History (ssistest)
Step ID 0 Server ABC Job Name ssistest Step Name
-
- Creating a Mobile Application with SQL Server Compact Edition
by salustrg
- 4 Replies
- Last post
by salustrg
- Hello!!
I completed that example that I pasted in the subject part and when I try to synchronize my mobile database, the data from the server appear in my pocket pc; but when i refresh the data on my pocket pc they do not show on the server.
Can anyone give me a hand
thanks
-
- Use of a SSIS variable of type ˇ°Objectˇ± inside Script Component and Task Component
by SabAlo
- 3 Replies
- Last post
by Cho Yeung - Microsoft
- In a Data Flow, I have the necessity to use a SSIS variable of type ˇ°Objectˇ± inside Script Component and assign to it the content of 'n' variables of string type.
On exiting from the script the variable of type object should contain something like in the following lines:
AAAAAAAAAAAAAAAAAAAAAAAAAAAAA BBBBBBBBBBBBBBBBBBBBBBBBBBBBB CCCCCCCCCCCCCCCCCCCCCCCCCCCCC DDDDDDDDDDDDDDDDDDDDDD
-
- How to debug CLR SP using Visual Studio 2005?
by Alexey Yeltsov - MSFT TAP cust
- 1 Replies
- Last post
by Alexey Yeltsov - MSFT TAP cust
- We know that automatic deplyment is currently broken.
How does one debug the stored procedures in this case
Thanks,
Alexey
-
- reporting and monitoring
by redwood739
- 2 Replies
- Last post
by redwood739
- Hey all I am new here and fairly new to SQL server. And yes i have a question, that maybe dumb. My boss wants me to reporting to him the health of the DB each week. So here are a few questions. 1. What really defines the "health" of a DB What elements should I be reporting to him 2. Is there any utilities out there that would be helpful or can SQL provide enough info 3. I am using 2005 s
-
- SQL 2005 Query Analyzer
by matthew schmitt
- 4 Replies
- Last post
by Arnie Rowland
- I just installed SQL2005 Workgroup edition. How do I install Query Alayzer to go along with this
-
- "Can't find PInvoke DLL 'dbnetlib.dll'."
by hopjes
- 1 Replies
- Last post
by Ilya Tumanov
- every time when I opened the connection from my windows CE4.2 device to sql server I got the error "Can't find PInvoke DLL 'dbnetlib.dll'.
My OS is MS CE4.2, I've installed Compact Framework 2.0 and SQL client. It worked fine at OS CE5.0 but not at CE4.2. My application is working correctly, but when I started the connection I received this error.
Any idea
thanks, Jan
-
- Number of reads in Profiler is not the same when running the same SP on different PCs
by ALEXTT
- 5 Replies
- Last post
by ALEXTT
- I'm running the same query on two different PCs and tracing results in Profiler on my PC. When executing the query on PC1 - the total number of reads is 200000. When executing the same query on PC2 - the toal number of reads is 13000. It is almost 15 times more reads when executing query on PC2. The executed query is same on PC1 and PC2. Any reason for this
I'm trying to analyse that query
-
- Problem when exporting data into Excel file from SSIS
by Sandra2006
- 3 Replies
- Last post
by DouglasL
- I have problems when exporting data into Excel file from SSIS. It all works fine with numeric columns but an apostrophe is attached at the beginning of each text cell. I tried using derived columns and data conversions but it didn't work. It seems to me that problem is in 'excel destination' task... I saw many people had this kind of problems too... Is there any solution possible
Thanks.
-
- adding a new data flow item calendar transformer
by Joa666
- 11 Replies
- Last post
by Joa666
- http://www.microsoft.com/downloads/details.aspx familyid=e603bde7-44bb-409a-890f-ed94a20b6710&displaylang=en#top
I've downloaded this and installed it but i seems to fail to get this item into my data flow items list. i've read the readme.txt but i think the part where they explain the build is poorly explained.
For example - Place gacutil.exe (packaged with Visual Studio) on the sys
-
- Find and delete reversed key pairs.
by pawel.krakowiak
- 5 Replies
- Last post
by pawel.krakowiak
- Hi!
I have a table with only two columns, which contain some city codes in the form of AAA, BBB. What I need to do is to find reversed key pairs in the same table and get rid of them so only one pair stays. In example, I have:
AAA, BBB
CCC, DDD
BBB, AAA
EEE, FFF
FFF, EEE
DDD, CCC
AAA, BBB and BBB, AAA mean the same to me, so I would like to leave only one of the
-
- Can I create a database schema from a DataSet and/or .xsd file?
by hwatson
- 3 Replies
- Last post
by Ilya Tumanov
- I have some questions about creating SQL Server CE databases. Based on my experiments and what I've read on these forums, it looks like there are a couple ways to create a database schema. I can edit the database schema via the Server Explorer in Visual Studio, or use an external program like SQL Server Management Studio and somehow convert those files to .sdf files.
I find Visual Studio's buil
-
- Can't reinstall sql server 2005 express
by Dolin8
- 11 Replies
- Last post
by Dolin8
- Hi I installed SQL server 2005 Express and it was successfully set up but I kept on getting error 26 when I try to connect to a database, so I remove all SQL programs from the control panel and reinstall SQL server 2005, but this time the set up stopped halfway saying "cannot start server". How can I successfully reinstall SQL server 2005 express
-
- How to protect my parameters
by Roy mm
- 4 Replies
- Last post
by Roy mm
- Hello. I have a report with parameter called "parm1", that gets a value of "true" or "false" depanding on another parameter. When the report is runnig the parm1 value is "false". How can I protect this parameter from a change by the user I mean - the user can run the report and then add to the url "¶m1 = true". Can I do anything against tha
-
- Check to see if file exist on server
by SBurden
- 6 Replies
- Last post
by SBurden
- Hi Folks,
I'm attempting to check to see if a file exists on our server before showing a link it.
I put this function in the Report Properties:
Code Block
Function isFile(PathFileName As String) As Boolean Return isFile = System.IO.FileExists(PathFileName) End Function
I chose a situation where I'm getting back two rows of data, one row is true
-
- error
by guddu567568
- 14 Replies
- Last post
by guddu
- hi i have one varchar field i m convarting that field to datetime in format of dd/mm/yyyy
but i m getting eror
select top 30000 CMS_Upload_Details_ID,Scheme_Code,DrCr, convert(varchar(10),cast(AdditionalField5 as datetime),103) 'ValDate' ,AdditionalField13 'dept_slip',AdditionalField14 'dept_dt',Cheque_No 'Instrm_No',Amount,CONVERT (varchar(11),Instrm_Date,103)Instrm_Date ,AdditionalFiel
-
- Formating
by AuliyaIkhsan
- 2 Replies
- Last post
by Kent Waldrop My07
- how to format an integer in sql 2005
for ex: 1.09876 i want to format to 1.1
in access i can use : format(field,'0.0') as field1
thanks
-
- sql cluster - fulltext error
by Anonymous576168
- 2 Replies
- Last post
by Anonymous
- We have a sql server 2000 active/passive cluster running on Windows Server 2003 and within the last 6 months have started getting the following errors which eventually cause the SQL Resource Group to failover.
An error occurred in the configuration monitor for instance <SQL Server Fulltext>: 80070005 - Access is denied .
SQL is at the latest service pack/hotfixes. (8.00.2187)
-
- MSSQLServerOLAPService Stops
by Brian312
- 1 Replies
- Last post
by clarkcj1
- MSSQLServerOLAPService Service seems to crash rather sporadically during our nightly ETL with the error of:
The description for Event ID ( 22 ) in Source ( MSSQLServerOLAPService ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this de