Visual Studio Debugger - Nothing Happens
Tue, 15 Apr 2008 10:20:03 -0700
I open Visual Studio Business Intelligence studio or Visual Studio 2008,
connect to SQL Server 2000 database. Select stored procedure to debug. Right
click and use menu item "Step Into Stored Procedure". Fill dialog box with
arguments.
It appers to work, but I never get a debugger on the first line of the
...
|
SQLCMD issues
Tue, 15 Apr 2008 12:01:58 +0300
Hi folks
I am having the following issue with SQLCMD script.
Here's the script:
:setvar x 0
print $(x)
if $(x) = 1
begin
print 'x=1'
:exit(select $(x))
end
else
print 'x <> 1'
My problem is that when SQLCMD encounters (or detects) the :exit statement,
it doesn't executes the PRINT statemen ...
|
Dear Friends,
Mon, 14 Apr 2008 22:35:26 -0700 (PDT)
We are coming on the heels of a very successful beta program with
passionate feedback. We are launching a superior cost effective
product Secure Auditor aimed at a providing unified digital security
solutions from single console. It is a single tool for compliance,
forensics, and penetration testing and asset id ...
|
Using MS SQL Server Mangement Studio to Copy Table
Mon, 14 Apr 2008 16:03:28 -0500
Is there a way within the Manager to copy TableA in to a new TableB within
the same database?
I have a table that is very similar to a new one I need to create. It would
be nice if there was a copy/paste/rename feature with in the manager.
Can this be done?
Thanks,
Tom Woods
...
|
Troubleshooting with Dashboard Reports and DTA
Fri, 11 Apr 2008 06:00:01 -0700
Hi,
My organization has implemented a project for a customer based con MS
Dynamics AX and a SQL 2005 DB. Now the project is already in production and
we have a 12 Gb Database...
The performance was very slow in some operations, so I used the Dashboard
reports for troubleshooting. When this operations wer ...
|
SQL Express 2005 fails to attach database on Vista
Wed, 09 Apr 2008 03:21:19 -0700
Hi guys I felt I should drop a line on this issue since I just finished fighting it with some seed from the replies Erland and Charles gave.
I had created an SMO app for attaching my database. That failed on running it on Vista Home Premium Edition, but works fine on XP.
Then I peeped into the Event viewer o ...
|
Re: SQL Server 2005 can't attach database on Windows Vista
Tue, 08 Apr 2008 17:13:45 -0700
With Microsoft SQL Server Management Studio
You must use "Right Click" on the menu and use "Run as Administrator" to
open the program
I use this to open and then I can attached my old DB from SQL2005
Express Edition
Now I'm using SQL2005 Dev. Edition on new computer
*** Sent via Developersdex http:// ...
|
|
|
Legacy migration failure?
Tue, 8 Apr 2008 19:39:53 +0200
I have now SBS 2003 with SQL. I had a SBS2000 with SQL.
I want to do some migrations and tried to migrate Data Transformations.
In Legacy I choose " Data Transformation Services" and rightclick on
"migration wizard"
Everything looks fine and the wizard is telling me verything was ok.
But now I cannot find ...
|
Adding a server instance to SQL 2005
Tue, 8 Apr 2008 07:58:00 -0700
I appologize for this simple question. However, i have a software that
installs a full version of SQL 2005 and its own named server instance. Now i
want to add another server instance (for use by another program). However, I
can't figure out or find documentation how to add onther server using the SQL
Server ...
|
SSIS datatype error
Fri, 04 Apr 2008 15:42:59 -0400
I get the following error when putting a column into a variable. I have
the variable deviced as an int32. The column is Numeric(28,0). I tried
double, UInt64 and object and string. I get this same error everytime.
Error: 0xC001F009 at Package: The type of the value being assigned to
variable "User::Tran ...
|
