SQL2008 not responding when opening local files

MS SQL SERVER

    Sponsored Links

    Next

  • 1. Sql Server 2005 (32 bit) on Windows Server 2003 R2 (64 bit)
    Hi! If anibody could answer my question I would be gratefull: I have installed 64 bit version of WS 2003 R2 on my server and I bought Sql Server 2005 32 bit version (Standard). Are they compatible? Or must I buy the 64 bit version of Sql Server? Thank you a lot
  • 2. Unable to create login instance--why? what it means?
    When I try to install SQL Server 2000 Desktop Engine, I get the BPsetup error that says "Unable to Create a login instance." Then when I click ok it says "Unable to Add system server role." Then when I click ok it says "Unable to add login and grant access to database." Then it aborts setup. Any advice?
  • 3. Which More Stable? 2000 or 2005? PLS HELP
    TRying to decide whtehr to install 2000 or 2005 but need stability. Also, which is better (I think 2005 - but it may be too new to tell) . Also, I assume 2005 is more complicated to install and learn Can someone please advise Thank you
  • 4. Master database migration SQL2000 to 2005
    I have an existing, SQL 2000, server and I have a new server, SQL 2005 in a cluster with failover. I need all of my users transfered to the SQL 2005, which is the master db, I guess. I have read in Article 224071, that SQL 2005 can only accept SQL 2005 databases. So, will a backup from SQL 2000 and single user mode restore SQL 2005 work for the master db? Thanks, Brandon
  • 5. How to change the default location of a new databases?
    I'm using Sql Server 2000 and Enterprise Manager. If I change the default location for databases thru EM from "C:\data" to "D:\data", then new database files get created on D: ONLY if I use EM to create the databases. If I use the "create database" statement thru QA it creates them in the C:\data folder. What's going on here? Thx

SQL2008 not responding when opening local files

Postby amF5bG91 » Wed, 04 Nov 2009 05:22:01 GMT

I am evaluating Windows 7 professional for my company and so far the only 
bad feature I have found so far is when I am in SQL server 2008 Management 
studio, and I go to the folder to open an existing file on my local hard 
drive.  I click on the folder, wait about 20-30 seconds and it opens my 
documents\sqlstuff.  I click on the file I want to open and wait another 20 - 
30 seconds for it to open.  I have only noticed this in SQL management studio 
so far

Processor:  Intel(R) Core(TM)2 Duo CPU     P8400  @ 2.26GHz   2.27 GHz
Installed memory (RAM):   2.00 GB
System type:  32-bit Operating System

Please let me know if you need any more info.

TIA,
Joe




Similar Threads:

1.SQL Query Analyzer stop responding after save or open .qry file

Hi,
I have Sql Server 2K sp3 and I use SQL Query Analyzer (QA) to editing views, 
stored procedures, etc.., but from a few days I have a big problem.
When I try to save a sql script QA write a file and freeze it (on Task 
Manager I see "not responding"). To close QA I must use Task Manager to kill 
the process.
Otherwise when I try to open a previous saved sql script from QA I have this 
behaviour: load and execute correctly the script, but when I closed the MDI 
child windows (where I have load the sql script) the QA freeze it (on Task 
Manager I see "not responding"). To close QA I must use Task Manager to kill 
the process.

If someone have some suggestion to solve this problem?

Thanks in advance

Simon.


2.Not Responding - Open Recordset

On Tables, Imported from a TXT Flat file, with 8,805,141 Records - fields: 
IDx (PK, Indexed), Field1 (nvarchar, 132) - this code takes 18 minutes to 
open rst(n), or just errors out with a 'timeout'. 

Migrated to Access 12 on Vista Ultimate, Dual Opteron, 2 GB RAM. Am used to 
SQL 2000, Access 10, but they also are aborting with 'timeout'. The Vista 
online debugger did not find any system errors, so 'sent me' to this site  . 
. .

I have shrunk the database, and poked around with SSMS. I do notice that 
Views run real slow or timeout. What techniques am I missing for working with 
this large a dataset?

SAMPLE VB CODE:
Dim strSQL As String
Dim rst1 As New ADODB.Recordset
Dim rst2 As New ADODB.Recordset

strSQL = "SELECT TOP 100 PERCENT IDx, Field1 " _
& "FROM dbo.misys " _
& "ORDER BY IDx"
rst1.Open strSQL, CurrentProject.Connection, adOpenKeyset, adLockOptimistic

strSQL = "SELECT TOP 100 PERCENT IDx, Field1 " _
& "FROM dbo.misys4 " _
& "ORDER BY IDx"
rst2.Open strSQL, CurrentProject.Connection, adOpenKeyset, adLockOptimistic

Do While Not rst1.EOF
    If NOT (rst1!Field1 = rst2!Field1) Then
        Debug.Print Now()
        Debug.Print rst1!Field1
        Debug.Print rst2!Field1
        Debug.Print
        Stop
    rst1.MoveNext
    rst2.MoveNext
    End If
Loop

-- 
Aubrey Kelley

3.Non-Administrators Receive Read Only Mesage Opening Local ADE File

I developed a Access 2003 project with MSSQL back end.   I made a ADE file to 
remove the code on the copy that is distributed to client workstations.   
Users who are not administrators on the local machine receive an message when 
opening the ADE file:

"The Microsoft OfficeAccess project  will be opened read-only because one of 
the following occurred: 

The file is locked for editing by another user, or the file (or the folder 
in which it is located) is marked as read-only, or you specified that you 
wanted to open this file read-only"

I am hoping Microsoft does not require users to be administrators of the 
local machine to use a local copy of a access 2003 project .

Any help would be appreciated.



4.Opening local XML file

Good evening

I want to open a local XML file from my SQL script.

#1. If you are in some dev't environment such as .Net or script, you can 
open the file and pass it into the SQL script. But I want that within SQL 
script.

#2. You can write a CLR function to open it. I did. However I feel like pay 
too much for such a trivial job.

#3. I found a way to retrieve a file as base64 string. e.g.,

declare @b varbinary(max)
set @b=(select * from openrowset(bulk N'c:\x.xml', single_blob) as b)

That looks like decent base64 binary text which can be converted into XML 
stream easily, if you are in .Net. But how do you do that within SQL script?

Or is there another way #4, #5, ... I have not imagined?

#2 UDF
    public static SqlXml getdoc(string xmlPath)
    {
        XmlReader xr = XmlReader.Create(xmlPath);
        SqlXml retSqlXml = new SqlXml(xr);
        xr.Close();
        return (retSqlXml);
    }

-- 
Pohwan Han. Seoul. Have a nice day. 

5.DTS does not open on local box

I am unable to open or create DTS package on the local box 
(SQL Server 2000) .It throws up an error saying "The 
specified module not found" .

It does not run when scheduled as a job .

However it works fine from the client .

I am not sure what the problem is ? Please advise ?

6. Could not Bulk insert beacuse file could not be opened

7. About file naming for a backup file in sql2008

8. SQL2008 Express managed by machine with SQL2008 Standard?



Return to MS SQL SERVER

 

Who is online

Users browsing this forum: No registered users and 22 guest