Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum

Tip: Looking for answers? Try searching our database.

General

Recently updated threads


Thread preview

Data Warehousing (view all ...)Last Post  Replies
Set a foreach to a file connection12 Mar 2010 16:52 GMT-
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
Fact Tables general questions10 Mar 2010 10:47 GMT1
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
SSIS package - how to determine if a file is in use.05 Mar 2010 15:32 GMT2
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 ...
Pivot Problem26 Jan 2010 01:37 GMT1
I have three tables.
Table 1 - Customers:
 CustomerID
 CustomerName
a brand new query tool is out on beta, we need feedback, so you get a     free copy26 Jan 2010 01:32 GMT1
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

Performance (view all ...)Last Post  Replies
Truncating a lot of data does it cause extreme memory usage.03 Mar 2010 17:07 GMT5
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
marvendas@gmail.com Kit completo de   Solenoides ( solenoid ) + chicote Para Cambio automatico 01M hidramatico Audi A3 Vw Golf gti turbo 8073420 Feb 2010 03:24 GMT-
Contato: marvendas@gmail.com
marvendas @ gmail.com
marvendas no gmail.com
Kit completo de solenoides para Volkswagem e Audi.
Logical Reads11 Feb 2010 22:47 GMT6
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 ...
set nocount on and ad hoc query10 Feb 2010 22:46 GMT1
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.. ...
AVG DISK QUEUE LENGTH is very high when run sys.dm_db_index_physic15 Dec 2009 13:17 GMT4
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 ...

Security (view all ...)Last Post  Replies
Stored Procedure with Encryption is clear text in backup18 Mar 2010 10:19 GMT4
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,
linked server security18 Mar 2010 04:50 GMT-
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
Stored Procedure Security18 Mar 2010 02:37 GMT1
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 ...
Configure SQL 2005 for Kerberos Authentication18 Mar 2010 01:41 GMT2
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
using certificate on tables17 Mar 2010 23:57 GMT1
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

Setup (view all ...)Last Post  Replies
Is it possible to run MS SQL Server 2008 std on Windows Server std 2003r2?17 Mar 2010 22:10 GMT2
Is it possible to run MS SQL Server 2008 std on Windows Server std 2003r2?
Please advise and thanks.
what firewall exceptions do I need17 Mar 2010 14:42 GMT3
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?
Cannot Install SQL Server SP217 Mar 2010 05:55 GMT5
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
Re: error installing KB970895 network resource missing sqlrun_sql.msi17 Mar 2010 00:46 GMT-
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
Install Reporting Services No CDs16 Mar 2010 19:29 GMT-
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 ...

SQL Server Tools (view all ...)Last Post  Replies
SSMS Slow connect to 64 bit16 Mar 2010 22:20 GMT1
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.
receive the following: Warning: File/Process "bcp" is not in path.       10 Mar 2010 22:36 GMT1
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
Monitoring SQL Server10 Mar 2010 20:56 GMT3
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 Released10 Mar 2010 19:18 GMT-
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
ANN: SQL Server Utility, FREE10 Mar 2010 00:03 GMT-
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.

Other SQL Server Topics (view all ...)Last Post  Replies
upsized SQL Server aplication issues18 Mar 2010 10:03 GMT7
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
Date question17 Mar 2010 16:36 GMT6
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
MS Sub form feilds17 Mar 2010 10:22 GMT3
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 ...
SQL 2005 (Express with advance features) reporting services16 Mar 2010 15:26 GMT-
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
Many to many table design question15 Mar 2010 23:03 GMT4
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage




©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.