you could determine the max number of parts (e.g. 3) and write a left join statement to concatenate the 3 columns.

SELECT T1.FileData + coalesce(T2.FileData, '') + coalesce(T3.FileData, '')

from...

also check SSC (this site) for scripts "split function".

from BOL:

CHECK OPTION

Forces all data modification statements executed against the view...

Krishna Potlakayala (4/6/2009)

---

ALZDBA (4/6/2009)

---

San (4/6/2009)

---

Dear All,

Somehow I managed to install SQL2k5 with different instance name and logged using "machineName\instanceName". Now another problem is that, when I select " " option...

San (4/6/2009)

---

Dear All,

Somehow I managed to install SQL2k5 with different instance name and logged using "machineName\instanceName". Now another problem is that, when I select " " option in SERVER NAME...

For SQL2008 also have a look at Brians overview at http://www.mssqltips.com/tip.asp?tip=1714

Maybe Lynn Pettis can give you some nice advice regarding usage for schools.

https://www.sqlservercentral.com/blogs/user/Profile.aspx?UserID=13138

Thank you for the feedback.

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