Can I Import/Export Database Designs between Visual Studio 2003 and SQL Server 2005 Tools?

Title says it all, really.

Visual Studio has a "Reverse Engineer" option but the only export option appears to be to a graphics-definition database.

Regards,

Nick Samuel

These designs are just graphical representations of the physical structures, they are stored in a series of tables whose names start with dt. If you then copy that database to SQL 2005 and set the compat level to 90 then the 2005 diagram tool should be able to read it.|||

Hi Euan,

Thank you for your response.

I cannot find an option to set a compat level.

Regards,

Nick Samuel

Can I force a checkpoint.

Our application is having problems due to what appears to be a flush to disk
during a checkpoint. The flush lasts 2-6 seconds and then every thing
continues on as before with no delay.
I tried creating a job to run every two minutes (just during our stress test).
All the job does is call "CHECKPOINT". Looking at the logs during my stress
tests, there is no difference in the behavior.
So, how can I get the DB to do checkpoints more often to prevent such a
large lump write ?
Or, am I totally off in the wrong direction on this ?
Any thoughts would be greatly appreciated.
Mark.
Notes: all databases are running in simple mode.I am looking at checkpoint pages/sec and pages writes/sec along with
physical read and write.
Also, I am monitoring the log %used on all DB's. I can see that when one of
my DB's hits
70% it appears to be related to this dump which seems to go along with the
docs for
checkpoint and db set to simple.
I am 100% sure it is not related to a query. It might not have anything to
do with a checkpoint,
but when the log file grows to 70% and gets reset to 20% I can see this huge
write and
I get a major backup. I see a similar relation on another DB.
Should I just shrink the log file, will this help decrease the number of
pages to write?
It appears to be true on a different DB with a smaller log file the writes
following
the truncation of the log is very small in comparison, does that make sense?
Thanks,
"Brian Moran" <brian@.solidqualitylearning.com> wrote in message
news:Oz3lJpYUDHA.484@.TK2MSFTNGP09.phx.gbl...
> how do you know for sure it's related to checkpoint? What counters are you
> basing that on? CHECKPOINT will run the checkpoint process so I'm not
really
> sure what you'e asking... you can run it as frequently as you want...
> also... I might take a look at SQL Profiler to see if there is some other
> query that is perhaps related to the IO... it might not be checkpoint
> related...
> --
> Brian Moran
> Principal Mentor
> Solid Quality Learning
> SQL Server MVP
> http://www.solidqualitylearning.com
>
> "Mark DeBusschere" <developer@.line-4.com> wrote in message
> news:uTEjGgXUDHA.1552@.TK2MSFTNGP10.phx.gbl...
> > Our application is having problems due to what appears to be a flush to
> disk
> > during a checkpoint. The flush lasts 2-6 seconds and then every thing
> > continues on as before with no delay.
> >
> > I tried creating a job to run every two minutes (just during our stress
> test).
> > All the job does is call "CHECKPOINT". Looking at the logs during my
> stress
> > tests, there is no difference in the behavior.
> >
> > So, how can I get the DB to do checkpoints more often to prevent such a
> > large lump write ?
> >
> > Or, am I totally off in the wrong direction on this ?
> >
> > Any thoughts would be greatly appreciated.
> >
> > Mark.
> >
> > Notes: all databases are running in simple mode.
> >
> >
>|||Hi Mark,
My name is Michael and I would like to thank you for using Microsoft VAP
newsgroup.
I will update you later. In the mean time, if you have any other useful
information, please feel free to let me know.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Can I edit SDF files without full SQL Server license?

I'm trying to open an SDF file. After many searches on the net, it appears that there are two ways to do this:

Open the file in VS 2005 Open the file in SQL Server Management StudioI don't have, and don't plan to purchase, a license to full SQL Server 2005. I do have Visual Studio 2005 Pro. When I open an SDF file in Visual Studio, I get the following (oh so informative) error:

The operation could not be completed. Unspecified error

Since I don't have full SQL server, I downloaded SQL Server Management Studio Express. There's one major problem: the Server type combo box is disabled in the "Connect to Server" dialog. Try as I might, I can find no mention anywhere as to why this is the case. I'm guessing that functionality isn't supported in the Express version of the tool, but as far as I can tell, nobody thinks it might perhaps be reasonable to document why this combo box is disabled. It certainly doesn't show up in the document that shows up when I click the help button on this dialog.

Could somebody at Microsoft please tell me if it is even possible to edit these files without buying a full SQL Server license? I'm trying to use SQL Server Compact Edition to replace legacy code that uses an MDB file (via ADO) for a desktop application. From everything I have read, this is the officially recommended thing to do. But if I now have to buy a full SQL Server lincense to accomplish what used to be a simple double click on an MDB file, then there's something seriously wrong.

It turns out that my problem was the fact that I didn't have Service Pack 2 installed for SQL Server Management Studio Express, although installing that (along with making sure everything else on my system was up-to-date via Microsoft Update) didn't solve the Visual Studio error. I do have SP 1 installed for VS 2005.
sql

Can I change the text on the "View Report" button?

SSRS 2005
In the web form Report Viewer Control, is there a simple way to change the
text that appears on the "View Report" button?
I would like to either shorten the text or have it appear on two lines to
minimize the page width taken up by this button.
-- Chris
--
Chris, SSSIHello Chris,
As for the ReportViewer Control's "ViewButton", based on my research, it is
encapsulated as an "ViewReportButton" class which is an internal Type. I've
tried reference to this button instance from ReportViewer control's
Controls collection and change it Text, but that didn't work. I think it is
internally assigned the "View Report" text value. Actually since
Reportviewer is a well encapsulated webcontrol, there hasn't much options
for us to customize its individual settigns.
So far what I can get are the following two options if we want to provide a
custom parameterArea or button:
1. Still use the ReportViewer's built-in parameterArea and
ViewReportButton, however, we can only change the button's text by using
clent-side script(find the submit button and change its value), e.g:
==========================<script language="javascript">
function AdjustViewButton()
{
var div = document.getElementById("ReportViewer1");
elems = form1.getElementsByTagName("INPUT");
var i;
for(i=0;i<elems.length;i++)
{
if(elems[i].type == "submit" && elems[i].value == "View Report")
{
elems[i].value = "View";
}
}
}
.........................
<body onload="AdjustViewButton();" >
...............
=============================
2. Do not use the built-in parametersArea of the ReportViewer control(hide
it by setting ShowParameterPrompt=false), and provide our own UI(like label
and textbox ) to accept parameters from user, also add our own View Report
Button, and in the button's click event, we need to use custom code to add
parameters into ReportViewr.serverReport's parameters collection and render
the report.
Hope this helps some. If you have any other ideas, please feel free to let
me know.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Chris,
How are you doing on this issue, have you got any further idea or does my
last reply helps you a little? If there is any other information you
wonder, please feel free to let me know.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Steven,
Thank you for your reply and suggestions. It is not what I wanted to hear
;-) but I understand your proposals.
It would be nice if Microsoft could provide the ability to do such simple
customization through properties, etc. in the future.
It seems that the out of the box SRSS offering gets you going very quickly,
but very soon you also run into limitations and have to write custom code. It
is of course great that such custom code solutions are possible (it is very
flexible), but it also minimizes the productivity gains to be obtained with
SRSS. Just my 2 cents. ;-)
-- Chris
Chris, SSSI
"Steven Cheng[MSFT]" wrote:
> Hello Chris,
> How are you doing on this issue, have you got any further idea or does my
> last reply helps you a little? If there is any other information you
> wonder, please feel free to let me know.
> Sincerely,
> Steven Cheng
> Microsoft MSDN Online Support Lead
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Thanks for your followup Chris,
Yes, I can understand your concern here since what you want to customize is
just a simple Text property of the Button and it will be much more
convenient if the ReportViewer control has provide such a property for
modify it directly.
Fortunately the ReportViewer control still provide some programmtic
approach here as workaround. Also, since this is the first version of the
component, the dev team may haven't considered all the possible scenarios.
So please trust me, our dev guys will surely improve it for sequential
release(also the reporting services) according to more and more community
user experience and feedback. Thus, any of your feedback and comments are
really important to us.
Please feel free to post your comments and request so that our product team
can hear more on such feature request:
http://connect.microsoft.com/feedback/default.aspx?SiteID=210
Again thanks for your posting and understanding!
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.

Can a clustered SQL 2000 installation run without DNS

A client of ours wants to run a clustered instance of SQL and not have it
dependent on name resolution for anything.
Since it appears that SQL is heavily dependent on AD and DNS for the virtual
server piece, does this dependancy constitute a single point of failure?
You will need DNS and AD for installing a SQL Server cluster or adding nodes
to it.
The nodes themselves don't necessarily need an active DC or DNS. In fact you
should enter the node, and cluster name in the host file to reduce the
amount of time a node requires to go online.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Brian Cook" <BrianCook@.discussions.microsoft.com> wrote in message
news:368FFF28-CD47-4F92-A2D8-0FA72DEC1897@.microsoft.com...
> A client of ours wants to run a clustered instance of SQL and not have it
> dependent on name resolution for anything.
> Since it appears that SQL is heavily dependent on AD and DNS for the
virtual
> server piece, does this dependancy constitute a single point of failure?
>
|||Hilary, thanks for the validation. I know that AD and DNS is required, I just
am having problems convincing the client that they are required. I have
pointed out multiple articles in SQL books online, and TechNet/Support items
that also say the same thing.
Must have assumptions are not a satisfactory answer for this client. They
need to see it it writing that it must have explicitly AD/DNS.
Brian
"Hilary Cotter" wrote:

> You will need DNS and AD for installing a SQL Server cluster or adding nodes
> to it.
> The nodes themselves don't necessarily need an active DC or DNS. In fact you
> should enter the node, and cluster name in the host file to reduce the
> amount of time a node requires to go online.
>
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "Brian Cook" <BrianCook@.discussions.microsoft.com> wrote in message
> news:368FFF28-CD47-4F92-A2D8-0FA72DEC1897@.microsoft.com...
> virtual
>
>
|||I'd try to run cluster administrator to create a new cluster on a standalone
win2003 and take screen shots of it failing because it can't register the
cluster name in AD, or the IP address for the cluster in DNS.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Brian Cook" <BrianCook@.discussions.microsoft.com> wrote in message
news:30241601-0AD5-4673-8102-48FEC2C932DE@.microsoft.com...
> Hilary, thanks for the validation. I know that AD and DNS is required, I
just
> am having problems convincing the client that they are required. I have
> pointed out multiple articles in SQL books online, and TechNet/Support
items[vbcol=seagreen]
> that also say the same thing.
> Must have assumptions are not a satisfactory answer for this client. They
> need to see it it writing that it must have explicitly AD/DNS.
> Brian
> "Hilary Cotter" wrote:
nodes[vbcol=seagreen]
you[vbcol=seagreen]
it[vbcol=seagreen]
failure?[vbcol=seagreen]
|||Hillary, here is the kicker for you. I don't know how they did it, however
they got the cluster and sql to run without the domain controllers/dns
servers. I will be heading over there in a little while to figure out what
they did.
Either way I know it is not a supported configuration by Microsoft, and I
cannot guarantee that it will not fail completely at some point and bite them
in the fanny.
Brian
"Hilary Cotter" wrote:

> I'd try to run cluster administrator to create a new cluster on a standalone
> win2003 and take screen shots of it failing because it can't register the
> cluster name in AD, or the IP address for the cluster in DNS.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "Brian Cook" <BrianCook@.discussions.microsoft.com> wrote in message
> news:30241601-0AD5-4673-8102-48FEC2C932DE@.microsoft.com...
> just
> items
> nodes
> you
> it
> failure?
>
>
|||Hilary, the following items were changed on both nodes of the cluster and
allows the resources to function correctly without AD/DNS.
MSSQLSERVER service to use LocalSystem Account, Interact with Desktop
unchecked.
SQLSERVERAGENT service to use LocalSystem Account, Interact with Desktop
unchecked.
Cluster Service to use local user account which has admin rights. Use same
account and password for both computers.
Following items added to lmhosts file;
10.50.32.34 NOCTMDS-DBTSQL #PRE //SQL Server Virtual IP
10.50.32.35 NOCTMDS-DBTEST #PRE //Microsoft Cluster Server
Virtual IP
DNS servers removed from TCP/IP Properties.
Enable NetBIOS over TCP/IP.
Only other change that was made is to /flushdns from both computers. Both
AD/DNS servers are turned off.
Cluster failover occurs normally.
First question is why does this work?
Is this a supported configuration by Microsoft, or does this go against
“Best Practices” for any specific reason?
If not supported by Microsoft, what is the down side to running in this
manner, and what problems could be expected by not using a Domain\Username
account for the services?
Any white papers, tech notes, releasable internal documents that specify it
must be done one way or the other (AD/DNS or Not needed) would be greatly
appreciated.
"Brian Cook" wrote:
[vbcol=seagreen]
> Hillary, here is the kicker for you. I don't know how they did it, however
> they got the cluster and sql to run without the domain controllers/dns
> servers. I will be heading over there in a little while to figure out what
> they did.
> Either way I know it is not a supported configuration by Microsoft, and I
> cannot guarantee that it will not fail completely at some point and bite them
> in the fanny.
> Brian
> "Hilary Cotter" wrote:
|||What version of the OS are we talking about 2000 or 2003?
2003 does seem to require AD and DNS to be live when creating the cluster.
It does appear that somehow they have managed to create a cluster without an
active DNS or AD. I don't believe Microsoft will support this configuration.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Brian Cook" <BrianCook@.discussions.microsoft.com> wrote in message
news:B2143F93-C7C2-427E-9F54-970EB2117B7D@.microsoft.com...
> Hilary, the following items were changed on both nodes of the cluster and
> allows the resources to function correctly without AD/DNS.
> MSSQLSERVER service to use LocalSystem Account, Interact with Desktop
> unchecked.
> SQLSERVERAGENT service to use LocalSystem Account, Interact with Desktop
> unchecked.
> Cluster Service to use local user account which has admin rights. Use same
> account and password for both computers.
> Following items added to lmhosts file;
> 10.50.32.34 NOCTMDS-DBTSQL #PRE //SQL Server Virtual IP
> 10.50.32.35 NOCTMDS-DBTEST #PRE //Microsoft Cluster Server
> Virtual IP
> DNS servers removed from TCP/IP Properties.
> Enable NetBIOS over TCP/IP.
> Only other change that was made is to /flushdns from both computers. Both
> AD/DNS servers are turned off.
> Cluster failover occurs normally.
> First question is why does this work?
> Is this a supported configuration by Microsoft, or does this go against
> "Best Practices" for any specific reason?
> If not supported by Microsoft, what is the down side to running in this
> manner, and what problems could be expected by not using a Domain\Username
> account for the services?
> Any white papers, tech notes, releasable internal documents that specify
it[vbcol=seagreen]
> must be done one way or the other (AD/DNS or Not needed) would be greatly
> appreciated.
>
> "Brian Cook" wrote:
however[vbcol=seagreen]
what[vbcol=seagreen]
I[vbcol=seagreen]
them[vbcol=seagreen]
standalone[vbcol=seagreen]
the[vbcol=seagreen]
required, I[vbcol=seagreen]
have[vbcol=seagreen]
TechNet/Support[vbcol=seagreen]
They[vbcol=seagreen]
adding[vbcol=seagreen]
In fact[vbcol=seagreen]
the[vbcol=seagreen]
message[vbcol=seagreen]
not have[vbcol=seagreen]
the[vbcol=seagreen]
|||Hilary, this is a two node W2K3 installation. We have replicated it in our
lab and it is working. I am opening a case with Microsoft today to confirm my
suspicions that it is not a support configuration, and also see if there are
any down sides to this configuration.
My concern is that since we are developing an application that uses SQL, yet
does not rely on the "name" of the db server, and at some point down the
road, if the cluster fails, and stops working will it be because of the way
the system is configured or something else as it is not configured as it was
designed to be used, and our company end up with the liability for the
failure.
Brian
"Hilary Cotter" wrote:

> What version of the OS are we talking about 2000 or 2003?
> 2003 does seem to require AD and DNS to be live when creating the cluster.
> It does appear that somehow they have managed to create a cluster without an
> active DNS or AD. I don't believe Microsoft will support this configuration.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "Brian Cook" <BrianCook@.discussions.microsoft.com> wrote in message
> news:B2143F93-C7C2-427E-9F54-970EB2117B7D@.microsoft.com...
> it
> however
> what
> I
> them
> standalone
> the
> required, I
> have
> TechNet/Support
> They
> adding
> In fact
> the
> message
> not have
> the
>
>