|
|
|
receive the following: Warning: File/Process "bcp" is not in path.
Wed, 10 Mar 2010 17:02:09 GMT
I am running the bcp utility under Microsoft Visual studio 2005 and receive
the following in the progress log:
[Execute Process Task] Warning: File/Process "bcp" is not in path.
a few lines later the process fails
:[Execute Process Task] Error: In Executing "bcp" " "FDMS.[DBO].[EXPORT_TUFTS]
" out "E:\D ...
|
ANN: SQL Server Utility, FREE
Tue, 9 Mar 2010 16:03:02 -0800
Wingenious has released a free utility for SQL Server developers,
administrators, and contractors. The tool, DBGizmo, provides some of the
features most commonly requested in SQL Server forums, along with other very
interesting functionality.
There's a search feature for names of database objects. You can q ...
|
Tools that support Importing directly from Reports
Sun, 7 Mar 2010 04:32:42 -0800 (PST)
My office often gets accounting data from clients in the form of
reports. These reports can be output into text files but we then need
to parse the report output (not CSV or any other useful import format)
to import it into SQLServer. I have identified a class of tools that
enables a user to open a text file r ...
|
BCP issue
Sat, 6 Mar 2010 17:23:36 -0800
Hi there,
I'm using SQL Server 2008 and I wrote
Exec Master..xp_cmdshell 'bcp "Select * from Coronado.dbo.immunization"
queryout "C:\mobiledoc\immunization.txt" -c -b1000 -T -Slocalhost'
and I run it everything was fine
Now when I'm run it without the -b option it still run at the 1000 rows
Exec Maste ...
|
SQL server side tracing
Fri, 5 Mar 2010 00:20:01 -0800
Hello all,
This is for SQL 2000.
A trace is being configured (through a service) with filters to monitor
UPDATE, DELETE or INSERT commands in a particular database. What is weird is
that the system seems to be buffering entries, rather than immediately commit
them to the trace. Only when SQL service is sto ...
|
sql server report 2008 work with office 2007
Thu, 4 Mar 2010 16:04:01 -0800
Since I am new to sql server report service 2008, I have the following
questions to ask:
1. I have alot of reports that need to have one to 10 paragraphs written
prior to when the table is displayed. Thus, I was thinking there would be
toolbox items like a 'word' document that you can drop onto a sql serve ...
|
Monitoring SQL Server
Wed, 03 Mar 2010 14:21:56 -0500
I'm a newbie to SQL Server and have asked to investigate monitoring
tools. We're mostly interested in the basics...
- is it up
- has it been recently backed up
- are there any really glaring problems (locks held for a long time,
excessive CPU or DISK activity, etc.)
What tools do most folks use for monitor ...
|
|
|
SSMS license agreement does it work with Express on local system.
Wed, 03 Mar 2010 16:18:11 GMT
Ok, I have SQL Server 2008 with a license by processor license agreement. I
have SSMS installed on my local machine and am using it to access the server
with SQL Server 2008. Can I legally use SSMS to access my local SQL Server
Express edition and/or access SQL Server Express on other machines remotely?
I am ...
|
Column Type in 2005
Sat, 27 Feb 2010 08:59:27 -0600
Hi,
I have a SQL 2008 DB I'm try to Publish as a SQL 2005 DB with the Database
Publishing Wizard Tool.
It gets all the objects OK... but scripting Objects step fails.
Error: [dbo].[Classify], column "DatePosted" is of type [None]. This type is
not supported.
I examine the table Classify and column "D ...
|
BUY FAKE PASSPORTS OF CANADA,FAKE CANADIAN PASSPORTS FOR SALE! FAKE UNITED STATES(USA) PASSPORT
Fri, 26 Feb 2010 11:09:31 -0800
Our team is a unique producer of quality fake documents.
We offer only original high-quality fake passports, driver's licenses,
ID cards, stamps and other products for a number of countries like:
USA, Australia, Belgium, Brazil, Canada, Italia, Finland, France,
Germany, Israel, Mexico, Netherlands, South Africa, ...
|
|
|