Hiya,
So I am in SQL Server Business Intelligence Development Studio 2008. I
have a Foreach file enumerator and a file connection that points to a
folder. I only see browse and can only enter a folder path text under

Giving the following senerio.
A wireless phone company Sprints has an application that tracks the
transactions.
A transaction can consist 1 phone sold or a family package (multiple

I have several SSIS packages that import data from files.  I am having
trouble  reliably determining whether a file is in use.  I am working in
Visual Studio 2005.  I am creating SSIS packages for SQL2005.  I am importing
data from text files.  These text files are written to ...

I have three tables.
Table 1 - Customers:
 CustomerID
 CustomerName

We at  Nob Hill Software  are working on a new query tool:
http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut
You can read all about it on the above web page, but basically, its a
very ambitious project to create what we call 'the query tool to end

SQL Server 2008
I have a SSIS job that copies data and transfers it to another database.  The
job is truncating the data.  Now, the source database column sizes are large
and the destination size is smaller, but the data is small in size so most if

Contato: marvendas@gmail.com
marvendas @ gmail.com
marvendas no gmail.com
Kit completo de solenoides para Volkswagem e Audi.

Hello, I have a bottleneck in a stored procedure.  In the QA environment, I
ran profiler and the stored procedure took over an hour and came back with
1.6 billion reads and row count 39.  I copied the same databases to a
different server and ran the same sproc, this time it ran ...

We are running an application with a lot of ad hoc queries in terms of
thousands per second (they are prepared). My question is that, if we append
SET NOCOUNT ON to each and every ad hoc query, will there be any benefit of
doing that? I understand it will help stored procedures.. ...

I have question regarding AVG DISK QUEUE LENGTH that is very high and was
almost 400-600 when run select from sys.dm_db_index_physical_stats view to
get fragmentation info my DBs. I have known that AVG DISK QUEUE LENGTH should
be below 2. But why it was hundreds? Can someone let ...

All my stored procedures have With Encryption in place but I realise that if
I open the database backup in any text editor, these encrypted stored
procedures are in clear text!
I am using SQL Server 2008 Express. Any advice to overcome this problem,

SQL 2005 STD edition sp3 both servers
Non domain server = Server #1 = home of linked server
Server in domain using Mixed Auth. = Server #2 = linked server defined on 1.
Want to use NT auth to logon to server #2 via linked server with logon from

I was under the impression that granting execute security on a stored
procedure would allow a user to run the procedure.  My experience, however,
is that security must also be granted to all the tables, functions, etc...
that are used by the stored procedure.  Why isn't granting ...

I'm currently trying to setup SCCM 2007 with the SCCM database on a remote
SQL 2005 SP3 server (not in the default instance)
I've configured the SPN as per this guide:
http://support.microsoft.com/kb/909801

I have database which i had to grant select on some tables for specific
users. In order to use these tables on dinamic sql.
I just found out that i can use certificate on sql 2005-2008 to allow select
on these tables from specific procedures without grant the select on that

Is it possible to run MS SQL Server 2008 std on Windows Server std 2003r2?
Please advise and thanks.

What exceptions do I need to make in the windows firewall in order for people
to connect to and use my SQL 2008 server and databases?

I'm trying to install SQL Server SP2 on a SQL Server 2005 Developer Edition.
I'm running SQL Server 2005, SSAS 2005, SSIS 2005, & SSRS 2005 with SP1. (I
have also install VS 2005 Professional on this server.)
I've copied the SP2 exe file on the local C: drive of the SQL 2005 Server

I tried this earlier, but apparently it did not like the attached files, so
I am putting them on a web server.
http://www.catslair.com/sqlerr/SqlSetup0008.cab
http://www.catslair.com/sqlerr/KB970895-fail.zip

Hi, Need to install Reporting Services on customer's system (2005
Enterprise), but they can't find their cds.  I am remote and only have
developer version available.  Is there any download that is safe to use?  Can
I use my developer version?  Don't want to mess up their ...

I have a bunch of servers on a different subnet.
All of them connect within a second or so except one.
A 64 bit 2008 enterprise version.
Takes about 20 seconds to connect to it through SSMS from my desktop.

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

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

DBTYP.NET Studio 2010 - Database Comparison Suite Released
Vienna, Austria - March 8, 2010
Today, BYPsoft announced the availability of DBTYP.NET Studio 2010, the
newest version of the cross-database comparison tool that compares SQL

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.

I am in the process of upsizing a MS Access application to a Access FE and
SQL BE. (MS Access 2007 SQL2005)
I used the MS upsize wizard to convert all the tables to SQL format.
I have been going through the application and updating the linked tables to

In VBA the following will yeild the last day of the current month:
dtmLDM = DateSerial(Year(Date), Month(Date) + 1, 0)
How can you accomplish the same thing in T-SQL?
Patrick

I am upgrading a MS Access application the previous version was split to MS
BE and MS FE, I am upgrading convert the BE to a SQL BE The problem I am
having currently is that two of my forms that have a subform for line items.
I have converted the record source to use the converted ...

I am have trouble getting the above to work.  MS IE (Ver 6 SP2) does
not access;
http://localhost/reports/
correctly.  I expect to get the Report Manager but instead I get (in

Originally I had 2 tables in my DB, [Property] and [Employee].
Each employee can have 1 "Home Property" so the employee table has a
HomePropertyID FK field to Property.
Later I needed to model the situation where despite having only 1