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 / DB Engine / SQL Server

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Taking database offline taking long time01 Dec 2008 22:40 GMT-
I have a database with a very large transaction log (20 GB).  My plan is to
move the log to a different drive with more space.  I issued Alter Database
<dbname> SET OFFLINE and it has taken 7 hours so far and is still executing.  
Questions:
SQL 2k5-32bit >SQL 2k5-64bit01 Dec 2008 21:49 GMT-
Many times I have installed SQL to a new server, shutdown the service and
copied over the entire MSSQL\Data folder, master,msdb and all, start the
server and bam!, just sp_dropserver and sp_addserver and change the
servername in the jobs table and everything is on the new server ...
SQL Server 2005, SSIS and Data Flow01 Dec 2008 16:51 GMT-
I have a relatively simple SSIS package which uses a CSV file as input and
puts it into a table.
I want to import the data. Unfortunately the data is not clean, but I just
want to ignore the errors.
Bug or Bad Practice on my part?01 Dec 2008 16:20 GMT-
I have created a Database Role for database developers in order to not
give DBO permissions per requirements for the project.
I then added the developers to said role and granted the role database
level permissions such as "EXECUTE WITH GRANT OPTION" (granted more
Microsoft MVP Donald Belcham to Speak on Visual Studio, C# vNext,     Aspect Oriented Programming, Live Mesh01 Dec 2008 12:12 GMT-
Microsoft MVP Donald Belcham to Speak on Visual Studio, C# vNext,
Aspect Oriented Programming, Live Mesh
Bangalore, December 1, 2008: When writing Microsoft technology-related
applications to have strong separations of concerns you inevitably run
SDU 41: Buck Woody - SQL Powershell01 Dec 2008 03:21 GMT-
I've just posted the interview I did with Buck Woody live at the SQL PASS
Summit in Seattle recently. In it, Buck talks about roles within the SQL
Server product group and then discusses Powershell in relation to SQL
Server. It's available for download from www.sqldownunder.com.
Update Statistics meldet 0% und The step succeeded ??25 Nov 2008 13:30 GMT-
ich habe einen UpdateStatistics Maintenance Plan auf eine DB
abgesetzt.
Wie kommt es, dass er 0% complete und dann The step succeeded meldet?
0% complete heisst für mich: es ist nichts gelaufen. Wieso sagt er
100% Pass Without Exams Microsoft,Cisco,Comptia,Oracle,Sun,Java,Cwnp     And Many More( Pay After Check Results)23 Nov 2008 18:04 GMT-
Obtain
Microsoft,Cisco,Comptia,Oracle,Citrix,CWNP,Ciw,Solaris,Jawa,ITIL,Vmware,Ec-
council,Juniper,Norten and Many more Certificaitons Without
Tests...Pay after check results…
Cannot connect to SQL Server DB23 Nov 2008 02:58 GMT-
I am using Visual Studio 2005 and SQL 2000. In VS2005 I created a DataSet to
my eRecon database that is on my REDMACHINE box. (Everything on the same box
RedMachine)
When I go through the dataset wizard I have no problem connecting to the
Feedback regarding my website21 Nov 2008 09:20 GMT-
I am new family member of this family and interested in some feedback
regarding my website.
Recently we built a new company website and we need some valuable
feedback on our site, any suggestions and feedback will be
Create Maintenance Plan failed21 Nov 2008 02:09 GMT-
I couldnot create Maintenance Plan, the error messasge shows: Create
maintenance Plan failed.
Additional Information:
Could not load type"Microsoft
Installng Windows SNMP stops SQL 2005 Service21 Nov 2008 01:37 GMT-
I have run into this several times, when I go and install the Windows SNMP
service on a Windows 2003 server with SQL already installed it stops the SQL
services.
What's up with that?
Transaction (Process ID 411) was deadlocked on thread | communication     buffer resources with another process and has been chosen as the deadlock     victim. Rerun the transaction.20 Nov 2008 14:48 GMT-
I have a simple query thats executed:
SELECT r.filetype, u.scr_rpt_type_id, d.scr_upload_id,
d.salesperson_id, d.commission_amt, d.merchno,
d.dbaname, d.open_date, s.first_name, s.last_name, d.net_rev, d.id,
backing up a website remotely20 Nov 2008 05:01 GMT-
I'm looking for an "affordable" method to backup a web server,
including full system and incremental backups and also file backups.
I have found several sites that provide this service, but none within
my budget. I'd love to be able to just run Symantec BackupExec or
MSIDXS -  Row handle is invalid19 Nov 2008 19:14 GMT-
I've migrated a legacy application from SQL 2000 to SQL 2008 and Im getting
the following error when running an OPENQUERY against the MS indexing
Service.
select *  
Pages: 1 2 3 4 5
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 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.