Need A Partition Management Software Work On Serve

Jun 23, 2008

Is there any partition management software recommeded? I need to run it on server system.
The price of PQ is too high,is there anything cheap available?

I find a software Partition manager on www.recovery-soft.com, is there any suggestion?

View 1 Replies


ADVERTISEMENT

SQL Server Management Studio - Connecting To Serve

Sep 20, 2007

I am trying to connect to a sql server 2005 server using either the SQL Server Management Studio program using either windows auth or sql server auth but I can not. When I click on the connect button to connect to a server it never connects. I can not cancel once I press connect. It never times out after I press connect. I removed all registered servers that were registered previously. I have uninstalled all software that involved sql server (and sql2000) run a registry cleaner(not microsofts), installed the software to a new directory and still I can not connect to the sql2005 server (the only db).


I tested the connection from my machine to the production database system using osql and it worked fine. I registered the server tested the connection (using the management studio) and it tested fine. When I try to connect to the database engine it does not work.


When I had another user login to my machine and launch the SQL Server Management Studio I noticied that it ran a configuration utility for first use. When I uninstalled the SQL Server Management Studio on my machine it never came up again. Is there any way that I can get the configuration utility to run again on my account?

Any ideas? Things to test?

View 1 Replies View Related

Can't Get Diagrams To Work In SQL Management Studio

Nov 12, 2005

I can't get diagrams to work in SQL Management Studio. When I try to open that folder in the object browser, I get:

"Database diagram support objects cannot be installed because this database does
not have a valid owner.  To continue, first use the Files page of the Database
Properties dialog box or the ALTER AUTHORIZATION statement to set the database
owner to a valid login, then add the database diagram support objects."

That's great, but what exactly constitutes a "valid login" and who or what is it supposed to be?

View 8 Replies View Related

Function That Works In Sql Server Management Studio Does Not Work In Derived Column Transformation Editor

May 12, 2007

Hi

I'm a relative SQL Server newbee and have developed a function that converts mm/dd/yyyy to yyy/mm/dd for use as in a DT_DBDATE format for insert into a column with smalldatatime.



I receive the following erros when using the function in the Derived Column Transformation Editor. First, the function, then the error when using it as the expression Derived Column Transformation Editor.



Can anyone explain how I can do this transformation work in this context or suggest a way either do the transformation easier or avoid it altogerher?



Thanks for the look see...

******************************

ALTER FUNCTION [dbo].[convdate]

(

@indate nvarchar(10)

)

RETURNS nvarchar(10)

AS

BEGIN

-- Declare the return variable here

DECLARE @outdate nvarchar(10)

set @outdate =

substring(@indate,patindex('%[1,2][0-9][0-9][0-9]%',@indate),4)+'/'+

substring(@indate,patindex('%[-,1][0-9][/]%',@indate),2)+'/'+

substring(@indate,patindex('%[2,3][0,1,8,9][/]%',@indate),2)



RETURN @outdate

END

********************************



And the error...



expression "lipper.dbo.convdate(eomdate)" failed. The token "." at line number "1", character number "11" was not recognized. The expression cannot be parsed because it contains invalid elements at the location specified.

Error at Data Flow Task [Derived Column [111]]: Cannot parse the expression "lipper.dbo.convdate(eomdate)". The expression was not valid, or there is an out-of-memory error.

Error at Data Flow Task [Derived Column [111]]: The expression "lipper.dbo.convdate(eomdate)" on "input column "eomdate" (165)" is not valid.

Error at Data Flow Task [Derived Column [111]]: Failed to set property "Expression" on "input column "eomdate" (165)".

(Microsoft Visual Studio)

===================================

Exception from HRESULT: 0xC0204006 (Microsoft.SqlServer.DTSPipelineWrap)

------------------------------
Program Location:

at Microsoft.SqlServer.Dts.Pipeline.Wrapper.CManagedComponentWrapperClass.SetInputColumnProperty(Int32 lInputID, Int32 lInputColumnID, String PropertyName, Object vValue)
at Microsoft.DataTransformationServices.Design.DtsDerivedColumnComponentUI.SaveColumns(ColumnInfo[] colNames, String[] inputColumnNames, String[] expressions, String[] dataTypes, String[] lengths, String[] precisions, String[] scales, String[] codePages)
at Microsoft.DataTransformationServices.Design.DtsDerivedColumnFrameForm.SaveAll()

View 3 Replies View Related

What Role Does Quotes Serve

Jul 11, 2013

This is what the crystal reports makes, when you enter the tables and link. I also have some sql that i pasted there without the quotes. THey both run. Only isssue I have is that my sql which is a view does not update on demand from the server. IOW, they enter a new row. and it's not immediatlyin the crystal report. I asked the user if he can logout and back in and he says that he doesn't have to do that with other crystal reports.

SELECT "OEIND94"."IDDOCD" AS INV_DATE,
"OEIND94"."IDORD#" AS ORD_NUM,
"OEIND94"."IDORDT" AS ORD_TYPE,
"OEIND94"."IDPRLC" AS PROD_FAMILY,
"OEIND94"."IDPR$C" AS PRICE_CODE,
"OEIND94"."IDCOM#",

View 1 Replies View Related

How To Find Out The ConnectionString For Sql Serve

Oct 24, 2006

In visual studio environment,I am going to find out the following value so that the project can connect to the database.

<add name=""
connectionString=""
providerName=""

/>

But how to do that?

View 1 Replies View Related

Connecting To SQL Serve 2000

Feb 25, 2008

Hello everyone I€™m trying to figure out a scenario, please help me out through your replies.

I have a server (ETL Server) ETL tool used is SQL Server Integration Services
And I have a source system with SQL Serve 2000 installed.
The problem I€™m facing in here is I€™m not able to get connect to my source system through connection manager.

I had developed few packages earlier but my source was oracle so I had installed oracle client in my ETL Server and got my source component connected to the source system.

Now I wanted to connect to sql sercer database in different server in network.

I would highly appreciate if you could help me out.
Thank you

View 8 Replies View Related

How To Take Backup From One Server To Remote Serve

Jun 12, 2008

Hi
I want to take backup of rapport database.
and copy those .bak files from this local server to remote server automatically.

can any one help me plzzzzzzz.........

Thanks in advance
Madhu.......

View 13 Replies View Related

Contact SQL Serve Database Engine Team

Aug 14, 2007

Is there any web sit or weblog for contacting SQL Serve Database Engine Team?

View 4 Replies View Related

Dont Service Broker And Replication Serve The Same Purpose When Used To Ship Data?

Dec 17, 2007

when shipping data from one place to another, without complicated merge needs, do service broker and replication differ in what they offer?

View 4 Replies View Related

SQL 2008 Developer Edition Management Studio Does Not Work For Compact Edition 3.5 Databases

Sep 27, 2007



I am attempting to use the SQL Server 2008 Developer Edition (Management Studio) to create/manage a Compact Edition 3.5 database. My problem is that I cannot even create/open the compact database in Management Studio. Any help would be GREATLY appreciated. TIA

Problem Creating the Compact Database:


Open 2008 Management Studio

From menu choose File | Connect Object Explorer...

Choose SQL Server Compact Edition as the Server type.

Choose <New Database...> as the Database file.

Browse to folder where file will be created (C:MyDatabase#1.sdf was used in my example)

Leave all other field as default selections OR make changes, either way it does not work.

Click OK.

At this point the OK button just becomes disabled and nothing happens.
Problem Opening An Existing Compact Database:

Open 2008 Management Studio

From menu choose File | Connect Object Explorer...

Choose SQL Server Compact Edition as the Server type.

Choose <Browse for more...> as the Database file and locate a ".sdf" file that I created using VS2008.

Enter password, if any.

Click OK.

The following exception is displayed:
TITLE: Connect to Server
------------------------------
Cannot connect to C:Documents and SettingsdarrinbMy DocumentsVisual Studio 2008ProjectsTestSQLCompactEdition35TestSQLCompactEdition35AFS.sdf.
------------------------------

ADDITIONAL INFORMATION: Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------
Could not load file or assembly 'Microsoft.SqlServerCe.Enumerator, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) (mscorlib)
------------------------------
BUTTONS: OK
------------------------------

View 1 Replies View Related

Creating A System.Management Assembly In Order For My Own Assembly To Work?

Aug 2, 2006

Hi

I am a bit paranoid about what I just did to my SQL Server 2005 with this CLR experiment.

I created a Class Lib in C# called inLineLib that has a class Queue which represents an object with an ID field.

in another separate namespace called inLineCLRsql, I created a class called test which will hold the function to be accessed from DB, I referenced and created an instances of the Queue class, and retrieve it's ID in a function called PrintMessage.

namespace inlineCLRsql{


public static class test{


public static void PrintMessage(){



inLineLib.Queue q = new inLineLib.Queue();

int i = q.queueId ;

Microsoft.SqlServer.Server.SqlContext.Pipe.Send(i.ToString());



}

}

}

to access this from the db, I attempted to create an assembley referencing inLineCLRsql.dll. This didn't work as it complained about inLineLib assembly not existing in the db. I then attempted to create an assembley for inLineLib but it barfed saying System.Management assembly not created.

so what I did is (and this is where I need to know if I just ruined sql server or not):

1- ALTER DATABASE myDB SET TRUSTWORTHY ON;.

2- CREATE ASSEMBLY SystemManagement

FROM 'C:WINDOWSMicrosoft.NETFrameworkv2.0.50727System.Management.dll'

WITH PERMISSION_SET = UNSAFE

3- CREATE ASSEMBLY inLineLibMaster

FROM 'D:inLineServerinLineLibinDebuginLineLib.dll'

WITH PERMISSION_SET = unsafe

4- and finally

CREATE ASSEMBLY inLineLib

FROM 'D:inLineServerCLRSQLinlineCLRsqlinDebuginlineCLRsql.dll'

WITH PERMISSION_SET = SAFE



Everything works after those steps (which took some trial and error). I can create a sproc like:

CREATE PROC sp_test AS

EXTERNAL NAME inLineLib.[inlineCLRsql.test].PrintMessage

and it returns the Queue ID

Is there anything unadvisable about the steps above?



Thanks for your help



M



View 1 Replies View Related

Can I Use SQL Server Management Studio Express To Work With SQL Server Everywhere?

Jun 14, 2006

Can I use SQL Server Management Studio Express to work with
this...SQL Server Everywhere?


I bought VS2005 Pro and installed everything, including the Developers edition
of SQL Server 2005.

I would love to play with this and try converting old Access desktop
applications.

Unfortunately I am unsure how to create and modify a new database for SQL Server Everywhere using SSMSE.


I have several tables that have a thousand records or so
used for €˜Look-Up€™ tables and really need a way to import those tables.

Working within VS2005 and manually creating tables just isn€™t
cutting the mustard here€¦

What can I do?

View 10 Replies View Related

SQL Express - When Connecting To SQL Server 2005, This Failure May Be Caused By The Fact That Under The Default Settings SQL Server Does Not Allow Remote Connections. (provider: Named Pipes Provider, Error: 40 - Could Not Open A Connection To SQL Serve

Apr 10, 2008

Hi,I have SQL Server Express Edition. I tried working out some ASP.NET Labs in my local system. Here is the link of the Virtual Lab which I tried. http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032286906&EventCategory=3&culture=en-US&CountryCode=USI recieve this error in my local system. An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)I tried working out solutions from various websites. But the no solution is effective. Could anyone help me in solving this issue.  

View 3 Replies View Related

Management Studion Express Alongside Full-blown Management Studio?

Oct 9, 2006

Is it possible to run both Sql Server Management Studio: Express and full blown side by side?

I am developing with the full blown product but would like to test Management Studio Express on the same box.
Is this possible?

Thanks

Eric

View 3 Replies View Related

SQL Server Management Express Studio Management Tools

Apr 5, 2007



I have recently installed the SQL Server Management Studio Express but I do not find Management Tools in order to create scheduled backups and shrinking of the databases. I was under the impression that this should be included in the Management Studio. I use the SQL 2005 Express for smaller customers who run the SQL on a desktop unit. I need a way to backup the data to a server machine for backup purposes. I have uninstalled and reinstalled to no avail.

View 7 Replies View Related

Help On Partition

Jul 6, 2006

i have a table named table1 sitting on a a partittion scheme px.

table1 is partitioned on u_id by tens,

first partion u_id=0 to 9

second partion u_id=10 to 19

third partion  u_id=20 to 29

ans so on and so forth

 

i have a table named table2 with

records having u_id = 13 to 16

obviously belonging to the second partion.

 

i want to load table2  to table1 as fast as i could with

the following requirements:

all contents of partition 2 of table1 must be deleted before loading

table2 ceases to exist after the operation

how will i do that.

 

thanks.

 

 

View 1 Replies View Related

Help With Partition

May 15, 2008

Hi All,

Can someone take a look at my code and tell me what i'm doing in wrong. The script runs fine but when i go to table property it says the table is not partitioned. Thanks for your help.


create database [mypartition]
go

--CREATE FILEGROUP
USE [mypartition]
GO
ALTER DATABASE mypartition ADD FILEGROUP Y2000_filegroup
ALTER DATABASE mypartition ADD FILEGROUP Y2001_filegroup
ALTER DATABASE mypartition ADD FILEGROUP Y2002_filegroup
ALTER DATABASE mypartition ADD FILEGROUP Y2003_filegroup
ALTER DATABASE mypartition ADD FILEGROUP Y2004_filegroup
ALTER DATABASE mypartition ADD FILEGROUP Y2005_filegroup
ALTER DATABASE mypartition ADD FILEGROUP Y2006_filegroup
ALTER DATABASE mypartition ADD FILEGROUP Y2007_filegroup
ALTER DATABASE mypartition ADD FILEGROUP Y2008_filegroup
ALTER DATABASE mypartition ADD FILEGROUP Y2009_filegroup


--CREATE FILES
USE mypartition
GO
ALTER DATABASE mypartition
ADD FILE
(NAME = mypartition_detail_2000,
FILENAME = 'F:ss_datadatadetail_2000.ndf',
SIZE = 2MB)
TO FILEGROUP Y2000_filegroup;
ALTER DATABASE mypartition
ADD FILE
(NAME = mypartition_detail_2001,
FILENAME = 'F:ss_datadatadetail_2001.ndf',
SIZE = 2MB)
TO FILEGROUP Y2001_filegroup;
ALTER DATABASE mypartition
ADD FILE
(NAME = mypartition_detail_2002,
FILENAME = 'F:ss_datadatamdetail_2002.ndf',
SIZE = 2MB)
TO FILEGROUP Y2002_filegroup;
ALTER DATABASE mypartition
ADD FILE
(NAME = mypartition_detail_2003,
FILENAME = 'F:ss_datadatadetail_2003.ndf',
SIZE = 2MB)
TO FILEGROUP Y2003_filegroup;
ALTER DATABASE mypartition
ADD FILE
(NAME = mypartition_detail_2004,
FILENAME = 'F:ss_datadatadetail_2004.ndf',
SIZE = 2MB)
TO FILEGROUP Y2004_filegroup;
ALTER DATABASE mypartition
ADD FILE
(NAME = mypartition_detail_2005,
FILENAME = 'F:ss_datadatadetail_2005.ndf',
SIZE = 2MB)
TO FILEGROUP Y2005_filegroup;
ALTER DATABASE mypartition
ADD FILE
(NAME = mypartition_detail_2006,
FILENAME = 'F:ss_datadatadetail_2006.ndf',
SIZE = 2MB)
TO FILEGROUP Y2006_filegroup;
ALTER DATABASE mypartition
ADD FILE
(NAME = mypartition_detail_2007,
FILENAME = 'F:ss_datadatadetail_2007.ndf',
SIZE = 2MB)
TO FILEGROUP Y2007_filegroup;
ALTER DATABASE mypartition
ADD FILE
(NAME = mypartition_detail_2008,
FILENAME = 'F:ss_datadatadetail_2008.ndf',
SIZE = 2MB)
TO FILEGROUP Y2008_filegroup;
ALTER DATABASE mypartition
ADD FILE
(NAME = mypartition_detail_2009,
FILENAME = 'F:ss_datadatadetail_2009.ndf',
SIZE = 2MB)
TO FILEGROUP Y2009_filegroup;


--CREATE PARTITION FUNCTION
USE [mypartition]
GO
CREATE partition FUNCTION detail_part_function (varchar(10)) AS
RANGE LEFT FOR VALUES('2001','2002','2003','2004','2005','2006','2007','2008')
GO

--CREATE PARTITION SCHEME
USE [mypartition]
GO
CREATE PARTITION SCHEME detail_part_scheme AS
PARTITION detail_part_function TO
(Y2000_filegroup, Y2001_filegroup,Y2002_filegroup,Y2003_filegroup,Y2004_filegroup,Y2005_filegroup,Y2006_filegroup,Y2007_filegroup,Y2008_filegroup,Y2009_filegroup)
GO

-- Now just create a table that uses the particion scheme
USE [mypartition]
GO
/****** Object: Table [dbo].[partitioned_table] Script Date: 05/14/2008 09:44:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[partitioned_table](
[id] [int] NOT NULL,
[fiscal_year] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
CONSTRAINT [PK_partitioned_table] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON detail_part_scheme(fiscal_year)

GO
SET ANSI_PADDING OFF

View 7 Replies View Related

Partition On Value

Feb 9, 2006

I can see lot of documentation on Range Partitioning. Is there any other type of partition supported in SQL Server 2005?

For example, I have a Fact table having Billion rows. It has a column called BATCH_ID. A BATCH_ID corresponds to 10-20 Million rows and it is a running sequence number like 1,2,3 etc. (not an identity column). Is there anyway I can specify a partition function with BATCH_ID column as an int value? Will the SQL Server automatically does the partition on each int value in that case? If not, what is the best way to do it?

Thanks in advance for all help in this





View 3 Replies View Related

Os Partition Problems

Jul 3, 2004

Hi,
I recently installed MSSQL 2000 and sp3a onto a windows 2003 server in a test lab. I configured one big c: partion on this os and installed the db in the default location.

I need to detach the db's on this server and re-attach them onto another MSSQL 2000/sp3a server running 2003 os with a partition scheme like this:

c: = 20 gigs for the os
e: = 600 gigs for the data

I could not re-attach the db's onto the e:default path odatabase

Is there a work-around for this? This makes sense to me as to why it is not working and was an install oversight on my part but there has to be a way to overcome this delima?

Thanks in advance,
damnit

View 1 Replies View Related

Table Partition

Nov 22, 2005

Hi

Please help me how to do the Horizontal table partition??
I have to split the table in to multiple sub tables with same columns and less rows and then I have to use each sub table.

Thanks you in advance....

Regards
LakshmiPK

View 1 Replies View Related

PROCESS A Partition.

Oct 10, 2007

Hi everybody

Does anyone know where I can find code to PROCESS a Partition using DSO.

Thank a lot.

View 2 Replies View Related

Max() Over (partition By ) Gives Error

Mar 31, 2008

I keep getting this error:

Msg 156, Level 15, State 1, Line 12
Incorrect syntax near the keyword 'over'.


What am I missing? The max() over statement looks just like the statement in the documentation.

select RegistrationId,
OrderId,
Sequence,
Title,
InformalFirstName,
FirstName,
MiddleName,
Lastname,
EntryDate,
max(Sequence) over(partition by RegistrationId) as 'maxsequence'
from registration
where OrderId = '68379449583' and
Year = '2008' and
Active = 'Yes'

View 1 Replies View Related

Partition SQL Server

Aug 28, 2007

Hi,

I am using SQL Server 2000 SP3 Version 8.00.7.60. Can I create instances of SQL server 2000 even if it's already installed?

Thanks for your help in advance!

View 8 Replies View Related

Partition Function

Feb 25, 2008

Guys,

I have names in the database which I want partition by last name - for example last names starting with A, B, C, D should go to the file group 1. last names starting with E, F, G, H should go to file group 2.

I am trying to use the following function - but do I specify in the function that last names with with A, B, C, D should go to the file group 1

CREATE PARTITION FUNCTION myRangePF3 (char(20))
AS RANGE RIGHT FOR VALUES ('EX', 'RXE', 'XR');

Is there any way to modify partition function to accomplish this?

Any suggestions and inputs would help

Thanks

View 4 Replies View Related

Partition Table

Feb 27, 2008

All,

I have a partitioned table (1.7 billion rows) that is across 97 partions. The table is partitioned on datetime field.

When I query only this table with datetime field in where clause I see that cleary it outperforms the unpartitioned table.

When this table is joined to 3 tables it performs no better than
the non-partitioned table... it seems that the query does a partition scan.

The part. table has a 3 part composite clustered index and
a NC index on the partion field value.

Would appreciate any feedback.

thanks

View 3 Replies View Related

SUM(x) OVER (PARTITION BY Y) Supported?

Mar 7, 2008

SUM(qtycolumn) OVER (PARTITION BY columnA, Column B)

is this function supported by Sql Ce?

View 1 Replies View Related

Partition Setup For SQL 05 ??

Nov 14, 2007

HI all,

I am in the progress of migrating my 2000 install over to SQL05 and onto a couple of new boxes. I have 2 Dell 1850's to set up mirroring on and wanted to know your opinion on the best partition setup. The 1850's are a 2 disk machine so it has to be a RAID 1 setup. I am just unsure of the benefit of partitioning the logical drive to seperate the log files from the data files.

Should I partition the drive, a 300G SCSI into 2 partitions and keep the logs on one partition and the data on another? Can anyone tell me if there is a benefit to doing this?

If there is a more pratical solution can you explain?

Thanks in advance!

Jason
Sydney Australia

View 2 Replies View Related

How Does SQL Server Know Which Partition To Look At?

Mar 27, 2007

Most examples for SQL Server 2005 involve a sales table that you split based on date, i.e. sales records prior to 2000 go to this partition, and the ones after that go to another one. Nice and simple.

Say I have a sales table:

id Amount Date
1 10 1/1/1999
2 9.99 1/1/2007

Now then, I put all the records prior to 2000 in it's own partition.

So when I do something like this: SELECT * FROM Sales WHERE DATE = 1/1/1999
the SQL server will know which partition to look at. Very nice.

Now then, if I do this: SELECT * FROM Sales WHERE id = 1
How will the SQL server know which partition to look at?


Thank You!

View 5 Replies View Related

Truncate Partition

Oct 31, 2006

hi list

i have a table named stgBudgetFact, that is partitioned on DivisionID.

each DivisionID goes into its own partition, which is on its own file group.

the etl guru on the project wants to be able to truncate the partition, not do a delete from the table based on DivisionID.

Is it possible to truncate the partition somehow (remove rows where DivisionID = 3 for instance without ALTER DATABASE, where the medicine is worse than the disease) and then reestablish the partition so we can restart a failed load by division?

i really hope something like this is possible

thanks

drew

View 2 Replies View Related

About Partition Copy

Aug 30, 2007

hello,
I want to copy all or part data in one partition to another partition,how can I do?

View 5 Replies View Related

Partition Schema

Nov 29, 2007

Dear all,

Sorry if my post misplaced. I have a table that contain huge data so I made a partition function and partition schema. Unfortunately there's only one column to be allowed as a partition column whereas my queries using a few columns. Can we make many partition function that apply to one partition schema ? I search no result in SQL BOL.
Thanks in advance.

Best regards,

Hery

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved