-
- Checkpoint not being set? Log not truncating?
by graemeo
- 2 Replies
- Last post
by Vidhya Sagar
- Hi, I've set up a number of jobs (not a maintenance plan) via a script in SQL 2005. These jobs do the following: 1) Full backup every sunday night 2) Differential backup every weeknight 3) Log backup every hour The database is obviously in the full recovery model. The backups all seem to be running, with one issue - the log file is still growing and is not being truncated. I was under the impressi
-
- Collations in SSAS. How should it work?
by Vladimir Chtepa
- 4 Replies
- Last post
by Vladimir Chtepa
- Hi SSAS gurus,
Could you tell me, please, what collation gets a new dimension (cube), that collation isn't specified in create script, from Server collation or from data base collation In the MSDN there isn't clear information related to it.
If I create a new database from script, where only the collation of the database specified, all dimension and cubes get collation from server, but not f
-
- Calcaluting total nu of people based on their name field
by shamen
- 14 Replies
- Last post
by Adam Tappis - IMGroup
- I want to create a report which should be looked like this.
Members Joined
Members
Borrower
Depositor
Members Joined Yesterday
8
4
4
Members Joined Last 7 days
39
20
-
- Package execution stability ?
by Steve Wang 2006
- 14 Replies
- Last post
by Steve Wang 2006
- I am running into some issue that i have found any good clue on this forum... although have seen a few threads dicussions. I have a master package which invokes a dozen of child packages.
1) If I only open master package inside IDE, I am keeping getting the following error when i run the master packages inside Visual Studio 2005 IDE.
The connection type "FLATFILE" specified f
-
- Need sp_addlogin with CHECK_POLICY = OFF
by Gurpreet Singh Gill
- 4 Replies
- Last post
by Raul Garcia - MS
- Hi
We are using SQL Server-2005 as backend,
i had code like,
sp_addlogin 'a', 'a'
this give error as
"Password validation failed. The password does not meet Windows policy requirements because it is not complex enough"
as this is not full fill the Windows Password policy.
I too check the Local Security Settings is disable for the password settings.
I know i can us
-
- Connection Problem
by sureshv
- 10 Replies
- Last post
by sureshv
- I created a package with two oledb connections in the connection manager....which was running perfectly...later i deleted these connections and added two new connections....and applied these to task with the new connection..
Now i run the package i come up with the following error...connection not found
Error 1 Error loading test.dtsx: The connection "SQL-DEV.sql_dev" is not fo
-
- Script Task debug error
by jkline
- 8 Replies
- Last post
by Belsteak
- Good afternoon -
Info:
Microsoft SQL Server Management Studio 9.00.1399.00 Microsoft Analysis Services Client Tools 2005.090.1399.00 Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158) Microsoft MSXML 2.6 3.0 4.0 5.0 6.0 Microsoft Internet Explorer 6.0.2900.2180 Microsoft .NET Framework 2.0.50727.42 Operating System 5.1.2600
I am trying to deb
-
- log shipping in sql server 2000
by Bijal
- 3 Replies
- Last post
by Deepak Rangarajan
- hi,
i have log shipping between 2 servers on sql server 2000. the log shipping failed because of some problem with transaction log backup files. somehow the files are missing and it is not able to apply transaction log. can someone please tell me how can i restore the log shipping between 2 servers. please help asap..need to fix it in couple hours
-
- Getting the name of the updated table
by Craigster
- 14 Replies
- Last post
by Alphi
- I am writing a generic trigger in VS 2005 that selects records from the inserted table, and updates an audit table. I am, however, unable to retrieve the name of the table that the insert occurred on. I am using the following code to select the records, and obtain the name.. Can anyone offer any alternatives to accomplishing this task Thanks in advnace for any help you can provide.
Craig
Sql
-
- Unable to Connect to Report in Windows Form
by GNWebSoft
- 4 Replies
- Last post
by Bennymac78
- I have deployed report on my hosting server and now I want to access it using Windows Form ¨C Report Viewer Control.
Following is the code which I use.
public Demo()
{
InitializeComponent();
reportViewer1.ProcessingMode = ProcessingMode.Remote;
reportViewer1.ServerReport.ReportServerUrl = new Uri("https://rs.hoster.net");
rep
-
- nvarchar(max) gets truncated at 4000 chars(?)
by KitWest
- 11 Replies
- Last post
by Tom Phillips
- I¡¯m trying to call sp_ExecuteSQL with a query that exceeds 4000 characters.
DECLARE @sq NVARCHAR ( MAX )
DECLARE @from NVARCHAR ( MAX )
SET @sq = N 'SELECT Quite, AFew, Columns'
SET @from = N ' FROM NumerousTables WHERE LotsOfConditions=''very big query...'''
SET @sq = @sq + @from
PRINT @sq -- This appears truncated at 4000 chars in the Messages tab.
-
- Format expressions(converting seconds to minutes)
by raj416
- 1 Replies
- Last post
by raj416
- can any one tell me how to change seconds to minutes by using if condition in rss...
for example i have value of seconds=50, minutes should come like this 50/60=0.833333.... i got the answer ... but the problem is how to roundoff or truncate the minutes to 0.83 or 0.84 from 0.8333333...
Thanks in anticipation
raj
-
- Call Web Service From Script Task
by James Mac William
- 16 Replies
- Last post
by James Mac William
- I am trying to call a web service using the web service task and passing it variables, but even when I set variables to be Strings/any other data type, they always get passed out as objects. The call is then rejected based on the fact that there is no web service that accepts those parameter types. If there is a workaround to this problem, that would be great, otherwise I think I'm going to have t
-
- Copying procedures in SQL from one server to another using VBA in excel
by Aghajan1
- 2 Replies
- Last post
by Joe Webb
- Is there any sample code or help on trying to copy/replace views or prodecure in SQL or Oracle Im using VBA in Excel...
-
- Maintance Plan dbcc checkdb
by mmasnou
- 2 Replies
- Last post
by mmasnou
- Hi, When I exectue the maintance plan dbcc checkdb it doesn't do anything because it takes 1 second to do de check. Doesn't appers any error. When I execute the command in the query analizer it takes 2 hours to do the check. Can you help me Thanks, Marta Masnou
-
- How to interact with OLAP cubes within SharePoint Portal?
by Helen999888
- 6 Replies
- Last post
by Helen999888
- Hi, all experts,
I wanna know how can we interact with OLAP cubes (by dragging and dropping dimensions, measures from OLAP cube data) within SharePoint portal What web parts or what else we need to emmbed within sharepoint portal to achieve this
I am looking forward to hearing from you and thanks a lot for your help.
With kind regards,
Yours sincerely,
-
- AS2005 - Calculation Tab - DimensionMembers: MemberC = MemberB - MemberA
by Mastroyani
- 4 Replies
- Last post
by Mastroyani
- Hi to all,
I have one problem:
I have a dimensionshierarchy "Example" like this:
1
A1 B1 C1
2
A2 B2 C2
1 and 2 are parents.
C1 and C2 are dummy members, so I want to filll them
in the calculation tab with this formula:
C1 = B1-A1
C2 = B2-A2
That's what is standing now in calculation tab:
[Example].[1].[C1] = [Example].[1].[B1
-
- Record navigation
by LAT4551
- 4 Replies
- Last post
by LAT4551
- I have created a one-page client summary report. My problem is that I can only get the report to show one client and there are many. How do I add record navigation functionality to my report
-
- Round Up to next integer
by jschroeder
- 2 Replies
- Last post
by jschroeder
- Is there a way to round up a value to the next integer
For example 2.1 needs to be 3 and 4.9 need to be 5.
-
- Errors in the OLAP storage engine: The attribute key cannot be found
by mktexpress
- 4 Replies
- Last post
by mktexpress
- I'm somewhat new to using SQL server analaysis services so bear with me on this post.
I am getting the following error when trying ot process a simple cube I built:
Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_vwInvoice, Column: Invoice_x0020_Date, Value: 3/7/2004 10:00:00 AM.
This cube use an Invoice table as the fact table and then a &
-
- Getting Unique entire row records based on one unique column..
by den2005
- 12 Replies
- Last post
by den2005
- Hi,
I like to get all records(all columns) for any employee who has more than 2 unique SuggestedTraining..As simple as possible and execution (performance optimized) speed is as fast as possible.
Data:
Table structure below
Assessment Table
AssessmentID EmployeeID CourseID SuggestedTraining Date ....more columns 1 4 1 'Training 1' <date> 2 2 2 'Tr
-
- Displaying print statements of Stored Procedures in SSIS Logs
by Imtu
- 1 Replies
- Last post
by Phil Brammer
- Hi
I have few print statements in a stored procedure that gets called from the SSIS package. How do I make sure that these are captured in the SSIS log meaning how do I get them to be displayed in the Package Explorer window when running from the Business Intelligence Studio IDE.
-
- unable to attach a database to the MSDE instance
by GRK
- 3 Replies
- Last post
by GRK
- Hi I'm creating a database instance with the MSDE 2000 using the Command line(executing a batch File) and once the installation is finished(from the same batch file) I'm trying to attach a database to it. but the database is not attached to the database. but when I go to the sql server and register this new database and run the same command the database is attaching.
can any one suggest how to
-
- Data incorrectly repeating itself
by TJ Bernard
- 1 Replies
- Last post
by TJ Bernard
- I have run into a strange issue that I believe is a SQL Reporting Services issue.
I have a report laid out in landscape setting that has 4 columns of text. Two of the columns are sub-reports (due to the complexity and size, we did not flatten out the data in the stored procedure) and two of the columns are regular fields.
The 2 columns of regular fields are smaller, and normally only
-
- Sub query problem!!please help..
by loplayers
- 5 Replies
- Last post
by hunchback
- Table a
Testid CFPID
100 1004
Table b
CFPID Active
1004 1
the type of all coulmn is varchar(Max)
When i execute this query, the reult is none, is this query wrong
SELECT Active FROM b WHERE b.CFPID = (SELECT a.CFPID FROM a WHERE a.TestID = '204')
The result is nothing...then i prefer the result is 1.