Migrating from 2000 to 2008 via 2005
Sun, 30 Aug 2009 08:36:01 -0700
Any help appreciated. I have a database created in SQL 2000 that is being
managed in SQL 2005. I need to copy it from the 2005 instance to a 2008
instance (different server on a different domain). I have successfully moved
two other databases (which were created natively in 2005) from the 2005
instance to 20 ...
|
Re: Installing SQL Client Tools
Thu, 27 Aug 2009 22:34:14 -0400
The full tools are not free and so you cannot just download them (unless you
install the evaluation edition, but then they are only "free" for the length
of the evaluation, and using them beyond that time is against the EULA and I
wouldn't recommend it, especially on an employer's computer). You can buy
develop ...
|
SQL 2000 upgrade to SQL 2005 - Are there any issues?
Thu, 27 Aug 2009 11:58:32 -0700
I am working with SQL 2005 Developer edition and love everything. We are
getting ready to replace the SQL 2000 server with SQL 2005. Will it just
install over the present server and upgrade everything including the data?
Yes, I do plan to run full backups on everything.
Rich
...
|
Management Studio very slow ... only on remote use
Wed, 26 Aug 2009 05:44:24 -0700 (PDT)
I installed Management Studio on a desktop and I'm connecting through
a non standard port to a sql 2005 db engine on another network,
through a firewall.
Executing query this way:
1) Connect
2) New Query
3) select * from mytab
works like a charm.
Instead, trying to doing:
1) Right click on table
...
|
Is there a way in SQL Server 2005/2008 to run a solution from a command line?
Mon, 24 Aug 2009 21:04:19 GMT
Running SQL Server 2008.
Just wanting to know if there is a way to run a project/solution from the
command line.
I know I could put some of the solutions in a stored procedure and then run
from command line, but I don't want to split my solution up and some of the
solutions are universal, they handle SQL Serve ...
|
Unable to view Object Explorer
Fri, 21 Aug 2009 16:38:01 -0700
Hi - Initially I got an Registered Server Exception when I opened the SQL
Server amangement studio, but after I installed SP1 for SQL server 2008 that
error went away but now I do not see the Object Explorer window. However, I
do see the object explorer details without any problem. How should I go about
reso ...
|
Query Tool
Tue, 18 Aug 2009 07:29:01 -0700
Could someone recommend a free query tool? thanks ...
|
|
|
Re: Monitoring Tools
Sat, 15 Aug 2009 14:25:49 -0300
> Asking for suggestions on monitoring admin tool.
> Have 80instances and need produce backup reports , get version of all
> instances and every month need to collect informations like number of
> databases / sizes / etc. I want a admin server that collect
> information from all instances.
>
> Anyone know ...
|
??????????????????
Fri, 14 Aug 2009 20:49:31 -0700
Çë¸÷½çÖ§³ÖÕß, ¸øÎÒÁªÏµÒ»ÏÂ.
ҶЦ¾ê
...
|
BIDS Query Designer very slow in VS 2008
Wed, 12 Aug 2009 14:24:05 -0700 (PDT)
I am in the process of upgrading my Report Server projects from 2005
to 2008. These reports use an Analysis Services data source and have
queries that are anywhere from 20 to 100 lines of MDX. After
upgrading a report, when I open or save a dataset in the Query
Designer, it takes up to 20 seconds. In 2005, th ...
|
