Igor Makedon (4/3/2009)

---

Excellent code, ALZDBA, thanks.

Could you please help me with my problem:

Given:

Login: pacrat

User: pacrat with default schema: [pacrat]

view pacrat.tv (as select getDate())

BOL states that under these circumstances query...

If you have (recent) backups (or the old files) of msdb, you should be able to restore it and your jobs will be back.

Boolean_z (4/4/2009)

---

Yes. I agree. I think this is one of the most commonly used practice in every environment (dev / qa/ prod)

And this should be done just after installation...

wow ... msaccess with 20Gb data ??

also check "microsoft migration assistant for sqlserver" which if free at http://www.microsoft.com/Sqlserver/2005/en/us/migration.aspx

Your query returns duplicates !

SELECT adv.A_AdvertiserID

,'Mobile'

,ab.[Telephone2]

FROM [MSCRM].[dbo].[AccountBase] ab

JOIN [DIGADV].[dbo].[Advertiser] adv

ON ab.[Name] COLLATE DATABASE_DEFAULT = adv.A_AdvertiserName COLLATE DATABASE_DEFAULT

Solution ?

- Check PK on names ?? (In my home town we had 3...

We use this one at sql2000.

Select @@servername as Servername, getdate() as RunDate

/*

* Show members of serverrole sysadmind

*/

exec sp_helpsrvrolemember @srvrolename = 'sysadmin' -- =SA

go

/*

* show members of the...

indeed ... an authorzation issue to the linked server BRENTREPODB02.

How did you set up the linked server usage security ?

BTW: nice view ... using the mixture of right and...

maybe stupid, but did someone use any form of compression ? (drive/LUN level)

of course that also depends on what your udf is doing !

is it just a split/string function or does it perform access to other objects ?

if you post it we...

Actually the install of sql2000 shouldn't cause a technical problem.

Who detached your database ?

Where has it gone to ?

Did someone just uninstall the sql2005 engine ?

and off course there is a difference in Red Cross junior camp first aid, Paramedic first aid and combat first aid 😀

According to their trained skills, you may have a...

Well ... your indexes also need space !

So depending on the size of the columns you used in the index ddl, they will be smaller or larger combined with the...

Outrageous for any software to be implemented in that way !

Complain to your manager that this simply is not acceptable !

Have him complain with the software vendor and make it...

ldave (4/2/2009)

---

Hi,

I have created a view with code that looks like below.

use testprd;

SET NUMERIC_ROUNDABORT OFF;

SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT,

QUOTED_IDENTIFIER, ANSI_NULLS ON;

create view test wtih schemabinding as...

I think "discovery"' doesn't function on 64-bit environments.

You should be able to just enter the sqlserver name (server\instance) and connect with ssms !

If that doesn't work...

Did you enable the SQL...