'Comment out' icon for SQL scripts in SMSS vs VS
Mon, 9 Jun 2008 15:39:00 -0700
In both SMSS and Visual Studio, there are icons to comment out lines (looks
like a stack of parallel lines, with the top and bottom lines longer on the
left), and to uncomment lines. When I use these icons in SMSS while writing
SQL scripts, they work as expected (i.e. they add two hyphens in front of the
hi ...
|
Intellisense for SQL Server Management Studio
Fri, 6 Jun 2008 00:29:38 +0530
Do we have any free Intellisense for SSMS? I know of red gate's SQL Prompt,
for which we have to pay
...
|
Duration incorrect on Profiler trace for SQL Server 2005
Thu, 5 Jun 2008 08:57:01 -0700
I'm aware that profiler can show duration in microseconds. I'm running a
trace for a specific DB where the duration is incorrect. If I manually
subtract starttime from endtime, I'm seeing what I'm sure are accurate times
(generally about 1/2 second). For these statements that take 1/2 second
realtime, dur ...
|
Generate Script Wizard Issue
Thu, 5 Jun 2008 00:20:01 -0700 (PDT)
hi!
I use ms sql 2005 "Generate Script Wizard" to generate table schema
Most tables' script are normal,except one.
the script snippet is as following
----------------------------------------------------
IF EXISTS (SELECT * FROM sys.objects WHERE object_id =
OBJECT_ID(N'[dbo].[TABLE_ABC]') AND type in (N'U'))
...
|
Error create a Job in SQL Server 2005 SP2
Fri, 30 May 2008 08:55:03 -0700
I have the follwing error message when I try to create a Job in SQL Server 2005
"Unable to cast object of type
'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type
'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'.
(Microsoft.SqlServer.Smo)"
Someone have a solution for this error?
Thanks ...
|
About PRINT and other SQLCMD questions
Fri, 30 May 2008 09:07:11 +0200
I am using SQLCMD.EXE of SQL Server 2005 for the automation of my
installation scripts. I wanted to make use of transactions when inserting
data into the database during the installation but since there are several
GO in between it was not possible without having to multiplicate the
BEGIN/END TRANSACTION.
...
|
job schedule w/studio express
Thu, 29 May 2008 16:07:30 -0400
Hello,
Does anyone know if it is possible to schedule an automatic backup of sql
database through SQL Server Management Studio Express? I have heard there is
no job scheduler included with this management tool however i'm not sure if
it's possible. If it's not possible could you make a suggestion of an
altern ...
|
|
|
How to import xsl sheet into SQL Server Express
Thu, 29 May 2008 12:22:00 -0700
Hi all,
Is it possible to import data from xsl SQL Server Express?
Clara
thank you so much for your help ...
|
SSMS to Administer Express - Licence Question
Wed, 28 May 2008 22:22:31 +0100
Assuming I have 5 per server licences for SQL 2005 Standard Edition servers
and I had and 50 clients with SQL CALs I believe I can install SQL Server
Management Studio on any of these 50 client PCs to administer any of the 5
SQL 2005 Standard Edition servers.
If I then install SQL Server 2005 Express on a n ...
|
Updating an Instance from the production database
Wed, 28 May 2008 17:15:16 GMT
I am currently using SQL Server 2000. I have a production database and an
instance. The instance is mainly for web display. What I would like to do
is when the production database has an insert or update a trigger, or any
other option, activates and inserts or updates the instance database
immediately. I am ...
|
