Breakwaterpc (11/8/2011)

---

how would i script a join (or anything else for that matter) between two tables/databases on different servers on the same domain?

For instance, i want to compare...

Ninja's_RGR'us (11/8/2011)

---

sjimmo (11/8/2011)

---

Using openrowset will allow you to perform selects between servers that are not using linked servers. We do this amongst many servers on our network. We do this...

christina-518819 (11/8/2011)

---

Thanks for your reply. I wanted to use a mapped drive but I've been given orders from on high that I'm not allowed to map any drives to the...

Dan Williams-449672 (11/8/2011)

---

Can anyone help with the following?

I have a table that stores appointments and another that stores

peoples availability.

People can specify dates and times they are available...

I'm not an SSIS guy, but i do know that the you can map a network drive with the NET USE command allows you to specidy a domain users...

another way is the SSMS addin from http://www.ssmstoolspack.com/ also has the ability to generate insert statements from The SSMS GUI;

Sagar Sawant (11/7/2011)

---

Hi guys,

I am getting error when trying to execute database profile and database account through stored procedure.

I already executed,

sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

sp_configure 'Database...

Steve Malley (11/7/2011)

---

If I create a stored procedure with 'dbcc freeproccache' in it, and then grant execute on that stored procedure to a specific user account, the grantee should be...

this will show you everything, which includes all the objects in the default partition, and the commented out WHERE statement will show you the objects that exist in other partitions,...

SVR (11/7/2011)

---

thanks for your response.

The problem was , got a request for data refresh from prod to test, some of them were views. did not know how to refresh view...

It's all permissions, of course, so i believe you need one of two things: either add every login as a user to the msdb database(or at least the ones that...

I have one client that put their database in case sensitive collation prior to running the installation scripts;

our app has a typical search screen kind of thing, so the search...

what is the real name of the database trigger?

it looks to me like you keep running the script on the placeholder name [database_trigger] instead of the real trigger name...TR_Whatever_Insert or...

anthony this is just a guess, but it might work:

it's possible to map a network drive, and include the username/password to use[impersonate] the permissions for it;

i've done it with xp_cmdshell...

Glad i got you pointed in the right direction;

If you can use CLR, i think there's a couple of ways you could do it that way; I had a Web...