|
Can you please explain how to setup a linked server between a SQL Server (A) and a SQL Server Express (B) scenario.
Server A is SQL Server 2000, whereas Server B is SQL Server 2005 Express.
I have set these up in the past, but none where connected to ...
Started by Billy Logan on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
The sp_addlinkedserver stored procedure:
http://blogs.techrepublic.com.com/datacenter/?p=133
Sql server Express supports linked servers.
|
|
Duplicate Advantages of MS SQL Server 2008 over MS SQL Server 2005?
What are the major differences between Sql Server 2005 and Sql Server 2008?
How could I convince my organization to invest in Sql Server 2008?
For me, one major aspect that I see is that...
Started by yoitsfrancis on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Cheers
SQL....
These eliminate the need for red sqling
It covers new features of SQL Server 2008 from the perspective of management, developers and a few other aspects.
SQL Server 2008 allows for table valued parameters.
|
|
I am told that SQL Server 2005 installation with BI tools and SQL Server 2008 with BI tools can't work together on the same computer. Apparently "some" things stop working. This was told to me by one of my team members. Since I'm new to SQL BI, I cant...
Answer Snippets (Read the full thread at stackoverflow):
If its the server you can have side by side reporting services....
Server side I would think twice beforeI'm not sure if this is your development system or the server...
Side of SQL 2005, again we haven't noticed any ill affects.
|
Ask your Facebook Friends
|
I have an application that is currently running against a 32-bit SQL Server 2005 Standard Edition database. For reasons I won't go into here, I need to move the database to a 64-bit SQL Server 2005 Standard edition running on 64-Bit Windows Server 200...
Started by JohnFx on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
The one exception.
Functionality of pure t-sql code is identical (64 bit just performs better ;-).
|
|
Hi,
I am developing an application which needs to backup data between SQL Express 2005 and SQL Server 2008. My client runs with an installation of SQL express 2005 and needs to periodically back up data to a server database running on SQL Server 2008....
Started by Xience on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
It can easily exchange data between SQL Server 2005 (even Express) and SQL Server 2008 as the protocol is completely compatible between 2005 and 2008....
You can have a look at Service Broker.
Be a subscriber).
|
|
In a SQL Server Execution plan plans what is the difference between an Index Scan and an Index Seek
I'm on sql server 2005
Started by cindi on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
In this case SQL Server has to scan multiple pages to find a range of rows which satisfy....
;=, between)
select * from people where pid<7735
An index scan is where SQL server reads the whole to satisfy search predicates.
|
|
I need to pull some BLOB data from a SQL Server 2005 database and generate a SQL script to insert this same data in another database, in another server.
I am only allowed to do this using SQL scripts, I can't use any other utility or write a program in...
Started by Dema on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
The value or image value is copied from ....
Description of TEXTCOPY:
Copies a single text or image value into or out of SQL Server.
This article " Copy Text or Image into or out of SQL Server " could help:
You could integrate.
|
|
What are the differences between MySQL and Sql server? What are the parameter to chose between the two?
Started by Uince81 on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
If its zero then MySQL is probably good enough for you, if its 10k then SQL Server is probably good-differences-between-databases
http://stackoverflow.com/questions/404776/why-isnt-postgresql-as-widespread to choose between....
|
|
Hi Is there any difference between DateTime in c# and DateTime in SQL server?
Started by odiseh on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
(C.E.) in the GregorianCalendar calenda
Transact SQL datetime
Date Range, it was introduced to match....
In fact midnight, January 1, 0001 A.D.
The precision there is 100ns as well.
Seconds
You can also use datetime2 of SQL Server 2008.
|
|
In SQL Server, what is the difference between a @ table, a # table and a ## table?
Started by CraigS on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
##table is a global temporary table and for the record in over 10 years of using SQL Server I have yet a #temp....
Table Variables and Their Effect on SQL Server Performance Differences between SQL Server.
|
