Hi!

I'm sorry to haven't answer, neither updated the script for so long. My appologises.

First of all, I've made a new version of the script, creating a stored procedure and adding...

I found that this script doesn't write down schema permissions.

You might check the following: http://www.sqlservercentral.com/scripts/Security/71562/

I'm also looking for a comparative between theses products

Thank you for this post! I like the way you give the multiple alternatives, pros and cons 🙂

Hello!

I don't like prefix on tables. But now I'm creating a new database and I'm defining the "naming convention". Developers have asked me that they would like to know which...

As you said in the article, enable xp_cmdshell is not the best option and a solution would be to create a CLR function to get the uptime.

But, as the uptime...

Thank you Paul!

You post it just when I needed to use the CROSS APPLY to process a XML file 🙂

Kevin and Andy,

I wouldn't like to be missunderstood: I absolutely agree with you. I only use dynamic sql when I cannot avoid it, as a last option. It has so...

I've written a way without using cursors, neither temporary tables.

I'm using dynamic sql.

But in this case I would use a variable table (similar as the link you posted) because the...

That editorial fits perfectly in a question I wanted to post in the forums: what books do you recommend to learn all the BI environtment (SSAS, SSRS, SSIS, DataWarehouse, etc...)...

How many times do you have to debug using these indexes?

An easy (but ugly) solution if it happends very few times you could create the index on the database when...

Anders Pedersen (12/4/2009)

---

Josep,

I don't have that situation here, I would just transfer the data directly from SQL to SQL. The solution should be obvious! ImportFromExcel.DLL !!! Get...

I like this way to export to Excel (in SpreadsheetML format). It's very fast. But then I need to import back the Excel file to SQL Server and here is...

Rob Fisk (12/2/2009)

---

evgeny-745697 (12/2/2009)

---

2: I am assuming that it does not need excel. It would make it far less than ideal if it did and I am sure that it...

It has happened again and this time I could start checking what was going on 🙂

The first problem was connecting to database: I couldn't log into because I got error...