saving SQL files in SSMS as ASCII
Wed, 06 May 2009 10:07:07 -0400
Is there a way to make SSMS default to US-ASCII when saving a .sql file? I have searched the options. Is that
connected to the current codepage of Windows?
dan ...
|
Database diagrams in ss2008
Wed, 6 May 2009 10:02:55 -0400
Hi,
I would like to know if it is possible to rename the tables
that result after creating a diagram. I just tried it, and the
diagram did not recognized that the tables just were renamed
so it assumed that they had been dropped..
I would also like to know how can I transport a diagram to another
database ...
|
execute long sql script
Mon, 4 May 2009 13:18:03 -0700
Hi,
I have a very big sql script that I can not opne with Mangement Studio due
to the size.
What other tool can I use to execute this script? All it has are INSERT
statements.
Thanks,
Ping ...
|
Analysis Services Server Type Not Available in 2008 Mgmt Studio
Mon, 4 May 2009 10:59:02 -0700
SQL Server 2008 Management Studio
Server type
When registering a server from Object Explorer, select the type of server to
connect to: Database Engine, Analysis Services, Reporting Services, SQL
Server Compact 3.5, or Integration Services. The rest of the dialog shows
only the options that apply to the sele ...
|
Can not create diagram in ssms 2008
Fri, 1 May 2009 19:27:20 -0400
Hi all,
I just created a database, and immediately wanted to
create a diagram for it. However, when I tried it, I just
got a box titled add a table, but did not let me do anything
i.e. the add button was disabled, and could not type on the box.
Please help. Thanks
...
|
Move SQL2008 Express to another machine
Fri, 1 May 2009 07:38:59 -0400
I need to move SQL 2008 Express from XP to Vista Machine. Currently both
machines are same LAN. My previous attempts at "backup and restore" database
failed... so I am wondering if anyone would be kind enough to help....
I am not that experienced with SQL servers. I figure I have to install SQL
server expre ...
|
sql server balnk date
Thu, 30 Apr 2009 23:01:01 -0700
I want to put a blank value into a datetime field in sql server 2005. However
I am getting the date of '1/2/1900'.
In the following statement, I want to return a blank date in a column in sql
server 2005 stored procedure that is passed to a vb.net 2005 application.
Instead I am getting 1/2/1900 returned in ...
|
|
|
SQL Server Profiler and Prepared Queries
Thu, 30 Apr 2009 09:49:01 -0700
I am trying to figure out how to detect issues with queries via SQL Server
Profiler and trace files. Because of the way we utilize JDBC with our
application, most of our queries appear in the trace files as prepared
statements. My understanding is that when the statement is â??preparedâ? it is
assigned a ...
|
snapshots.performance_counter_values LogicalDisk % Disk Time above
Fri, 24 Apr 2009 07:16:27 -0700
I've started the system data collection sets, and they've been active for a
few weeks now.
But when I look into the table snapshots.performance_counter_values and
select the records which correspond to the instances
object_name='LogicalDisk' and counter_name='% Disk Time' I retrieve some
records which have ...
|
ODBC Drivers 64-Bit
Thu, 23 Apr 2009 13:11:25 -0700
I have 64 bit sqlserver 2008 installed on a 64bit Window Server,
and my problem is "there is no drivers listed in the 'ODBC/create New Data
Source' box other than the sql server",
1. I tried to install "64-Bit OLEDB Provider for ODBC (MSDASQL)" but the
installation give me the error "Not enough storage ...
|
