Is this bug with Convert?

I was trying to debug some DateTime.Now in a C# project and while debugging I found this.

In your Sql Management Studio, type this:

The 916 becomes 917. Why does my millisecond get screwed?

select convert(datetime, '2007-06-29 15:22:31:921') -- prints 2007-06-29 15:22:31.920

select convert(datetime, '2007-06-29 15:22:31:916') -- print 2007-06-29 15:22:31.917

That is because of the precision of the datetime data type 1/300 of a second. Check BOL for more info about datetime data type.

select convert(datetime, '2007-06-29 15:22:31:998')

go

AMB

Is there Limit to # of Matrixes Displayed in RDL?

I have a report that consists of 12 matrixes. In Dev Studio all the data for
all matrixes returns correctly, but when the rdl is on the Report Server and
the Report is run, the 12th ( last ) matrix only displays column group and
row headings, no detail data within the matrix cells. Also from within Dev
Studio when I export the report as a "Web Archive", the "web" page exported
displays incorrectly just like the report does on the report server. Why
does it not display the same as from within Dev Studio?
Thanks in advance.Found an incorrect non-zero value in the groups before row headers property
settings which was causing no data in the detail cells. No further help
needed.
"mike" wrote:
> I have a report that consists of 12 matrixes. In Dev Studio all the data for
> all matrixes returns correctly, but when the rdl is on the Report Server and
> the Report is run, the 12th ( last ) matrix only displays column group and
> row headings, no detail data within the matrix cells. Also from within Dev
> Studio when I export the report as a "Web Archive", the "web" page exported
> displays incorrectly just like the report does on the report server. Why
> does it not display the same as from within Dev Studio?
> Thanks in advance.

Is there any way to remove IDENTITY property on Table?

Is there any way to remove IDENTITY property on particular table? I tried removing IDENTITY property using Manangement studio, but this operation behind the scene use migration concept that is by creating tmp table and then populating with data; droping the orginal and renaming the tmp back to original.

Second, i want some kind of generic solution using certain system table like aya.sysobjects, sys.identitycolumn etc such a way that i should be able to remove the idenity property from all of the table accross a database.

Mandip

There are a couple of ways to 'remove' the IDENTITY 'property' of a field.

One is to :

make a duplicate table with or without the field that is IDENTITY -dependinp upon if you want to retain the current values or not,

copy the data from the old table to the new table,

DROP the old table,

RENAME the new table to the old table's Name.

|||

the first method i have already mentioned within my post... so i don't want... second sounds good.. i can use that methodolgy to create certain generic script to make changes across database.

Actually primary key is not concern.. as there is no primary key or index on those tables... in that particular DB...

thanks for help....

But still my question is is there any generic way/script to do this whole database level change....

thanks,

mandip

|||

But still my question is is there any generic way/script to do this whole database level change....

Nothing 'built-in'. You can write a script to do the 'deed'.

A query similar to this (SQL 2005) will give you a list of tables/columns that are IDENTITY.

SELECT

TableName = object_name( object_id ),

ColumnName = [name]

FROM sys.columns

WHERE is_identity = 1

Stuff the resultset into a #Temp table and cycle through it.

You'll have to use dyanmic SQL.

Is there any way of keeping all of a solution in one script project?

We do not have a source code control plug in for Visual Studio 2005 and I am trying to establish an efficient way of controlling versions of a solution I have created in BIDS, which includes SSAS objects plus an SSIS package.

As there are so many individual files for the dimensions, cubes, database, etc., it does not seem feasible to have them all checked in to our source control application and I was thinking of creating an Analysis Services Scripts project via SQL Server Mgt Studio where I could simply script out the SSAS database and the package and use these via the Deployment Wizard to deploy.

However -

a) according to BOL, an Analysis Services Scripts project has Connections, Scripts and Miscellaneous folders - when I create one, it has Queries instead of Scripts and when I script out the database I cannot see the xmla file in the project. Am I getting hold of the wrong end of the stick here?!

b) An SSIS package cannoy, I think, be scripted as such; when you deploy it creates the dtsx file and the SSIS DeploymentManifest file that installs the package, so is the best idea to keep these two files in source control?

Any advice gratefully received! Thank you

Rachel

I am a little bit surprised that your source control system has a limitation on number of files that affects you. In typical project you might have couple of dozen files, let's say up to a hundrend in a big solution - but modern source control systems can handle hundrends of thousands of files. Is there something here that I miss ?|||

In Visual Source Safe, part of Visual Studio, you do not check in and out individual files, only objects like dimensions and cubes.

Are you trying to build your own version control system? Visual Source Safe should be enough for projects with 1-5 developers?

Regards

Thomas Ivarsson

|||

Sorry, I was not making myself clear; we use MKS Source Integrity (a rather old version that does not integrate with VS) and there is no limit to the number of files it can deal with, but when I started checking in all the dim, cube, dsv, database, ds, dwproj, sln files etc it became apparent that it would be difficult to manage in that you would need to know which files would be affected by a change before you made it - I ended up checking everything out every time (a waste of time and effort!).

So I thought one script file for the database plus whatever the relevant files for the SSIS package are might be a better way forward, but would appreciate advice.

|||If only we had VSS! (see my response to Mosha above)|||So...any further advice from anyone?

is there any tools in the Business Intelligence Studio which can be used as Rules Engine?

I want to create business Rules from BI Development Studio. This will be a replacement of creating Stored Procedure. Most of the Business Rules are in the form of Stored Procedures since the DB is based on SQL Server 2000, but, it's migrating to 2005 server, so, it would be ideal if something in the BI studio can do Business Rules.Moving to SQL Server Tools General forum.

Is there any reported issues running SQL Server 2005 Enterprise 64bit Management Studio version?

At the moment I'm trying to find out if there are any reported issues with Management Studio running on a SQL Server 2005 Ent 64bit edition?

Can anyone help?

My reason for asking is really one of curiosity, one of my colleagues has said it doesn't work, I'm trying to research this claim as I do not have access to a 64 bit machine to try it on but would like to move my future project in this direction hence why I'm asking.

Many Thanks.

Dave

Hi Dave,

Technically, there aren't different versions of Management Studio, only 1 (client tools are distributed with all editions, except Express)...though, there are different platform builds (i.e. IA64,x64,x86)...

Management studio with Sql2k5 is fully 64bit compatible, and will run natively on an IA64 or x64 box...

HTH

|||There are issuses with SQL Server 2005 64 bit and the Management Studio that are explained here http://support.microsoft.com/default.aspx/kb/906892.
The Management Studio will run on the 64 bit platform but it will be slow and tend to freeze, the reason being it's still a 32 bit application. MS solution is to run the Management Studio on a 32 bit computer and connect to the SQL server that way. Why they don't have a 64 bit version of the Management Studio is anyone's guess.
RLB

Is there any reported issues running SQL Server 2005 Enterprise 64bit Management Studio version?

At the moment I'm trying to find out if there are any reported issues with Management Studio running on a SQL Server 2005 Ent 64bit edition?

Can anyone help?

My reason for asking is really one of curiosity, one of my colleagues has said it doesn't work, I'm trying to research this claim as I do not have access to a 64 bit machine to try it on but would like to move my future project in this direction hence why I'm asking.

Many Thanks.

Dave

Hi Dave,

Technically, there aren't different versions of Management Studio, only 1 (client tools are distributed with all editions, except Express)...though, there are different platform builds (i.e. IA64,x64,x86)...

Management studio with Sql2k5 is fully 64bit compatible, and will run natively on an IA64 or x64 box...

HTH

|||There are issuses with SQL Server 2005 64 bit and the Management Studio that are explained here http://support.microsoft.com/default.aspx/kb/906892.
The Management Studio will run on the 64 bit platform but it will be slow and tend to freeze, the reason being it's still a 32 bit application. MS solution is to run the Management Studio on a 32 bit computer and connect to the SQL server that way. Why they don't have a 64 bit version of the Management Studio is anyone's guess.
RLB

Is there an OWC forum here or anywhere?

“It is helpful to remember that this forum is mainly for issues that directly pertain to the Visual Studio Tools for Office tools per se. So you will be best served by posing this question to a forum or newsgroup wholly dedicated to application-specific issues such as yours. Here is a link to resources that will help you: http://msdn.microsoft.com/office”

Thanks,

George

Hi,friends, please help me. I can't find out an OWC forumn here. Many people have interest in OWC and asked some questions. But the answer is always that here is not an OWC forum.

MMM....

Is there an OWC forum here or anywhere?

Anyone could give me a tip? thanks!