How can I Query Analyze DB Greater than 128MG

I have a 300MG DB and Query Analyzer gives me the "... DB larger than configured..." error when I try to connect to it...

What is the work around?

Thanks in advance

JEK

If you have sql server 2005 you can use the sql server management studio to connect to your sql ce (.sdf) database.
|||In SQL Server Management Studio, in the Connect To Server dialog, click "Options >>", and you will be able to increase the max db size from the default of 128 MB.|||I need to use Query Analyzer 3.0 on the Handheld|||There is no workaround this "bug". Await the next version or move the SDF file to your desktop and use one of the tools mentioned above.

How can I Query Analyze DB Greater than 128MG

I have a 300MG DB and Query Analyzer gives me the "... DB larger than configured..." error when I try to connect to it...

What is the work around?

Thanks in advance

JEK

If you have sql server 2005 you can use the sql server management studio to connect to your sql ce (.sdf) database.
|||In SQL Server Management Studio, in the Connect To Server dialog, click "Options >>", and you will be able to increase the max db size from the default of 128 MB.|||I need to use Query Analyzer 3.0 on the Handheld|||There is no workaround this "bug". Await the next version or move the SDF file to your desktop and use one of the tools mentioned above.

How can I monitor my SQL?

Hi,

Today, I heard about Sql Profiler, and I seems to be a tool to monitor, analyze, and fine tune sql server. Is there a tool like this for SQL Server Express 2005?

thanks,
John

The SQL profiler comes apart of the SQL Server 2005 developer + editions. It is not available in express but i am sure there should be some free profilers around. You basically use a SQL profiler to see alot of things happening to a database, like viewing authentications, when a stored procedure runs and how often, the time it takes for a procedure to execute. You also can profile things like the broker service, and there is heaps more!