No announcements
Found 4096210 threads
-
0 VotesConnect SQL Server Database Project to existing database
Currently, we have a development database that my app runs against and I need to add a new stored procedure.Answered | 5 Replies | 6032 Views | Created by Don--C - Monday, June 3, 2013 3:52 PM | Last reply by Kevin Cunnane [MSFT] - Thursday, June 6, 2013 12:54 AM
-
0 Votes
Connect another server same database
I'm currently studying SQL so my word might not weigh as high as others.Answered | 3 Replies | 938 Views | Created by Nagendrababu61 - Wednesday, January 29, 2014 11:13 AM | Last reply by SQLZealots - Thursday, January 30, 2014 12:24 AM -
0 Votes
connect to another database
Correct. in SP I have to use execute as MultiDB_ConnectUser so that the sp can access the data in another database.Answered | 6 Replies | 579 Views | Created by arkiboys - Monday, September 8, 2014 10:22 AM | Last reply by Erland Sommarskog - Monday, September 8, 2014 10:07 PM -
6 Votes
Connecting to another database at run-time
It is slightly more work to connect to another identical schema if the schema has a different name.Answered | 6 Replies | 4069 Views | Created by Lalbatros - Thursday, June 10, 2010 1:09 PM | Last reply by Lalbatros - Wednesday, June 16, 2010 6:49 PM -
1 Votes
Stored Procedure to drop users from different database
We have a database, I'll call TMR It is synced (using RedGate SQL Compare) from a different server every week to perform testing.Answered | 2 Replies | 554 Views | Created by AlHowarthWF - Monday, March 12, 2018 1:37 PM | Last reply by AlHowarthWF - Monday, March 12, 2018 8:27 PM -
1 Votes
HOw to use different database based on different server
The USE [database] command is NEVER the first line inside a stored procedure.Answered | 6 Replies | 2789 Views | Created by cat_ca - Tuesday, May 1, 2012 12:37 AM | Last reply by cat_ca - Tuesday, May 1, 2012 4:30 PM -
0 Votes
Sharing current SQL Server Database with another computer
Make sure your browser services are up and running on DB server 4.Answered | 2 Replies | 1354 Views | Created by ShehanMorawaka - Sunday, November 3, 2013 8:21 AM | Last reply by Dan Guzman - Sunday, November 3, 2013 10:53 AM -
0 Votes
Running same SSIS Packages for Different Destination Databases
And I dont think you need 10 procedures for this.Answered | 1 Replies | 1250 Views | Created by SGMSSharePoint - Friday, March 7, 2014 10:51 AM | Last reply by Visakh16 - Friday, March 7, 2014 11:17 AM -
0 Votes
Passing a table parameter to a stored procedure in a different Database on the same Server
Hi James, You cannot pass the TVP to stored procedure in another database.Answered | 5 Replies | 6288 Views | Created by James Braun - Thursday, December 16, 2010 11:29 AM | Last reply by Plamen Ratchev - Thursday, December 16, 2010 6:58 PM -
0 Votes
How to move MOSS database to another database server?
Hi Andy, Beside all replies provided, there are 3 cases for moving moss databases to another database server, First Case: you ...Answered | 4 Replies | 5369 Views | Created by AndyW2007 - Monday, February 22, 2010 1:12 AM | Last reply by AndyW2007 - Tuesday, February 23, 2010 3:28 AM -
1 Votes
restoring a database from a different database
Replace is used to restore the database even if there is an existing database with the same name. ie even if there was a database named new2db in that ...Answered | 7 Replies | 1140 Views | Created by vtpcnk - Wednesday, July 9, 2014 2:16 AM | Last reply by vtpcnk - Thursday, July 10, 2014 1:10 AM -
0 Votes
Acessing tables of different database from current database
You can use DatabaseName.Schema.TableName if both the DB belong to same server.Answered | 2 Replies | 6589 Views | Created by Raj_Tech - Tuesday, April 15, 2008 5:32 PM | Last reply by Anand Ar - Monday, September 10, 2012 11:52 PM -
4 Votes
How I need to run procedure in every database
or this article: http://www.mssqltips.com/sqlservertip/1612/creating-your-own-sql-server-system-stored-procedures/ Regards, ...Answered | 4 Replies | 1994 Views | Created by Ray Ben - Friday, November 16, 2012 10:48 AM | Last reply by Basit Farooq - Friday, November 16, 2012 12:45 PM -
3 Votes
How can i access SQL Server Analysis Services database remotely from another computer in different domain?
As i want to access SQL Server Analysis Services database from another computer which is on different network.Answered | 6 Replies | 3830 Views | Created by Sohaib Ali - Wednesday, March 7, 2018 6:58 PM | Last reply by Visakh16 - Thursday, March 15, 2018 6:11 AM -
1 Votes
Move Content Database to another disk on the same server
ID=137 is entitled "Databases: How do you move the "Windows Internal Database" (embedded SQL Server ...Answered | 2 Replies | 6047 Views | Created by schnauzer - Thursday, April 30, 2009 4:42 AM | Last reply by schnauzer - Thursday, April 30, 2009 12:24 PM -
0 Votes
Copy from one database to another on the same server.
...The location of the backup file is on my memorystick "E:\TrManager.bak" ok, Then in options ...Answered | 8 Replies | 6689 Views | Created by rowter - Wednesday, October 27, 2010 6:31 PM | Last reply by Andrea Montanari - Wednesday, October 27, 2010 10:38 PM -
0 Votes
Two databases cannot be on same server
what about running different versions of SQL Server?Answered | 11 Replies | 2934 Views | Created by Lithuanian98 - Sunday, September 9, 2012 5:46 PM | Last reply by Lithuanian98 - Wednesday, October 3, 2012 3:24 PM -
2 Votes
Linking tables of different database in same server.
Without changing the query: No, somehow something in the query must be change, because the object don't exists in the current database (as far ...Answered | 7 Replies | 1300 Views | Created by Prahalnathan - Monday, February 10, 2014 10:19 AM | Last reply by scott_morris-ga - Monday, February 10, 2014 1:46 PM -
0 Votes
connect to database - on another pc
Yeah, it's probably Access, and the OP doesn't know how to go beyond two or more user machines accessing the same database.Answered | 6 Replies | 495 Views | Created by TakeshiKitano - Monday, August 25, 2014 1:59 PM | Last reply by Noam B - Tuesday, August 26, 2014 9:54 AM -
0 Votes
Create content database from another content database in the same farm
Hi, You can't use a backup up from the content database on the same database server.Answered | 1 Replies | 3958 Views | Created by tabudayyeh - Sunday, February 5, 2012 3:02 PM | Last reply by André Krijnen - Sunday, February 5, 2012 3:08 PM - Items 1 to 20 of 4096210 Next ›
No announcements
