Scripting tables in SQL Server 2008
Wed, 8 Apr 2009 16:00:03 -0700
When running scripting from MSM for tables; the defaults for tables are being
saved in seperate files from the main file for that table. This is a
different behavior than previous versions. Is there an option which needs to
be set to that defaults are saved to the same file for the table object.
i.e. whe ...
|
Management Studio 2008
Mon, 6 Apr 2009 12:04:09 -0700 (PDT)
For anyone who has ever used Visual Studio as well, the management
studio interface is very similar to what VS has had for a while. One
difference that bugs me is that in VS you can click the "Design Query"
button and quickly use the designer for the query right in the query
window. In MS, you have to open up t ...
|
Stop Connect To Server Prompt in Management Studio
Wed, 1 Apr 2009 09:12:02 -0700
At one time I was able to stop the "Connect to Server" prompt from displaying
when starting Management Studio.
I installed a new version and now I can't remember how to disable the prompt.
Any ideas>
...
|
Unable to SQL Server 2005 integration services
Tue, 31 Mar 2009 16:37:01 -0700
I am unable to start SQL Server 2005 integration services on my database
server.
Listed below is the error I received when trying to start SQL Server 2005
integration services.
Please help me resolve this issue.
Thanks,
Description:
The SQL Server Integration Services service failed to start due t ...
|
Automatically loading Profiler rollover files in SQL2005
Mon, 30 Mar 2009 01:51:01 -0700
Hi,
We have a large number of Profiler trace rollover files, that have been
generated by a server-side trace, but when loading the first file into the
GUI the subsequent files are not loading or being prompted to load?
This works fine if the files are generated by the GUI but not when they are
generated ...
|
Select Top X Rows - Opens in Master DB?
Fri, 27 Mar 2009 09:45:41 -0600
Using SSMS, in the Object Explorer, when I drill down to database D1 and right click on table T1 and choose "Select Top x Rows", the query window that opens is connected to the "master" database, not database D1.
Is there any way to configure SSMS to connect new query windows to the database they are doing the query ...
|
Can't use SSBIDS after installing trial VB.Net?
Fri, 27 Mar 2009 10:49:40 -0400
I have SQL Server 2008 Standard installed on my laptop. I also installed
the 60-Day eval of VB.Net. The expiration of VB.Net has passed but now I
can't even use Visual Studio for SSIS or SSRS. Do I have to re-install SQL
Server?
...
|
|
|
ANN: DbOctopus 1.0 released
Mon, 23 Mar 2009 18:18:51 +0100
We are happy to announce that DbOctopus 1.0 is finally released!
DbOctopus is a tool specialized for finding and editing data in Sql
Server databases. Why should you use it instead of Management Studio?
It fully uses data about relations between tables. If you're inspecting
some row, you can easily jump to r ...
|
linked server using dot net provider for mysql 5.1.3
Fri, 20 Mar 2009 06:33:01 -0700
Good Afternoon
Is it possible to set up a linked server in sqlsever2005 using a dot net
provider driver?
In particular can I link (linked server)to mysql using the .net provider for
mysql version 5.1.3?
If this is not possible, is there another way of using the .net provider to
expose
date(read o ...
|
using table valued function in a update query
Thu, 19 Mar 2009 09:48:25 -0700
Good after noon
I've succesfully used a scaler valued function in a update query
ie
UPDATE ProductItemDH
SET "ItemId"=get_itemid(ProductItemDH.field1)
But now I need to set serveral fields ie
UPDATE ProductItemDH
SET "ItemId"=get_itemid(ProductItemDH.field1)
SET "desciption"=get_description(Product ...
|
