Charmer (3/27/2012)

---

Hi Friends,

I am having kinda same problem...

I have more than 7 million records in a table.. i was wondering to see how much time to execute and :ermm: it...

And the gentleman from the UK WINS!

GSquared (3/27/2012)

---

Stefan Krzywicki (3/27/2012)

---

It is amazing how, no matter how often I state "I am not interested in travel or relocation", when I mention that on my resume and list...

You will need to post the DDL (CREATE TABLE statements) for the source tables used in your procedure. Also you will need to provice smaple data for those tables...

Most likely you will need to go to Sybase and download the appropriate OLEDB or ODBC drive for the Sybase databae you will be accessing.

Here is the from clause in your stored procedure:

...

FROM employee e

...

What??

Okay, glad to hear it. Now, you on the other hand, should post the code you wrote to solve your problem. It may help someone else who may...

Henrico Bekker (3/26/2012)

---

Hi all, anyone also getting the errors during installation?

It fails specifically for the DB Engine & SSRS.

SSAS, SQL Browser and SSIS install perfect.

Error components:

1. sqlrsshpconfigaction_install_configrc_cpu64

2. sqlengineconfigaction_install_confignonrc_cpu64

"The module...

You can't hijack this thread. Coming to the water cooler and saying that some help would be appreciated...

hendrianhamonangan (3/26/2012)

---

hendrianhamonangan (3/26/2012)

---

Hi Lynn,

The screen shoot I gave the operation failed with the message error : access is denied. Even the current folder already get the permissions as everyone and...

Looks to me like you did not install the client tools. You should be able to rerun setup and install the client tools.

Did you get any errors while actually moving the files between directories? I think this is the third time I have asked this question.

If you force a failover, you will most likely lose transactions that had not made it over to the mirror database. Can't really tell you more than that.

mrwillcostello (3/26/2012)

---

--Return database-level permissions for user.

SELECT su.name, dp.class_desc,dp.permission_name, dp.state_desc

FROM sys.database_permissions dp

JOIN sys.sysusers su

ON su.uid = dp.grantee_principal_id

WHERE dp.grantee_principal_id = DATABASE_PRINCIPAL_ID(shantecostello);

--Return rolememberships for the user

SELECT su1.name as[User], su2.name as [Role]

FROM sys.database_role_members drm

JOIN...