Neil

Yes, you can add those components. Start by running setup.exe and click on Installation, then New SQL Server stand-alone installation or add features to an existing installation.

John

I think this is because you're putting a space before your "Z". And the outer REPLACE doesn't do anything - it just replaces a space with a space.

John

That'll be because "A" comes after "-" in SQL_Latin1_General_Cp1251_CS_AS and all the other collations you've tried. Here's a few options I can think of:

(1) Find a collation that has...

Yes, it's useful for querying any information stored as a bitmask, such as affinity masks or the freq_interval column in...

Have a look at this. It seems that xp_delete_file goes into the file itself and checks the header. Looks like you may have to roll your own, as...

If you already have an Excel connection manager and a data flow, you don't need to use a stored procedure - not to do the actual importing, anyway. What...

Those links don't work for me. The code you posted will do the job, but it'll rebuild every index in the database regardless of how fragmented it is. ...

http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

John

L' Eomot Inversé (7/22/2013)

---

John Mitchell-245523 (7/22/2013)

---

kapil_kk (7/22/2013)

---

Yes you are right but user PRR asked a scenario only for clustered index and if a clustered index is used then it will...

kapil_kk (7/22/2013)

---

Yes you are right but user PRR asked a scenario only for clustered index and if a clustered index is used then it will reorder of the data in...

You have a date stored as varchar or similar and you want to check it's a valid date?

Two options - the first being vastly more preferable:

(1) Don't store dates as...

ALTER DATABASE MODIFY FILE (....)

If you don't know the syntax, you can search for it. Or you can just use the GUI.

John

Sounds like your stored procedure is making more modifications than there is room for the transaction log to record. If that's the case, rewrite the procedure so that it's...

We're not here to do your work for you, although obviously we're happy to help out if there's anything in particular you don't understand. Therefore please will you show...

Ah yes, hadn't thought of that. I guess that behind the scenes it creates a new column and copies the data across - something to bear in mind if...