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 ...
|
SQL 2005 Studio connect to SQL 2008
Fri, 4 Apr 2008 07:53:00 -0700
How can I make my SQL Server 2005 Management Studio to connect to a remote
SQL Server 2008? ...
|
