shew (5/18/2011)

That link does not work for me.

By the...

Take a look at the scripts section of this site. There are tonnes of different monitoring scripts there which you can pick and choose from to build up an alert...

Give this a try...

WITH perms_cte as

( select USER_NAME(p.grantee_principal_id) AS principal_name,

dp.principal_id,

...

You don't NEED to back the transaction log. Its an option thats available should you need high recoverability. Basically, if you have a failure, whats the earliest time that your...

1) It depends on the point in time you want to restore to. You can restore to the last full/diff backup, or to a later point in time depending how...

Very useful, thanks.

Good thinking Bob, thanks!

What an annoying problem! The job is working again for me now, the issue is a bug...

Read this:

http://www.sqlservercentral.com/blogs/james_howards_sql_blog/archive/2009/12/04/data-collection-set-3-upload-failing-its-a-bug.aspx

Hi,

you can use OPENROWSET to import from excel eg:

SELECT *

INTO tblMyTable

FROM

OPENROWSET('Microsoft.Jet.OLEDB.4.0'

,'Excel 8.0;Database=C:\myspreadsheet.xls'

,'SELECT * FROM [Sheet1$]'

)

Hi,

Yes I have just seen similar messages now.... hmm...

take a look at this link

http://www.microsoft.com/downloads/details.aspx?FamilyID=000364db-5e8b-44a8-b9be-ca44d18b059b&DisplayLang=en

Specifically the overview part that states "The Microsoft OLE DB Provider for ODBC (MSDASQL) is a technology...

Hi,

you can use OPENROWSET to import from excel eg:

SELECT *

INTO tblMyTable

FROM

OPENROWSET('Microsoft.Jet.OLEDB.4.0'

,'Excel 8.0;Database=C:\myspreadsheet.xls'

,'SELECT * FROM [Sheet1$]'

)

have a read here:

http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/d659a1e3-a493-4d20-a8dd-226720e78503/

--Create the linked server

EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5',

'ADSDSOObject', 'adsdatasource'

--Create the login account

--(change SQL_ACCOUNT_NAME, --NT_ACCOUNT_NAME, PASSSWORD)

EXEC sp_addlinkedsrvlogin 'ADSI', False, 'SQL_ACCOUNT_NAME',

'NT_ACCOUNT_NAME', 'PASSWORD'

--Execute your query

SELECT samAccountName, givenName [First Name],...

as Grant said, it depends what they will be doing so real life case studies are usually a good bet...

Did you try sp_attach_single_file_db ? fingers crossed that it works...

Have you any backups?