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:

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

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.

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 Mesh
Bangalore, December 1, 2008: When writing Microsoft technology-related
applications to have strong separations of concerns you inevitably run

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.

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

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…

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

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

I couldnot create Maintenance Plan, the error messasge shows: Create
maintenance Plan failed.
Additional Information:
Could not load type"Microsoft

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?

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,

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

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 *