I found a way to copy a spreadsheet into 2005 Express by using the DTS Wizard. It's located in:

Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard

It's pretty straight-forward. I need to figure...

I found a way to copy a spreadsheet into 2005 Express by using the DTS Wizard. It's located in:

Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard

It's pretty straight-forward. I need to figure...

Please see my response here:

http://www.sqlservercentral.com/Forums/Topic376763-323-1.aspx

This is a very popular problem for Express and Developers versions.

See my reply here:

http://www.sqlservercentral.com/Forums/Topic376763-323-1.aspx

It helps to be a programmer.

I have the same problem. The tutorials said to open the SQL Server Business Intelligence Development Studio, which to me looks like Visual 2005. There, you need to...

Hello, again. I figured out the problem and feel like a rookie! When I put in the server name, it needs the fully qualified name. Once I...

mforbes - The restores were done by the other department.  Again, I have no control over the backups and restores.

I believe that what you are saying is that for a...

Bob - We're using Veritas Backup Exec.  We have restored two databases, though very small, sucessfully.  I believe that we must have the SQL programs since they have performed the...

Thanks Dave.  We already have the .BCH files configured.  I was just wondering about SQL being aware that a backup was taked since it did not perform it.

It is not...

Richard -

Log in to your AD server as a Domain Administrator and go to

Start\Administrative Tools\Active Directory Users And Computers.

When open, go to View and select Add\Remove Columns.  Select...

Another senior moment.  The Deny works fine.  Just one of those days.

Thanks for pointing me in the right direction.

Try this script.  I believe I found it on this site a while ago and works great.

BTW this is a GREAT site!

SET NOCOUNT ON

CREATE TABLE #TBLSize

 (Tblname varchar(80),

 TblRows int,

 TblReserved varchar(80),

 TblData...

I think I got this from this site a few years

ago, but can't remember.  But this works really well

(even though it's a cursor)

SET NOCOUNT ON

CREATE TABLE #TBLSize

 (Tblname varchar(80),

 TblRows int,

 TblReserved...

I had the same thing happen yesterday.  We came in early Sunday morning to apply patches to the servers.  Our system mandates we shut the servers down and bring them...

Brian - Thanks, that works beautifully!!  Thank you for the help.

Jeff - Yes, I know about the "Death by SQL"  This table is collected on the network every time someone...