Microsoft SQL Server 2005 beta - Database Dump

Hi, I would like to generate a database dump of my Microsoft SQL Server 2005 beta databases.

Does anyone know, how to do it?

Since I have many tables in one database, I would need the dump to include the schema as well as the data,

Thanks a lot for your help!

Use Backup/Restore method to get the Schema with data.

a. Backup Database YourDatabaseName To Disk='D:\Yourdb.bak'

b. RESTORE FILELISTONLY FROM DISK='D:\Yourdb.bak'

GO

c.

RESTORE DATABASE NewDBName

FROM DISK='D:\Database Backups\TTCProvidedData.BAK'

WITH MOVE'OldDatabaseDatafileLogicalName' TO 'D:\NewDBName.mdf',

MOVE OldDatabaseLogfileLogicalName' TO'D:\NewDBName_log.ldf'

change the path and db name accordingly.

Madhu

Microsoft Project front end to SQL Server

G'day, I hope someone can help with this.
I have up-sized several of my currently-running MSAcces databases to run on
SQL Server 2000. In each case, the up-sizing wizard worked, with several
understandable errors.
In the code, I have often used CurrentDb to locate other text files
associated with the database. I get a run-time error wherever CurrentDb is
used.
In the help I am told to set a reference, I think, to the SQL Server type
library, or to DAO 3.6. Following the intructions, I have located a reference
to the DAO 3.6 type library, and it is checked.
I have also tried the other suggested solution of creating a reference
object, but I cannot figure out how to do this, either.
Please help if you can.
Regards, Terry
CurrentDB in DAO refers to the Jet engne, which is no longer present
in an Access project. You will need to rewrite significant portions of
your application to work with SQL Server, depending on what you need
to do. A straight port of an Access/Jet application never works
without significant alteration (unless it's extremely simple). If you
are working with text files and other local resources (not on the
server), I'd recommend using an mdb with linked tables rather than an
ADP. That gives you the flexibility of still being able to use DAO
against the Jet engine.
-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446
On Tue, 7 Sep 2004 06:29:04 -0700, "mccer"
<mccer@.discussions.microsoft.com> wrote:

>G'day, I hope someone can help with this.
>I have up-sized several of my currently-running MSAcces databases to run on
>SQL Server 2000. In each case, the up-sizing wizard worked, with several
>understandable errors.
>In the code, I have often used CurrentDb to locate other text files
>associated with the database. I get a run-time error wherever CurrentDb is
>used.
>In the help I am told to set a reference, I think, to the SQL Server type
>library, or to DAO 3.6. Following the intructions, I have located a reference
>to the DAO 3.6 type library, and it is checked.
>I have also tried the other suggested solution of creating a reference
>object, but I cannot figure out how to do this, either.
>Please help if you can.
>Regards, Terry
sql

Microsoft doesnt really support anything over 32 Databases(?)

Hi NG,
I've read the following statement on
http://www.sharepointu.com/forums/m_12060/tm.htm:
"Microsoft doesnt really support anything over 32 Databases". (This
statement was uttered concerning the creation of a large amount (ca. 200)
sharepoint-websites with stsadm -o CreateSiteInNewDb)
Can anyone confirm this or would you guys say, that there shouldn't be any
problems with about 200 databases in an MSSQL-Server (with each database
containing about 10MB upto 1GB).
I'd appreciate any help!
Cheers, Jens
P.S. I am doing exactly the same thing like the guy in the posting stated
above therefore it'd be interesting if anybody has infos about this special
case.
No problem. I have close to 190 most at or over 100MB with a couple topping
2GB.
Robert Burks
burksr@.bcsd.com
"Jens Mertens" <no@.no.com> wrote in message
news:uWbynURHGHA.2036@.TK2MSFTNGP14.phx.gbl...
> Hi NG,
> I've read the following statement on
> http://www.sharepointu.com/forums/m_12060/tm.htm:
> "Microsoft doesnt really support anything over 32 Databases". (This
> statement was uttered concerning the creation of a large amount (ca. 200)
> sharepoint-websites with stsadm -o CreateSiteInNewDb)
> Can anyone confirm this or would you guys say, that there shouldn't be any
> problems with about 200 databases in an MSSQL-Server (with each database
> containing about 10MB upto 1GB).
> I'd appreciate any help!
> Cheers, Jens
> P.S. I am doing exactly the same thing like the guy in the posting stated
> above therefore it'd be interesting if anybody has infos about this
> special case.
>
|||The real limit is on the number of concurrently open databases, and if I
remember correctly it is actually a Windows handle limit that is hit. You
can use AutoClose to support a large number of databases that are not all in
use simultaneously. And, I suspect the handle limit isn't an issue at all
on 64-bit Windows. But I haven't looked into it.
Hal Berenson, President
PredictableIT, LLC
http://www.predictableit.com
"Jens Mertens" <no@.no.com> wrote in message
news:uWbynURHGHA.2036@.TK2MSFTNGP14.phx.gbl...
> Hi NG,
> I've read the following statement on
> http://www.sharepointu.com/forums/m_12060/tm.htm:
> "Microsoft doesnt really support anything over 32 Databases". (This
> statement was uttered concerning the creation of a large amount (ca. 200)
> sharepoint-websites with stsadm -o CreateSiteInNewDb)
> Can anyone confirm this or would you guys say, that there shouldn't be any
> problems with about 200 databases in an MSSQL-Server (with each database
> containing about 10MB upto 1GB).
> I'd appreciate any help!
> Cheers, Jens
> P.S. I am doing exactly the same thing like the guy in the posting stated
> above therefore it'd be interesting if anybody has infos about this
> special case.
>
|||It's a handle limit from Windows. I've never hit it though.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Hal Berenson" <hberenson@.predictableit.com> wrote in message
news:uqec9ISHGHA.1288@.TK2MSFTNGP09.phx.gbl...
> The real limit is on the number of concurrently open databases, and if I
> remember correctly it is actually a Windows handle limit that is hit. You
> can use AutoClose to support a large number of databases that are not all
> in use simultaneously. And, I suspect the handle limit isn't an issue at
> all on 64-bit Windows. But I haven't looked into it.
> --
> Hal Berenson, President
> PredictableIT, LLC
> http://www.predictableit.com
>
> "Jens Mertens" <no@.no.com> wrote in message
> news:uWbynURHGHA.2036@.TK2MSFTNGP14.phx.gbl...
>

Microsoft doesnt really support anything over 32 Databases(?)

Hi NG,
I've read the following statement on
http://www.sharepointu.com/forums/m_12060/tm.htm:
"Microsoft doesnt really support anything over 32 Databases". (This
statement was uttered concerning the creation of a large amount (ca. 200)
sharepoint-websites with stsadm -o CreateSiteInNewDb)
Can anyone confirm this or would you guys say, that there shouldn't be any
problems with about 200 databases in an MSSQL-Server (with each database
containing about 10MB upto 1GB).
I'd appreciate any help!
Cheers, Jens
P.S. I am doing exactly the same thing like the guy in the posting stated
above therefore it'd be interesting if anybody has infos about this special
case.No problem. I have close to 190 most at or over 100MB with a couple topping
2GB.
Robert Burks
burksr@.bcsd.com
"Jens Mertens" <no@.no.com> wrote in message
news:uWbynURHGHA.2036@.TK2MSFTNGP14.phx.gbl...
> Hi NG,
> I've read the following statement on
> http://www.sharepointu.com/forums/m_12060/tm.htm:
> "Microsoft doesnt really support anything over 32 Databases". (This
> statement was uttered concerning the creation of a large amount (ca. 200)
> sharepoint-websites with stsadm -o CreateSiteInNewDb)
> Can anyone confirm this or would you guys say, that there shouldn't be any
> problems with about 200 databases in an MSSQL-Server (with each database
> containing about 10MB upto 1GB).
> I'd appreciate any help!
> Cheers, Jens
> P.S. I am doing exactly the same thing like the guy in the posting stated
> above therefore it'd be interesting if anybody has infos about this
> special case.
>|||The real limit is on the number of concurrently open databases, and if I
remember correctly it is actually a Windows handle limit that is hit. You
can use AutoClose to support a large number of databases that are not all in
use simultaneously. And, I suspect the handle limit isn't an issue at all
on 64-bit Windows. But I haven't looked into it.
Hal Berenson, President
PredictableIT, LLC
http://www.predictableit.com
"Jens Mertens" <no@.no.com> wrote in message
news:uWbynURHGHA.2036@.TK2MSFTNGP14.phx.gbl...
> Hi NG,
> I've read the following statement on
> http://www.sharepointu.com/forums/m_12060/tm.htm:
> "Microsoft doesnt really support anything over 32 Databases". (This
> statement was uttered concerning the creation of a large amount (ca. 200)
> sharepoint-websites with stsadm -o CreateSiteInNewDb)
> Can anyone confirm this or would you guys say, that there shouldn't be any
> problems with about 200 databases in an MSSQL-Server (with each database
> containing about 10MB upto 1GB).
> I'd appreciate any help!
> Cheers, Jens
> P.S. I am doing exactly the same thing like the guy in the posting stated
> above therefore it'd be interesting if anybody has infos about this
> special case.
>|||It's a handle limit from Windows. I've never hit it though.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Hal Berenson" <hberenson@.predictableit.com> wrote in message
news:uqec9ISHGHA.1288@.TK2MSFTNGP09.phx.gbl...
> The real limit is on the number of concurrently open databases, and if I
> remember correctly it is actually a Windows handle limit that is hit. You
> can use AutoClose to support a large number of databases that are not all
> in use simultaneously. And, I suspect the handle limit isn't an issue at
> all on 64-bit Windows. But I haven't looked into it.
> --
> Hal Berenson, President
> PredictableIT, LLC
> http://www.predictableit.com
>
> "Jens Mertens" <no@.no.com> wrote in message
> news:uWbynURHGHA.2036@.TK2MSFTNGP14.phx.gbl...
>

Microsoft doesnt really support anything over 32 Databases(?)

Hi NG,
I've read the following statement on
http://www.sharepointu.com/forums/m_12060/tm.htm:
"Microsoft doesnt really support anything over 32 Databases". (This
statement was uttered concerning the creation of a large amount (ca. 200)
sharepoint-websites with stsadm -o CreateSiteInNewDb)
Can anyone confirm this or would you guys say, that there shouldn't be any
problems with about 200 databases in an MSSQL-Server (with each database
containing about 10MB upto 1GB).
I'd appreciate any help!
Cheers, Jens
P.S. I am doing exactly the same thing like the guy in the posting stated
above therefore it'd be interesting if anybody has infos about this special
case.No problem. I have close to 190 most at or over 100MB with a couple topping
2GB.
--
Robert Burks
burksr@.bcsd.com
"Jens Mertens" <no@.no.com> wrote in message
news:uWbynURHGHA.2036@.TK2MSFTNGP14.phx.gbl...
> Hi NG,
> I've read the following statement on
> http://www.sharepointu.com/forums/m_12060/tm.htm:
> "Microsoft doesnt really support anything over 32 Databases". (This
> statement was uttered concerning the creation of a large amount (ca. 200)
> sharepoint-websites with stsadm -o CreateSiteInNewDb)
> Can anyone confirm this or would you guys say, that there shouldn't be any
> problems with about 200 databases in an MSSQL-Server (with each database
> containing about 10MB upto 1GB).
> I'd appreciate any help!
> Cheers, Jens
> P.S. I am doing exactly the same thing like the guy in the posting stated
> above therefore it'd be interesting if anybody has infos about this
> special case.
>|||The real limit is on the number of concurrently open databases, and if I
remember correctly it is actually a Windows handle limit that is hit. You
can use AutoClose to support a large number of databases that are not all in
use simultaneously. And, I suspect the handle limit isn't an issue at all
on 64-bit Windows. But I haven't looked into it.
--
Hal Berenson, President
PredictableIT, LLC
http://www.predictableit.com
"Jens Mertens" <no@.no.com> wrote in message
news:uWbynURHGHA.2036@.TK2MSFTNGP14.phx.gbl...
> Hi NG,
> I've read the following statement on
> http://www.sharepointu.com/forums/m_12060/tm.htm:
> "Microsoft doesnt really support anything over 32 Databases". (This
> statement was uttered concerning the creation of a large amount (ca. 200)
> sharepoint-websites with stsadm -o CreateSiteInNewDb)
> Can anyone confirm this or would you guys say, that there shouldn't be any
> problems with about 200 databases in an MSSQL-Server (with each database
> containing about 10MB upto 1GB).
> I'd appreciate any help!
> Cheers, Jens
> P.S. I am doing exactly the same thing like the guy in the posting stated
> above therefore it'd be interesting if anybody has infos about this
> special case.
>|||It's a handle limit from Windows. I've never hit it though.
--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Hal Berenson" <hberenson@.predictableit.com> wrote in message
news:uqec9ISHGHA.1288@.TK2MSFTNGP09.phx.gbl...
> The real limit is on the number of concurrently open databases, and if I
> remember correctly it is actually a Windows handle limit that is hit. You
> can use AutoClose to support a large number of databases that are not all
> in use simultaneously. And, I suspect the handle limit isn't an issue at
> all on 64-bit Windows. But I haven't looked into it.
> --
> Hal Berenson, President
> PredictableIT, LLC
> http://www.predictableit.com
>
> "Jens Mertens" <no@.no.com> wrote in message
> news:uWbynURHGHA.2036@.TK2MSFTNGP14.phx.gbl...
>> Hi NG,
>> I've read the following statement on
>> http://www.sharepointu.com/forums/m_12060/tm.htm:
>> "Microsoft doesnt really support anything over 32 Databases". (This
>> statement was uttered concerning the creation of a large amount (ca. 200)
>> sharepoint-websites with stsadm -o CreateSiteInNewDb)
>> Can anyone confirm this or would you guys say, that there shouldn't be
>> any problems with about 200 databases in an MSSQL-Server (with each
>> database containing about 10MB upto 1GB).
>> I'd appreciate any help!
>> Cheers, Jens
>> P.S. I am doing exactly the same thing like the guy in the posting stated
>> above therefore it'd be interesting if anybody has infos about this
>> special case.
>sql

microsoft decision tree algorithm

I have read some sources about microsoft decision tree algorithm like in claude seidman book, paper about scalable classification over sql databases and paper about learning bayesian network. But i still don't understand and i still didn't get the point on how microsoft decision tree algorithm works exactly when splitting an atribut. Because i have read that microsoft decision tree using Bayesian score to split criteria is it true?

Well, anyone could help me to understand about microsoft decision tree algorithm, please give me details explanation with some example(cases).

thanks for anyone help

There are links to the appropriate research papers at http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/986.aspx

Thanks

-Jamie

|||Hi, there, the first link fails, i am also interested to know how Microsoft Decision Trees splits a continous attribute for derivation of downstream regression models: using information gain or regession approach? thx.|||i'd like to further clarify my previous question for regression tree building: which method is used for splitting a continous variable: information gain or regression approach. The first splitting method (information gain) first bins a continous attribute and turns it into a categorical variable, selects a value which gives highest informtion gain; the second method, according to http://msdn2.microsoft.com/en-us/library/ms175312.aspx, the splitting is performed at the point of non-lineararity(statistical method?). I just wonder which method is used by Microsoft Decision Trees for splitting in the case of a continous variable.|||If the target is a discrete attribute, it uses information gain. For continuous targets, it uses the regression approach|||Thank you for your answer, Jamie. but my question is how to split the continous INPUT attribute (The target variable is assumed automatically to be continuous in the case of regression tree).|||I was describing how the INPUT is handled for various OUTPUTs - if you are only considering the case of regression trees, than it is always the regression approach.|||

Hi, there,

when I use the Microsoft Decision Trees algoirthm to build a regression tree and choose SCORE_METHOD: (1) entropy. :

does the algorithm select the categorical input attribute and split-on by using entropy function? is the continuous input attribute binned into categorical attribute for entropy calculation?

Or this score_method does not act on the regression tree?

Any help is very much appreciated,

Hongqin

|||Continuous variables are split by using a internal binning approach that searches the continuous space for the best split point. This is independent of the score method.|||thx, Jamie.|||

Dear all,

I've tried to change split_method to (2) Complete. It doesn't generate any leaves or trees. It show only top of the tree.

But when I changed it back to (3) Both. The result is ok..but include Binary Split and Complete Split.

By the way, How can i do if I want it to generate only complete split.

Thank you for your answer in advanced.

Nop Vorrasanpisut.

microsoft decision tree algorithm

I have read some sources about microsoft decision tree algorithm like in claude seidman book, paper about scalable classification over sql databases and paper about learning bayesian network. But i still don't understand and i still didn't get the point on how microsoft decision tree algorithm works exactly when splitting an atribut. Because i have read that microsoft decision tree using Bayesian score to split criteria is it true?

Well, anyone could help me to understand about microsoft decision tree algorithm, please give me details explanation with some example(cases).

thanks for anyone help

There are links to the appropriate research papers at http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/986.aspx

Thanks

-Jamie

|||Hi, there, the first link fails, i am also interested to know how Microsoft Decision Trees splits a continous attribute for derivation of downstream regression models: using information gain or regession approach? thx.|||i'd like to further clarify my previous question for regression tree building: which method is used for splitting a continous variable: information gain or regression approach. The first splitting method (information gain) first bins a continous attribute and turns it into a categorical variable, selects a value which gives highest informtion gain; the second method, according to http://msdn2.microsoft.com/en-us/library/ms175312.aspx, the splitting is performed at the point of non-lineararity(statistical method?). I just wonder which method is used by Microsoft Decision Trees for splitting in the case of a continous variable.|||If the target is a discrete attribute, it uses information gain. For continuous targets, it uses the regression approach|||Thank you for your answer, Jamie. but my question is how to split the continous INPUT attribute (The target variable is assumed automatically to be continuous in the case of regression tree).|||I was describing how the INPUT is handled for various OUTPUTs - if you are only considering the case of regression trees, than it is always the regression approach.|||

Hi, there,

when I use the Microsoft Decision Trees algoirthm to build a regression tree and choose SCORE_METHOD: (1) entropy. :

does the algorithm select the categorical input attribute and split-on by using entropy function? is the continuous input attribute binned into categorical attribute for entropy calculation?

Or this score_method does not act on the regression tree?

Any help is very much appreciated,

Hongqin

|||Continuous variables are split by using a internal binning approach that searches the continuous space for the best split point. This is independent of the score method.|||thx, Jamie.|||

Dear all,

I've tried to change split_method to (2) Complete. It doesn't generate any leaves or trees. It show only top of the tree.

But when I changed it back to (3) Both. The result is ok..but include Binary Split and Complete Split.

By the way, How can i do if I want it to generate only complete split.

Thank you for your answer in advanced.

Nop Vorrasanpisut.

microsoft decision tree algorithm

I have read some sources about microsoft decision tree algorithm like in claude seidman book, paper about scalable classification over sql databases and paper about learning bayesian network. But i still don't understand and i still didn't get the point on how microsoft decision tree algorithm works exactly when splitting an atribut. Because i have read that microsoft decision tree using Bayesian score to split criteria is it true?

Well, anyone could help me to understand about microsoft decision tree algorithm, please give me details explanation with some example(cases).

thanks for anyone help

There are links to the appropriate research papers at http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/986.aspx

Thanks

-Jamie

|||Hi, there, the first link fails, i am also interested to know how Microsoft Decision Trees splits a continous attribute for derivation of downstream regression models: using information gain or regession approach? thx.|||i'd like to further clarify my previous question for regression tree building: which method is used for splitting a continous variable: information gain or regression approach. The first splitting method (information gain) first bins a continous attribute and turns it into a categorical variable, selects a value which gives highest informtion gain; the second method, according to http://msdn2.microsoft.com/en-us/library/ms175312.aspx, the splitting is performed at the point of non-lineararity(statistical method?). I just wonder which method is used by Microsoft Decision Trees for splitting in the case of a continous variable.|||If the target is a discrete attribute, it uses information gain. For continuous targets, it uses the regression approach|||Thank you for your answer, Jamie. but my question is how to split the continous INPUT attribute (The target variable is assumed automatically to be continuous in the case of regression tree).|||I was describing how the INPUT is handled for various OUTPUTs - if you are only considering the case of regression trees, than it is always the regression approach.|||

Hi, there,

when I use the Microsoft Decision Trees algoirthm to build a regression tree and choose SCORE_METHOD: (1) entropy. :

does the algorithm select the categorical input attribute and split-on by using entropy function? is the continuous input attribute binned into categorical attribute for entropy calculation?

Or this score_method does not act on the regression tree?

Any help is very much appreciated,

Hongqin

|||Continuous variables are split by using a internal binning approach that searches the continuous space for the best split point. This is independent of the score method.|||thx, Jamie.|||

Dear all,

I've tried to change split_method to (2) Complete. It doesn't generate any leaves or trees. It show only top of the tree.

But when I changed it back to (3) Both. The result is ok..but include Binary Split and Complete Split.

By the way, How can i do if I want it to generate only complete split.

Thank you for your answer in advanced.

Nop Vorrasanpisut.

microsoft decision tree algorithm

I have read some sources about microsoft decision tree algorithm like in claude seidman book, paper about scalable classification over sql databases and paper about learning bayesian network. But i still don't understand and i still didn't get the point on how microsoft decision tree algorithm works exactly when splitting an atribut. Because i have read that microsoft decision tree using Bayesian score to split criteria is it true?

Well, anyone could help me to understand about microsoft decision tree algorithm, please give me details explanation with some example(cases).

thanks for anyone help

There are links to the appropriate research papers at http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/986.aspx

Thanks

-Jamie

|||Hi, there, the first link fails, i am also interested to know how Microsoft Decision Trees splits a continous attribute for derivation of downstream regression models: using information gain or regession approach? thx.|||i'd like to further clarify my previous question for regression tree building: which method is used for splitting a continous variable: information gain or regression approach. The first splitting method (information gain) first bins a continous attribute and turns it into a categorical variable, selects a value which gives highest informtion gain; the second method, according to http://msdn2.microsoft.com/en-us/library/ms175312.aspx, the splitting is performed at the point of non-lineararity(statistical method?). I just wonder which method is used by Microsoft Decision Trees for splitting in the case of a continous variable.|||If the target is a discrete attribute, it uses information gain. For continuous targets, it uses the regression approach|||Thank you for your answer, Jamie. but my question is how to split the continous INPUT attribute (The target variable is assumed automatically to be continuous in the case of regression tree).|||I was describing how the INPUT is handled for various OUTPUTs - if you are only considering the case of regression trees, than it is always the regression approach.|||

Hi, there,

when I use the Microsoft Decision Trees algoirthm to build a regression tree and choose SCORE_METHOD: (1) entropy. :

does the algorithm select the categorical input attribute and split-on by using entropy function? is the continuous input attribute binned into categorical attribute for entropy calculation?

Or this score_method does not act on the regression tree?

Any help is very much appreciated,

Hongqin

|||Continuous variables are split by using a internal binning approach that searches the continuous space for the best split point. This is independent of the score method.|||thx, Jamie.|||

Dear all,

I've tried to change split_method to (2) Complete. It doesn't generate any leaves or trees. It show only top of the tree.

But when I changed it back to (3) Both. The result is ok..but include Binary Split and Complete Split.

By the way, How can i do if I want it to generate only complete split.

Thank you for your answer in advanced.

Nop Vorrasanpisut.

sql

Microsoft Baseline Security Analyser 2.1

Hi

I downloaded MBSA and ran it against my SQL 2005 Server. It tells me that I have a severe risk because

'The following databases have public access.Remove the public access if it is not required - tempdb , model , msdb , ReportServer , ReportServerTempDB'

I have checked these databases and each have the Guest User but it is disabled. If I check the database properties the public role has no permissions against the listed databases.

Is this a bug with MBSA? If not how do I remove Public Access?

Hi Ewan, are you using a Xp_cmdshell enabled?

|||

Hi Emanuel

I an not sure what you mean. I have installed the product MBSA on a PC running VISTA business and am scanning the SQL server from this PC. The server operating system is Windows Server 2003 R2

Regards

|||

Hi Emanuel

I have now looked it up and xp_cmdshell is not enabled

Regards

|||

The MBSA given't u more details about this vulnerability message?

|||

Hi Emanuel

No MBSA gives no further information on this message

|||

Ewan, has your sql server a valid internet ip address or any other network vulnerability?

|||I mean, does your sql server is exposed on internet?|||

Hi Emanuel

Only via Reporting Services

|||

I'm suggest you investigate any vulnerability on SSRS like a public access on web service.

see the link below, there is a cool tool to do a verification on any possible network vulnerability.

http://www.gfi.com/lannetscan/?adv=40&loc=3&adclickid=14102298

Mgt Studio Express vs Mgt Studio "Full" questions

I am currently using Management Studio Express to administer remote SQLServer databases I support as a DBA. I notice that I cannot "see" DTS packages on the remote server from Express, but when I login directly to the server (Term Services) and use the local Management Studio (Full?), that I CAN see the DTS packages.

1) What are the other differences between Management Studio Express and Management Studio "Full"?

2) Is it possible to aquire and install (upgrade) on my workstation, to Management Studio "Full" so that I can take advantage of the additional capabilities the "Express" version does not have, in order to manage my remote servers?

TIA,
Phil Streiff, MCDBA

There are quite a few differences between SSMS and SSMS-Express.

You can obtain (and be properly licensed for) SSMS with SQL Server Workgroup, Standard and Enterprise Edition.

|||

Thanks Arnie,

I will definitely upgrade to SSMS now, based on your input.

I suppose I have to pay for the SQL2K5 Standard or Workgroup license, even though I'm only installing the Mgt Studio on my workstation and not the whole database engine.

Phil

|||

SS 2005 Workgroup Edition is about $750 with 5 CALs. (Maybe better pricing is around.)

IF you were in a dev environment, you could get SS Developer's Edition for about $50. But I don't think that it would be legit to manage production servers.

Maybe one or more of your clients provide you with SSMS to manage their servers.

For definitive licensing questions, call the licensing folks at:

Licensing –VL Contact
(800) 426-9400

Good Luck!

Mgmt Studio

Can I manage MSDE databases in Management Studio? If not, how can I? How
about SQL Express?
When I try to attach an msde.mdf it just gets an "unknown error."
Regards,
Gary BlakelyTry to attach an MSDE MDF file to what?
You can certainly manage existing instances of SQL Server 2000 (including
MSDE). But you're not going to be able to just attach a SQL Server
2000-based mdf (from MSDE or otherwise) to a 2005 instance.
A
"GaryDean" <GaryDean@.newsgroups.nospam> wrote in message
news:OZhDtF5HHHA.4760@.TK2MSFTNGP03.phx.gbl...
> Can I manage MSDE databases in Management Studio? If not, how can I? How
> about SQL Express?
> When I try to attach an msde.mdf it just gets an "unknown error."
> --
> Regards,
> Gary Blakely
>|||Hi Gary,
I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
I will be more than happy to be of assistance.
Have a great day!
Charles Wang
Microsoft Online Community Support

Mgmt Studio

Can I manage MSDE databases in Management Studio? If not, how can I? How
about SQL Express?
When I try to attach an msde.mdf it just gets an "unknown error."
--
Regards,
Gary BlakelyTry to attach an MSDE MDF file to what?
You can certainly manage existing instances of SQL Server 2000 (including
MSDE). But you're not going to be able to just attach a SQL Server
2000-based mdf (from MSDE or otherwise) to a 2005 instance.
A
"GaryDean" <GaryDean@.newsgroups.nospam> wrote in message
news:OZhDtF5HHHA.4760@.TK2MSFTNGP03.phx.gbl...
> Can I manage MSDE databases in Management Studio? If not, how can I? How
> about SQL Express?
> When I try to attach an msde.mdf it just gets an "unknown error."
> --
> Regards,
> Gary Blakely
>|||Hi Gary,
SQL Server 2005 Management Studio totally supports attaching SQL Server
2000, MSDE2000 and SQL Express databases by using sp_detach_db/sp_attach_db
stored procedure.
Please try again via the following:
1. Connect to your MSDE instance, and run the following statement:
use master
go
exec sp_detach_db 'YourDatabaseName'
2. Connect to your SQL Server 2005 instance and run the following statement:
use master
go
exec sp_attach_db @.dbname='DatabaseName',
@.filename1 = N'C:\Program Files\Microsoft SQL
Server\MSSQL$MSDE\Data\test.mdf',
@.filename2 = N'C:\Program Files\Microsoft SQL
Server\MSSQL$MSDE\Data\test_log.ldf'
Could you please mail me (changliw@.microsoft.com) the SQL error logs and a
screenshot of the error message for further research?
By default, the error logs of SQL Server 2005 instance are located in
"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG". You may check it
if there are multiple instances installed on your computer.
Sincerely yours,
Charles Wang
Microsoft Online Community Support
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hi Gary,
I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
I will be more than happy to be of assistance.
Have a great day!
Charles Wang
Microsoft Online Community Support

Mgmt Studio

Can I manage MSDE databases in Management Studio? If not, how can I? How
about SQL Express?
When I try to attach an msde.mdf it just gets an "unknown error."
Regards,
Gary Blakely
Try to attach an MSDE MDF file to what?
You can certainly manage existing instances of SQL Server 2000 (including
MSDE). But you're not going to be able to just attach a SQL Server
2000-based mdf (from MSDE or otherwise) to a 2005 instance.
A
"GaryDean" <GaryDean@.newsgroups.nospam> wrote in message
news:OZhDtF5HHHA.4760@.TK2MSFTNGP03.phx.gbl...
> Can I manage MSDE databases in Management Studio? If not, how can I? How
> about SQL Express?
> When I try to attach an msde.mdf it just gets an "unknown error."
> --
> Regards,
> Gary Blakely
>
|||Hi Gary,
SQL Server 2005 Management Studio totally supports attaching SQL Server
2000, MSDE2000 and SQL Express databases by using sp_detach_db/sp_attach_db
stored procedure.
Please try again via the following:
1. Connect to your MSDE instance, and run the following statement:
use master
go
exec sp_detach_db 'YourDatabaseName'
2. Connect to your SQL Server 2005 instance and run the following statement:
use master
go
exec sp_attach_db @.dbname='DatabaseName',
@.filename1 = N'C:\Program Files\Microsoft SQL
Server\MSSQL$MSDE\Data\test.mdf',
@.filename2 = N'C:\Program Files\Microsoft SQL
Server\MSSQL$MSDE\Data\test_log.ldf'
Could you please mail me (changliw@.microsoft.com) the SQL error logs and a
screenshot of the error message for further research?
By default, the error logs of SQL Server 2005 instance are located in
"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG". You may check it
if there are multiple instances installed on your computer.
Sincerely yours,
Charles Wang
Microsoft Online Community Support
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||Hi Gary,
I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
I will be more than happy to be of assistance.
Have a great day!
Charles Wang
Microsoft Online Community Support

Meta data??

Hi,
We have about 50 databases all of them are being merge replicated. On a
average , each database has about 150 tables which are published.
We get meta data retention error atleast one per week on a average. We have
two category of users, Users at the publisher server when they log (dialup
or dedicated Network) .Users logging on to the subscriber server -no dial up
always via dedicated network.
We notice meta-deta retention error message only when users connect to the
publisher server, that too when people dial up. Does this indicate any clues
?
Alternatively, to solve this meta-deta retention error ,we plan to drop
publication/delete replication and redo the replication setup process for
the database , where this error happens atleast once in a month. Does this
solve this problem. Is there any other solution ?
Please advise
Thanks,
Soura.
What is the exact error message or error number.
I don't understand how users come into the picture. Are you saying these
users are pulling the subscriptions? Are you using Windows Synchronization
Manager.
Dropping a publication and recreating it will definitely clean up merge
replication meta data, but there should be better ways of doing this.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"SouRa" <SouRa@.discussions.microsoft.com> wrote in message
news:68164873-E280-4B01-B8C8-54502CC2E4A4@.microsoft.com...
> Hi,
> We have about 50 databases all of them are being merge replicated. On a
> average , each database has about 150 tables which are published.
> We get meta data retention error atleast one per week on a average. We
> have
> two category of users, Users at the publisher server when they log (dialup
> or dedicated Network) .Users logging on to the subscriber server -no dial
> up
> always via dedicated network.
> We notice meta-deta retention error message only when users connect to the
> publisher server, that too when people dial up. Does this indicate any
> clues
> ?
> Alternatively, to solve this meta-deta retention error ,we plan to drop
> publication/delete replication and redo the replication setup process for
> the database , where this error happens atleast once in a month. Does this
> solve this problem. Is there any other solution ?
> Please advise
> Thanks,
> Soura.
>
|||Thanks for you response Mr Cotter. We have provided answers for your further
questions.
1. Error message : The merge process could not perform retention-based meta
data cleanup in database 'database name'".
2. No. We are NOT using Windows Synchronization Manager.
3. The users dialing up are not pulling the subscriptions, since they
connect only to the publiser. We notice the above error message once these
users connect after this replication error, we also notice timeout error.
When users log-out and log-in replication works normally as usual and
timeout message also gets solved.
4. You are right, there should be some better ways cleanup of meta deta,
besides droping and recreating. Eager to know what are they, so that we can
solve this problem.
thanks
Soura.
"Hilary Cotter" wrote:

> What is the exact error message or error number.
> I don't understand how users come into the picture. Are you saying these
> users are pulling the subscriptions? Are you using Windows Synchronization
> Manager.
> Dropping a publication and recreating it will definitely clean up merge
> replication meta data, but there should be better ways of doing this.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "SouRa" <SouRa@.discussions.microsoft.com> wrote in message
> news:68164873-E280-4B01-B8C8-54502CC2E4A4@.microsoft.com...
>
>

Meta Data Cleanup Error

Hi,
We are Merge replicating about 50 Production databases. We had planned to
monitor the meta deta clean up error during replication.
While we were monitoring the data to be updated during replication in one of
these databases, noticed 4 records to be merge replicated ( 3 insert and 1
update). At this moment we noticed the meta data clean up error. "The merge
process could not perform retention-based meta data cleanup in database
'database name'". The replication was in retrying mode and additionally the
following errors were reported
a) The subscription to publication 'XXXX' is invalid.
b) The process is running and is waiting for a response from one of the
backend connections'
During this process there we no issues in the remaining 49 databases,
replication was proceeding as usual.
In this database where we noticed the the above errors, the replication was
in sync in another 10 minutes, without any manual intervention.
What triggers to raise these error messages.
Please let us know what correction action we need to take for these error
messages
Thanks,
Soura.
Hi,
I got it from One article...
"The most common reason I can think of is that the query timed out. Sometime
retention based cleaup may need to cleanup a lot of rows and that can take
time. Rerunning the merge with a larger value for the querytimeout parameter
should fix this problem."
Hope this will help
Herbert
"SouRa" wrote:

> Hi,
> We are Merge replicating about 50 Production databases. We had planned to
> monitor the meta deta clean up error during replication.
> While we were monitoring the data to be updated during replication in one of
> these databases, noticed 4 records to be merge replicated ( 3 insert and 1
> update). At this moment we noticed the meta data clean up error. "The merge
> process could not perform retention-based meta data cleanup in database
> 'database name'". The replication was in retrying mode and additionally the
> following errors were reported
> a) The subscription to publication 'XXXX' is invalid.
> b) The process is running and is waiting for a response from one of the
> backend connections'
> During this process there we no issues in the remaining 49 databases,
> replication was proceeding as usual.
> In this database where we noticed the the above errors, the replication was
> in sync in another 10 minutes, without any manual intervention.
> What triggers to raise these error messages.
> Please let us know what correction action we need to take for these error
> messages
> Thanks,
> Soura.

Message when click on login user

Hi all,
I restored 4 databases onto another SQL server and added
sql logins. When I click on a login under
Security I get this message?
"One or more databases are inaccessible and will not be displayed in the
database access tab"
I don't understand this message and couldn't find anything on it.
thanks
gvA database is off line, in standby, suspect, recovering,
etc. Check the statuses of your databases. Did you fully
restore all of them or is one of the restored databases
still recovering?
-Sue
On Thu, 12 Oct 2006 12:25:41 -0400, "gv"
<viator.gerry@.gmail.com> wrote:

>Hi all,
>I restored 4 databases onto another SQL server and added
>sql logins. When I click on a login under
>Security I get this message?
>"One or more databases are inaccessible and will not be displayed in the
>database access tab"
>I don't understand this message and couldn't find anything on it.
>thanks
>gv
>|||Still looking into this
thanks for your help
gv
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:c7ati2d5j4evg2inafemok4d44d2jckim6@.
4ax.com...
>A database is off line, in standby, suspect, recovering,
> etc. Check the statuses of your databases. Did you fully
> restore all of them or is one of the restored databases
> still recovering?
> -Sue
> On Thu, 12 Oct 2006 12:25:41 -0400, "gv"
> <viator.gerry@.gmail.com> wrote:
>
>

merging two databases into single one

Hi,
I have two databases.i would like to joing these two databases
into single one.How should i do it?
Example:
I have database named DatabaseA and its size was increased very high
so i renamed to DatabaseA_old & create new database DatabaseA.I have
upgraded the server and increased the database size.Now i would like
to make a single database.
Please help me.
Regards,
Vijay
Create a new Database and use Import/Export Wizard to Import the Data
from database DatabaseA_old .
Well you have to attach the DatabaseA_old first and then do a import.
|||That depends on the exact nature of your 'merge'. There is no single command
to accomplish the 'merge'. But in general you need to script out all the
objects in your old database, create them in the new database--if not already
there, and insert the data from the old database into the corresponding
tables in the new database.
Inserting data may be done with INSERT, SELECT INTO, or bulk copy out
followed by bulk copy in.
It's a good practice to script out the entire 'merge' procedure.
Linchi
"Vijay" wrote:

> Hi,
> I have two databases.i would like to joing these two databases
> into single one.How should i do it?
> Example:
> I have database named DatabaseA and its size was increased very high
> so i renamed to DatabaseA_old & create new database DatabaseA.I have
> upgraded the server and increased the database size.Now i would like
> to make a single database.
> Please help me.
> Regards,
> Vijay
>

merging two databases into single one

Hi,
I have two databases.i would like to joing these two databases
into single one.How should i do it?
Example:
I have database named DatabaseA and its size was increased very high
so i renamed to DatabaseA_old & create new database DatabaseA.I have
upgraded the server and increased the database size.Now i would like
to make a single database.
Please help me.
Regards,
VijayCreate a new Database and use Import/Export Wizard to Import the Data
from database DatabaseA_old .
Well you have to attach the DatabaseA_old first and then do a import.|||That depends on the exact nature of your 'merge'. There is no single command
to accomplish the 'merge'. But in general you need to script out all the
objects in your old database, create them in the new database--if not alread
y
there, and insert the data from the old database into the corresponding
tables in the new database.
Inserting data may be done with INSERT, SELECT INTO, or bulk copy out
followed by bulk copy in.
It's a good practice to script out the entire 'merge' procedure.
Linchi
"Vijay" wrote:

> Hi,
> I have two databases.i would like to joing these two databases
> into single one.How should i do it?
> Example:
> I have database named DatabaseA and its size was increased very high
> so i renamed to DatabaseA_old & create new database DatabaseA.I have
> upgraded the server and increased the database size.Now i would like
> to make a single database.
> Please help me.
> Regards,
> Vijay
>

merging two databases into single one

Hi,
I have two databases.i would like to joing these two databases
into single one.How should i do it?
Example:
I have database named DatabaseA and its size was increased very high
so i renamed to DatabaseA_old & create new database DatabaseA.I have
upgraded the server and increased the database size.Now i would like
to make a single database.
Please help me.
Regards,
VijayCreate a new Database and use Import/Export Wizard to Import the Data
from database DatabaseA_old .
Well you have to attach the DatabaseA_old first and then do a import.|||That depends on the exact nature of your 'merge'. There is no single command
to accomplish the 'merge'. But in general you need to script out all the
objects in your old database, create them in the new database--if not already
there, and insert the data from the old database into the corresponding
tables in the new database.
Inserting data may be done with INSERT, SELECT INTO, or bulk copy out
followed by bulk copy in.
It's a good practice to script out the entire 'merge' procedure.
Linchi
"Vijay" wrote:
> Hi,
> I have two databases.i would like to joing these two databases
> into single one.How should i do it?
> Example:
> I have database named DatabaseA and its size was increased very high
> so i renamed to DatabaseA_old & create new database DatabaseA.I have
> upgraded the server and increased the database size.Now i would like
> to make a single database.
> Please help me.
> Regards,
> Vijay
>