I looked up the reviews on Amazon and the solutions that the author provided did not work.

It is a hassle.

This is the exact error:

Msg 5173, Level 16, State 1, Line...

This is one of the scripts.

CREATE...

GilaMonster (6/17/2012)

---

What, in explorer when you rename the file you get an error?

What happens...

I renamed the file and I get an error that the file does not exist.

I have never had so much trouble attaching a Database even when missing the log file.

What...

I missed the:

FOR ATTACH_REBUILD_LOG;

I tried it and still got the same error.

I not sure how I should go about renaming the log in T-SQL Syntax.

Thanks.

Here is the link to the download.

I used the CD that came with the book.

http://examples.oreilly.com/9780735626188/

Thanks.

I executed the following

but it is trying to attach the log file.

How do I force it to ignore the log file?

CREATE DATABASE MdxStepByStep

ON (FILENAME...

I discovered that the Proxy that I created was unassigned.

I did everything in T-SQL Code prior but I assigned the Proxy that I created to the SSIS Package Execution Proxie.

I...

Actually the problem went away for almost a week and started up again.

I determined that we are not being blocked by a firewall.

I was able to obtain a dedicated NAT...

sqlfriends (6/6/2012)

---

I asked and she says the application support for a ArcGIS software told her to schedule restart service daily when it is at verision 9.0, she will check if...

CREATE TABLE encrypt_table

(

table_id INT IDENTITY,

sch_name VARCHAR(50),

table_name VARCHAR(50),

...

The reason for stopping & starting the service is proably classified.:-)

I have used the Start & StopService method of the Win32_Service Class to do this.

I would not use SQL Server.

...

Why don't you use something like VBScript and add it to a...

The following are the steps that you should follow.

You can do this in T-SQL or SSMS.

Add the SSQLServerAgent Account to the SQLAgentUserRole Role

Create a Credential

Create a Proxy

Associate Proxy with Subsystem

Grant...

If you...