BCP.EXE fails in 90 where it succeeded in 80
Thu, 12 Jun 2008 10:19:01 -0700
I'm trying to BCP out a temporary table (this is actually occuring in an
application and with the connection still open that "owns" the temporary
table, the application launches BCP.EXE to move the data to the file system).
The command line is of the form:
bcp "##temptablename...." out "c:\path\tempfilena ...
|
how can export activity monitor process info data to txt or csv ?
Wed, 11 Jun 2008 15:12:54 +0800
as title , anyone know , thank a lot
...
|
SQL Server Indexes
Tue, 10 Jun 2008 13:25:01 -0700
We have a User table with 2million records in them, that has 4 indexes set
for faster Search. At an average we have 187k new records coming into the
table per day. We see every 4 or 5 days the queries we run on the table get
slower. However if we drop and re-create the index the querys are now quick.
How d ...
|
SQL Server Enterprise Manager Error
Tue, 10 Jun 2008 11:00:01 -0700
We have SQL server 2000, SP3. Whenever I go into
Enterprise Manager(on either the server itself or on my
desktop Enterprise Manager) and click on "Taskpad View", I
get a "Internet Explorer Script Error" box that pops up.
It says
"An error has occured in the script on this page"
Line: 307
Char:2
Error: ...
|
'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.
...
|