RE: @@DBTS value in SNAPSHOT after "CREATE DATABASE... AS SNAPSHOT OF.
Sun, 7 Mar 2010 06:38:01 -0800
Interestingly, if I restore the database from the snapshot
use SnapTestMaster_Snap
select @@dbts
use SnapTestMaster
select @@dbts
use master
RESTORE DATABASE SnapTestMaster
FROM DATABASE_SNAPSHOT = 'SnapTestMaster_Snap'
use SnapTestMaster
select @@dbts
Then the @@dbts value for SnapTestMaster is the v ...
|
send automatic information to my table on the second sql server 2005
Sat, 06 Mar 2010 09:01:52 GMT
Hello Team
There is a table on my first sql server 2005 , we enter many information to
this table. Also there is same table on my second sql server 2005. I want to
send information to my second sql server everyday.
Thanks for Help
...
|
Uninstall SQL2005 Reporting Service
Fri, 5 Mar 2010 20:38:31 -0800
Hi..
I try to uninstall SQL 2005 reporting service from add/remove program,
but it didn;t work because it's still there.
Does anyone has any idea on how to remove it once & for all?
Thanks. ...
|
SQL 2008 R2 - ALTER INDEX performance degredation with compreessed indexes
Fri, 5 Mar 2010 23:11:50 +0100
I'm doing initial tests with different aspects of performance using PAGE
compression with SQL 2008 R2.
I've noticed that rebuilding indexes using "ALTER INDEX" takes longer time
with PAGE compressed indexes than with uncompressed indexes.
Is this to be expected in general? - If so, can anyone point me to t ...
|
SQL 2005 & server side trace
Fri, 5 Mar 2010 13:48:43 -0800 (PST)
Hi,
I am trying to set up a server side trace where it will collect logins
and objects access by a list of users in one database. The problem I
am running into is using more then 2 sp_trace_setfilter to capture
more then 1 user name. Either I get nothing or get everyone and that
is not what I want.
Here i ...
|
Change sa password SQL Server 2005
Fri, 5 Mar 2010 12:56:00 -0500
I need to change the sa password for one of my production servers.
Nobody knows what the current one is and Dynamics GP requires the sa
credentials for some administrative tasks.
I have access to the server and can easily change the sa password, my
question is:
What consequences could this b ...
|
trace logins
Fri, 5 Mar 2010 17:47:09 +0100
How do I trace all logins to a specific database?
I want all successful and failed accesses to some of my databases in my sql
server.
1. I have about 100 databases, I want to trace accesses to about 20 of them.
2. The databases has several logins each, I don't want to search in logs for
every single possi ...
|
|
|
impact of adding index to column
Fri, 5 Mar 2010 08:18:19 -0800 (PST)
Where I work we have a SQL Server 2005 DB. There has recently been a
new business requirement that will require that we do regular (daily)
updates to one of our primary tables. This update will be based on
the value of a non-index varchar column. In other words the WHERE
clause for the update includes a condi ...
|
Recommendations for self-teaching material for 2005/2008 Business
Intelligence Platform?
Fri, 05 Mar 2010 12:56:53 +0100
Hello,
can someone recommend a self-teaching material for the Business
Intelligence Platform 2005/2008 (Analysis Services, Reporting Services,
Data Mining, etc.)?
Thanks!
Thomas ...
|
Secure location to store keys ?
Fri, 5 Mar 2010 12:17:25 +0100
Hello
I would like to use the database encryption feature of SQL Server 2008. My
security officer agrees, but he asks me to define the policy to store the
certificate and the private key. He says that our safe is not safe enough
(remember 9/11), that we should think of a bank safe, etc. What is the best
pra ...
|
