Log Explorer Vs. ApexSQL Log Vs. SQL Log-Rescue

Jun 8, 2006

Opinions?

I've installed all three to try'em out and they all seem to be working
so far, more or less.

Log Explorer has given me a couple of errors but I started over and
continued OK.

ApexSQL Log squawked about "redo for delete cannot be generated for
tables lacking clustered index". Huh? What the...? We have lots of
tables without a clustered index.

I read some reports in Red-Gate's technical support forum about their
product actually bringing down SQL Server. That did not inspire
confidence.

All three install some server-side components like extended stored
proc's which I'm not crazy about and I think all three are server or
instance licensed (does anyone actually purchase more than one license
when it seems like you can easily move any tran log to be analyzed to
the server the product is installed on?). I don't think I'd want to
install any of them on a Production server, at least one that I'm
responsible for!


Thanks,

Martin

View 1 Replies


ADVERTISEMENT

ApexSQL Lockwood Tech ,Anybody's Using It ?

Jan 9, 2004

I just got their demo but having problems with running ApexSQLDiff , any feedback how it works for others?
Maybe there are some other tools worth looking at ?
Thanks for any suggestions

View 7 Replies View Related

How I Rescue Data From Corrupted Databases

Mar 7, 2007

Edit: Some changes added

This is my procedure for "rescuing" data from a corrupted database. Obviously restoring from backup is a lot easier!

0) Set the damaged database to Read-Only. if you don't have a backup make one now.

1) Script the database

2a) Create a new, TEMP database - preferably on a different machine in case of hardware problems on the original machine

2b) Size the Data for the TEMP database same size as the original (to avoid dynamic extensions). Size the Log something large-ish!

3) Run the Script on the TEMP database. Do NOT create any FK etc. yet

4a) Attempt to transfer all tables:

-- Prepare script of: INSERT INTO ... SELECT * FROM ...
SET NOCOUNT ON
SELECT 'PRINT ''' + name + '''' + CHAR(13) + CHAR(10) + 'GO' + CHAR(13) + CHAR(10)
+ CASE WHEN C.id IS NULL
THEN ''
ELSE 'SET IDENTITY_INSERT dbo.[' + name + '] ON' + CHAR(13) + CHAR(10)
END
+ 'INSERT INTO MyTempDatabase.dbo.[' + name + ']' + CHAR(13) + CHAR(10)
+ 'SELECT * FROM dbo.[' + name + ']' + CHAR(13) + CHAR(10)
+ CASE WHEN C.id IS NULL
THEN ''
ELSE 'SET IDENTITY_INSERT dbo.[' + name + '] OFF' + CHAR(13) + CHAR(10)
END
+ 'GO'
FROMdbo.sysobjects AS O
LEFT OUTER JOIN
(
SELECT DISTINCT C.id
FROMdbo.syscolumns AS C
WHEREC.colstat = 1-- Identity column
) AS C
ON C.id = O.id
WHERE type = 'U'
AND name NOT IN ('dtproperties')
ORDER BY name
SET NOCOUNT OFF

this generates statements like this:

PRINT 'MyTable'
GO
SET IDENTITY_INSERT dbo.[MyTable] ON
INSERT INTO RESTORE_XFER_TEMP.dbo.[MyTable]
SELECT * FROM dbo.[MyTable]
SET IDENTITY_INSERT dbo.[MyTable] OFF
GO

4b) This will give some sort of error on the tables which cannot be copied, and they will need to be rescued by some other means.

5a) Each "broken" table needs to be rescued using an index. Ideally you will have a clustered index on the PK and that will be undamaged, so you can "rescue" all the PKs into a temp table:

-- Copy PK fields to a temporary table
-- DROP TABLE MyRestoreDatabase.dbo.TEMP_RESCUE_PK
-- TRUNCATE TABLE MyRestoreDatabase.dbo.MyBrokenTable
SELECT[ID]=IDENTITY(int, 1, 1),
[IsCopied]=CONVERT(tinyint, 0),
MyPK
INTOMyRestoreDatabase.dbo.TEMP_RESCUE_PK
FROMMyBrokenDatabase.dbo.MyBrokenTable
ORDER BY MyPK

5b) If that is successful you have a list of all the PKs, so can can try to copy data matching those PKs, in batches:

-- If OK then selectively copy data across
-- First Prep. a temp Batch table
-- DROP TABLE MyRestoreDatabase.dbo.TEMP_RESCUE_BATCH
SELECT TOP 1 [ID]=CONVERT(int, NULL), [IsCopied]=CONVERT(bit, 0), MyPK
INTOMyRestoreDatabase.dbo.TEMP_RESCUE_BATCH
FROMMyRestoreDatabase.dbo.TEMP_RESCUE_PK
GO
--
DECLARE@intStartint,
@intStopint,
@intBatchSizeint

-- NOTE: After the first run set these to any "gaps" in the table that you want to fill
SELECT
@intStart = 1,
@intBatchSize = 10000,
@intStop = (SELECT MAX([ID]) FROM MyRestoreDatabase.dbo.TEMP_RESCUE_PK)

SELECT@intStart = MIN([ID])
FROMMyRestoreDatabase.dbo.TEMP_RESCUE_PK
WHERE IsCopied = 0
AND [ID] >= @intStart

WHILE@intStart < @intStop
BEGIN
SET ROWCOUNT @intBatchSize

-- Isolate batch of Keys into separate table
TRUNCATE TABLE MyRestoreDatabase.dbo.TEMP_RESCUE_BATCH
INSERT INTO MyRestoreDatabase.dbo.TEMP_RESCUE_BATCH
SELECTT.*
FROMMyRestoreDatabase.dbo.TEMP_RESCUE_PK AS T
WHERE IsCopied = 0
AND [ID] >= @intStart
AND [ID] < @intStart + @intBatchSize

-- Attempt to copy matching records, for this batch
PRINT CONVERT(varchar(20), @intStart)
INSERT INTO MyRestoreDatabase.dbo.MyBrokenTable
SELECTS.*
FROMMyRestoreDatabase.dbo.TEMP_RESCUE_BATCH AS T
LEFT OUTER JOIN MyRestoreDatabase.dbo.MyBrokenTable AS D
ON D.MyPK = T.MyPK
-- This will try to get the data from the broken table, it may fail!
JOIN MyBrokenDatabase.dbo.MyBrokenTable AS S
ON S.MyPK = T.MyPK
WHERED.MyPK IS NULL-- Belt and braces so as not to copy existing rows

-- Flag the rows just "Copied"
UPDATEU
SETIsCopied = 1
FROMMyRestoreDatabase.dbo.TEMP_RESCUE_PK AS U
WHEREIsCopied = 0
AND [ID] >= @intStart
AND [ID] < @intStart + @intBatchSize

-- Loop round, until done
SELECT@intStart = @intStart + @intBatchSize
END
GO
SET ROWCOUNT 0-- Turn OFF!!
GO

5c) This will copy in batches of 10,000 [you can adjust @intbatchSize depending on table size] until it gets to a damaged part of the table, then it will abort.

Change the @intStart to the last ID number displayed, and reduce @intBatchSize (by an order of magnitude each time) until you have rescued as many records as possible in the first "part" of the table.

5d) Reset the batch size @intBatchSize to 10,000 [or whatever size is appropriate], and increase the @intStart repeatedly until you are past the damaged section - copying will start again, and will abort if there are further damaged sections

5e) Repeat that process until you have rescued as much of the data as is possible

6) Check what is left to be rescued

-- Check amount NOT done:
SELECTCOUNT(*), MIN([ID]), MAX([ID])
FROMMyRestoreDatabase.dbo.TEMP_RESCUE_PK
WHERE IsCopied = 0
--AND [ID] > 123456-- Optionally count items after a "gap"
--
-- Double check that IsCopied set correctly, and the number of records "lost"
SELECTCOUNT(*),
[IsCopied] = SUM(CONVERT(int, IsCopied)),
[IsCopied+Record] = SUM(CASE WHEN IsCopied = 1 AND C.MyPK IS NOT NULL THEN 1 ELSE 0 END),
[IsCopiedNoRecord] = SUM(CASE WHEN IsCopied = 1 AND C.MyPK IS NULL THEN 1 ELSE 0 END),
[IsNOTCopied] = SUM(CASE WHEN IsCopied = 0THEN 1 ELSE 0 END),
[IsNOTCopied+Record] = SUM(CASE WHEN IsCopied = 0 AND C.MyPK IS NOT NULL THEN 1 ELSE 0 END),
[IsNOTCopiedNoRecord] = SUM(CASE WHEN IsCopied = 0 AND C.MyPK IS NULL THEN 1 ELSE 0 END)
FROMMyRestoreDatabase.dbo.TEMP_RESCUE_PK AS T
LEFT OUTER JOIN MyRestoreDatabase.dbo.MyBrokenTable AS C
ON C.MyPK = T.MyPK
--
-- List of "Lost" records
SELECTMyPK
FROMMyRestoreDatabase.dbo.TEMP_RESCUE_PK
WHERE IsCopied = 0
ORDER BY [ID]

You will then have to "find" and rescue the lost records somewhere.

I have a further process using OPENQUERY() to rescue records to fill the gaps in the event that they are available on a remote system - a straight JOIN to get them is going to be far to slow on anything other than tiny tables!

7a) Create the FKs etc. Update the statistics, rebuild indexes, and possibly shrink the Log if it is unrealistically big
7b) Backup and Restore over the original database
7c) DBCC CHECKDB ('MyDatabaseName') WITH ALL_ERRORMSGS, NO_INFOMSGS

Good luck!

Kristen

View 4 Replies View Related

Please Need Rescue- Complex Update Logic Swap

May 14, 2008

please need rescue- complex update logic
this is my table







1

2

3

4

5

EMPID
fld1
fld11
fld111
fld2
fld22
fld222
fld3
fld33
fld4
fld44

fld444
fld5
fld55
fld555


















1111

A

B

C

7

8

9

G

H

I

J

K

L

M

N


















2222

N

M

L

K

J

I

H

G

F

E

D

C

B

A


















3333

1

2

3

A

B

C

C

E

Y

I

O

W

Y

P




















i need to update for example the eployee 1111 with employee 3333
but with swap ( take the value of employee 1111 in field- fld2,fld22,fld222 and swap value between employee 3333
in field- fld2,fld22,fld222 )



Code Snippet
---update eployee 1111 with employee 3333
-so
if i put the value 2
than ------------------ swap value between 2 employee
set empid1= 1111
set empid2=3333
value_swap=2
if value_swap=2
than
update fld2,fld22,fld222
with fld2,fld22,fld222
------------------- take the value of employee 1111 in field- fld2,fld22,fld222 and swap value between employee 3333
--------------------in field- fld2,fld22,fld222








value_swap

=1

=2

=3

=4

=5

EMPID
fld1
fld11
fld111
fld2
fld22
fld222
fld3
fld33
fld4
fld44

fld444
fld5
fld55
fld555


















1111

A

B

C

A

B

C

G

H

I

J

K

L

M

N


















2222

N

M

L

K

J

I

H

G

F

E

D

C

B

A


















3333

1

2

3

7

8

9

C

E

Y

I

O

W

Y

P



















Code Snippet
---update eployee 2222 with employee 1111
-so
if i put the value 5
than ------------------ swap value between 2 employees
set empid1= 1111
set empid2=2222
value_swap=5
if value_swap=5
than
update fld5,fld55,fld555
with fld5,fld55,fld555
------------------- take the value of employee 1111 in field- fld5,fld55,fld555 and swap value between employee 3333
--------------------in field- fld5,fld55,fld555













=1

=2

=3

=4

=5

EMPID
fld1
fld11
fld111
fld2
fld22
fld222
fld3
fld33
fld4
fld44

fld444
fld5
fld55
fld555


















1111

A

B

C

7

8

9

G

H

I

J

K

W

Y

P


















2222

N

M

L

K

J

I

H

G

F

E

D

C

B

A


















3333

1

2

3

A

B

C

C

E

Y

I

O

L

M

N















TNX FOR ALL THE HELP I GET IN THIS Forum

View 7 Replies View Related

How Can I Return A Database From The DataBase Explorer Of VB 2005 Express To The Object Explorer Of SQL Server Management Studio

Mar 3, 2008

Hi all,

I just realized recently that a database "XYZ" in the Object Explorer of my SQL Server Management Studio Express (SSMSE) is put in the Database Explorer of my VB 2005 Express for processing a Stored Procedure in executing the SELECT statements (not by using Input and/or Output Parameters) during the ADO.NET 2.0-VB 2005 Express programming, then the content of the database "XYZ" is not in the SSMSE. How can I return the database "XYZ" from the DataBase Explorer of VB 2005 Express back to the Object Explorer of SQL Server Management Studio Express (SSMSE) safely? Please help and advise.

Thanks in advance,
Scott Chang

View 6 Replies View Related

Object Explorer And Object Explorer Details

Apr 23, 2008

SQL server 2005:
How to view or open tables under object explorer details, when i double click an object under object explorer.

thats how the default settings used to be.

now when i double click any object or try to open query analyzer it is open in the same left side pane on top of Object explorer window.

i did something to my explorer and explorer details panes since then both are separated, they are not getting synchronized.

Thanks for your help.

View 1 Replies View Related

LOG Explorer

Apr 27, 2007

Hello there... I had an intrusion into my DB and I'd like to analizethe log looking for the moment and the IP the modification was.Does anyone know about free software for this?Thank you.

View 2 Replies View Related

Explorer?

Jul 20, 2005

With Oracle, there is a comprehensive tool called SQL Navigator as well asTOAD. Does such a tool exist for SQL Server 2000?@drian.

View 2 Replies View Related

Object Explorer

Jun 2, 2007

I am using vs 2005 to connect to a remote database. I dont have remote access or any other type of access. I need to setup some constraints on the database, but the object explorer is missing. How can Iincorporate this tab into vs

View 1 Replies View Related

Can't See Server Explorer

Sep 18, 2007

Hi,

I just installed 2005 Evaluation version (high spec laptop but running Windows XP Home edition).

Have opened SQL Server Management Studio then set up a dummy database with a table and a query then tried opening the Server Explorer.

I understand that Server Explorer should be on the 'View' tab with, say, Object Explorer but I can't see it.

Does the fact I am running this on XP Home edition have anything to do with it? Or do I need to run another SETUP.EXE or configure some options or is it something else?

When I installed SQL Server 2005 I got one error message saying:

quote:- IIS Feature Requirement (Warning)
Messages
IIS Feature Requirement

Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.

Does Server Explorer need IIS to be running in order to work?

Help will be very appreciated.

Thanks in advance.

View 12 Replies View Related

Template Explorer

Nov 7, 2007

Hi,
Is there any way to change path for template explorer? Default path for SQL templates is ..Application DataMicrosoftMicrosoft SQL Server90ToolsShellTemplatesSql. I have scripts & would like to share with my teammates. Is there any way to set this path to a common folder so that whenever anybody connects with their login to our TS server, they should be able to see these scripts in template explorer.

Thanks in advance
Sandesh

View 2 Replies View Related

Red-Gate SQL Log Explorer

Jul 14, 2006

Does anyone happen to know if the folks at Red-Gate used a public SDKto create the log explorer, or did they fork over money to microsoft toget a ISV licensed SDK?I'm looking into making a similar product that would be open source,and I'm trying to figure out what they used to translate entries in thelog to something that is readable by the human eye.Thanks.....

View 1 Replies View Related

Object Explorer

Mar 24, 2006

Hello All;

I downloaded the VWD2005 recentrly, it was really agiant achievement , i appreciate the people who developed such an easy-to-learn web development package. I noticed the difference between VS2002 and VWD2005. I really liked it. (i am sorry if this speech isn't in its right place). Here i have an enquiry, I downloaded the the VWD2005, but i haven't seen the Object Explorer(SQLExpress), although it was included in the downloades?

Thanks alot

View 3 Replies View Related

Connection Explorer

Nov 9, 2007



I am using MS SQL Server Managment Studio 2005 - I also use the old Enterprise Manager from time to time. My questions are about making SMS2005 more user friendly.

I) Is there a way to keep the list of server connections displayed in the object explorer after the application is closed and re-opened?

II) Is there a way to save the password in the "Connect Object Explorer" so I don't have to keep confirming the password to enable the connection?

In summary: In Enterprise Manager, the database engines are always displayed in the Object Explorer and are automatically connected upon opening the manager. Is this functionality possible in SMS2005?

View 3 Replies View Related

Not Available In Object Explorer

Feb 15, 2007

Im new to Sql Server CE and I am following the procedure in books online to create a new database. Through Sql Server Management Studio, I have version 9.00.2047, books online says to click connect through Object Explorer and then select Sql Server Compact Edition. I dont see this option. I see Sql Server Mobile. Is it the same thing or am I missing something?



Thanks,

Jesse

View 3 Replies View Related

Don't Display Dbo. In Object Explorer

Jun 4, 2007

Is there a way to stop SQL Server Management Studio (2005) from showing "dbo." on everything in the object explorer.
I'd love to turn that off on a database I'm working on as, for example, if you have to find tblMember, you'd have to type d-b-o-.-t-b-l-m before you can actually start jumping to the table you're interested in - whereas in Enterprise Manager (2000) you'd only have to type t-b-l-m if you get my meaning.

View 2 Replies View Related

Server Explorer Problem

Oct 12, 2005

I am trying to establish a connection to a SQL server using server explorer. I have tried both the DNS name and the IP address and get this message: "Could not reconnect to "sqlserver". Make sure the machine name and path are valid.When I go to Enterprise Manager and enter the IP address, I can successfully establish a connection.What gives? Is this a VS problem?

View 4 Replies View Related

DBxtra Data Explorer

Oct 8, 2004

DBxtra Data explorer
DBxtra version 1 is ready.
You can connect to unlimited MS Access, MS SQL Server, Paradox, PDF and Excel tables and queries.
Get the sense out of your data!1
1. Connect to your data
2. Explore your data
3. Design and deploy your reports
4. Export your data
5. Send your data by E-mail
6. Schedule reports and alerts
Try the free Download!
http://www.dbxtra.com

View 6 Replies View Related

View From Windows Explorer

Nov 2, 2005

From Windows Explorer, the modified date of the database file is not updated. Why?

I assumed the modified date of the .MDF/.LDF files will be updated when transaction is made to database. Am I correct?

View 4 Replies View Related

More Than Oneserver In Server Explorer

May 31, 2007

Dear All,
Can I add more than one server in ServerExplorer bar.I wll use Client Server utility to add create a alias of a same server and add more than one server in SQL 2000. How can do this in SQL 2005

Thanks in Advance
Dana

View 1 Replies View Related

Hide 'New Subscription' In The Explorer Bar

Jan 25, 2007

Hello

We do not want the end users to know of the subscription capability. How do we hide 'New Subscription' link for a report.

Thanks

View 6 Replies View Related

SQL CE Mobile In VS.Net Server Explorer

Jul 10, 2006

Hi,
I have a couple of MS SQL 2005 Mobile edition databases that I was using previously.
I am now not able to open them, I have not used them for about 3 weeks and do not recall doing anything 3 weeks ago to cause them to fail (Except maybe SQL Server 2005 install, not CE/Mobile).
 
There is no option for adding a connection to SQL Mobile 5 DB (or CE2.0 for that matter, which is also installed) when adding new data connection in VS.NET Server Explorer.

The databases seem to work fine when on the device, my probelm is accessing the database file .sdf from VS.NET.
I have tried uninstalling and reinstalling SQL Server Mobile 2005 several times with no luck.
I am developing on XP Prof with VS.net 2005 for Pocket PC Phone 2003 and 2005


If I click on the already existing connection I get message "The Provider was not found"

If I click on the file directly from VS.net  get a message
"There is no editor available for 'C:lahb;ah.sdf' Make sure the application for the file type (.sdf) is installed"

I have been using these databases for some time and desperately need them back.
ANY assistance or comment would be appreciated.
Rod

View 1 Replies View Related

Internet Explorer Is Block

Dec 17, 2007



Help! On my desktop some security warning came up and my friend clicked "ok" when it said "block". Apparently it was warning her that internet explorer was trying to contact the internet. So...now internet explorer cannot display anything and it is the only browser I have on my computer. I am so frustrated I can't figure out what on earth I can change to fix this. Please...someone help me figure out why I can't contact the internet? My internet connection is fine, and the troubleshooting feature in explorer keeps telling me so.



Thanks!

View 1 Replies View Related

Solution Explorer And SQL Server

Dec 12, 2005

I am a Visual Studio .net developer and understand Solutions and Projects in VS.net.  Nevertheless, it appears that the paradigm of using Solutions Explorer in SQL Server is not exactly the same.  That is, in Visual Studio you can't get anything done without creating a solution first.  In SQL Server, it is entirely possible to get a lot done without a solution and the ability to create and make use of a solution seems almost an after thought or an add-on.
I am particularly interested in using a solution in SQL Server to allow me to make use of SourceSafe.  In the past, we jumped through all kinds of hoops to keep a running trail of changes we had made to (for example) stored procedures.  It appears now that this can be managed more efficiently with the use of a Solution and SourceSafe and saving scripts or .sql files.  I guess it is not possible to save a pristine copy of a stored procedure directly in SourceSafe, but you can save the code that makes up the stored procedure as a .SQL file which I suppose is about as good.
Anyway, what I would like to know is whether there is a good white paper (or chapter in a book) on the philosophy behind Solutions and projects in SQL Server and how MS intends us to use them; perhaps something other than the cold facts from the documentation.  I would appreciate something more that gives me the big picture on just how MS sees them being used in SQL Server so I can get the most out of them.  I have the feeling that if I "get the vision", they are meant to be an integral part of SQL Server now and in the future.
Woody

View 3 Replies View Related

Server Explorer (VS.NET) Vs. Enterprise Manager

Nov 26, 2005

Hello,I'm having the following dilemma: I'm trying to connect to a database on a SQL Server, somewhere else in the country. - With Server Explorer in VS.Net it is no problem at all. New dataconnection: i fill in the ip-adress, user and pass, and the database-name i want to connect to, and voila, it's done. I can add, edit, delete everything.- With enterprise manager: With enterprise manager i can make a connection with the server, but after that the database isn't visible. And as far as i know i can't connect to a certain database. Another option i tried is to create a linked server on my local server: that does work, only now i can't add/edit/delete..I really want to work with enterprise manager, but is there any way to connect to one db only, and still be able to add/edit/delete ?? I can't find the solution..Please help..Much regards..J.JansmaThe netherlands

View 1 Replies View Related

Can You Give Me A Free Version Of &#34;Log Explorer&#34;

Aug 20, 2001

Can you give me a free version of "Log Explorer"

View 2 Replies View Related

Server Explorer 2003 Trouble

Apr 21, 2004

I recently installed VISUAL STUDIO .NET 2003 and SQL SERVER 2000 personal edition on my XP system.
I also applied service pack 3a to it. I use windows integrated security, and server runs from it's system account (SA).
The problem is that I cannot create tables, views, procedures or databases from SERVER EXPLORER. I can do it through Enterprise Manager. When I install destop engine instead of sql server it's OK, but when it's SQL server personal edition, then it's a problem. I tried giving my account, and my account group (builtin/administrators) all rights and privilegies I could think of, but it still doesn't work.
I did not have this problem vith previous version of Visual Studio .net.
I think it's something about security and permissions.
Any suggestions ?
Thx in advance.........

View 5 Replies View Related

Internet Explorer Page Not Found

Jun 11, 2007

Greetings All,

I installed SQL 2000 with SP4 on a 2003 Server. I added a NT Group to the Server and created 2 users exactly the same in the SQL Server Enterprise Manager.

My issuse is with the other user I created. When I go to a database in the Server Enterprise Manager and right click on tables, and select New Table with my user, the New Table window pops up with no problem. When the other user follows the exact same steps, Internet Explorer opens up and says page not found.

Is this an SQL Issue or maybe an IIS issue?

Thanks in advance.

View 9 Replies View Related

View Won't Show In Object Explorer

Jul 18, 2007

A view I created won't show up in "views' in Object Explorer, but will only show up when I script for it (Select * from blah). It also won't go into the ODBC. why?

View 8 Replies View Related

Can LOG PI Or Log Explorer Recover Deleted Records BEFORE

Jan 11, 2006

installation of their softwares? If there has NEVER been a backup ofthe Database (.mdf), Recovery Model Set to Full, and there has neverbeen a backup of the Log (.ldf) files?Using the trial software for both, this was unclear.Thank you for your time,bd

View 2 Replies View Related

MSDE No Show In Server Explorer

Feb 3, 2006

I have installed default instance of SQLServer 2005 DE on Windows Server 2003 host. I also installed a named instance of MSDE rel A. I can connect to the MSDE instance from Management Studio but it does not appear in the list of servers when I try to add the connection in VS2005 server explorer. What am I doing wrong?

- Dick

View 4 Replies View Related

Create Folders In Object Explorer - Wish...

May 4, 2007

Here's one thing that I'd like to see come out in some version of the SQL Server Management Studio...
The ability to create folders under the database node so that databases can be grouped on one server.

We have over 100 databases on our development server and these are created by a range of consultants and developers and even support staff as needed.

Being able to group the databases by product, etc would be a nice touch since we have client databases that don't fit naming conventions etc.

Multiple instances are another way around this but are expensive and resource hungry - we develop and support models, not use them for transactions too much.



Yes there are 'better' ways such as setting security correctly but we are too busy working and not maintaining.

Folders or database groups would be a nice touch.



Cheers

View 1 Replies View Related

SSMS Cannot Connect Through Object Explorer To Anything

May 16, 2006

I've installed SQL Server 2005 SP1 RTM on a Windows 2003 R2 machine (machine A), and my local workstation (machine B).

From machine B, I can use SSMS to connect to SQL Server on machine A. This is using either "New Query" or "Object Explorer".

However, on machine A, SSMS can only connect to machines A or B using the "New Query" option. If I try "Object Explorer" for either, I get the error message "Failed to retrieve data for this request... urn could not be resolved at level Configuration."

I'm not sure what died (no pun intended) since the last time this worked. Any thoughts on this?

View 1 Replies View Related







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