Does SQL Server 2005 Express has the method that delete automatically rows ordered by time colum

Hi, I made table that stores monitoring data every 1 minute.

It should have only 60 minutes-data from current time.

I delete data which stored 60 minutes ago before insert.

I'll be happy to find that the database engine does automatically above procedure.

You could use an insert trigger which fires when new data is inserted. Place your delete statement here to delete old records.

--
SvenC

Does SQL Server 2005 Express has the method that delete automatically rows ordered by time c

Hi, I made table that stores monitoring data every 1 minute.

It should have only 60 minutes-data from current time.

I delete data which stored 60 minutes ago before insert.

I'll be happy to find that the database engine does automatically above procedure.

You could use an insert trigger which fires when new data is inserted. Place your delete statement here to delete old records.

--
SvenC

Does SQL Server 2000 have any method or sp to copy files from other machine? -

If I use a workstation connected to a SQL Server 2000, can I remote the SQL Server to copy some external files (mdf & ldf) from other network machine.
I need to do it by programming, under condition:
SQL Server name is provided.
Network paths of mdf & ldf files are provided.You need to detach them using SP_DETACH_DB and copy them to the new location. Also refer to books online for RESTORE ... WITH MOVE topic for more information.

Does replication setup make some entry in the Remote servers setti

If I create a transactional replication - Push method in SQL 2K standard with
sp4, will replication create entries in the Remote Servers setting in EM?
Currently I found three entries in the Remote Servers listing, server name
for the publishing server name, server name for the subscriber server, and
repl_distrbutor.
If the replication does make these entries, I have no problem with the
repl_distributor being there. But I have problem with the subscriber server
name being there because I want to create a Linked Server with that same name
but I can't since the name is already in use by the remote servers.
Please let me know which one or all of the above names are legit if indeed
repliation put them in there to begin with.
Say if the above entries need to be there, how I should move them to the
Linked Servers setting because the remote servers feature is for backward
compatible reason and linked servers is more dynamic and is the one to
replace it.
Thanks in advance.
Wingman
Remote Servers and Linked Servers are all stored in the sysservers table in
the master database. Different flag values determine what an entry actually
represents. There is even a special entry for the local server name. If
you want or need to use a replication participating server as a linked
server, there is a special work-around to enable that functionality.
PRB: Adding a Linked Server Causes Error 15028
http://support.microsoft.com/kb/274098/en-us
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Wingman" <Wingman@.discussions.microsoft.com> wrote in message
news:DC17EBF5-D4FF-49C6-83A7-7E3E4F8D0FE0@.microsoft.com...
> If I create a transactional replication - Push method in SQL 2K standard
> with
> sp4, will replication create entries in the Remote Servers setting in EM?
> Currently I found three entries in the Remote Servers listing, server name
> for the publishing server name, server name for the subscriber server, and
> repl_distrbutor.
> If the replication does make these entries, I have no problem with the
> repl_distributor being there. But I have problem with the subscriber
> server
> name being there because I want to create a Linked Server with that same
> name
> but I can't since the name is already in use by the remote servers.
> Please let me know which one or all of the above names are legit if indeed
> repliation put them in there to begin with.
> Say if the above entries need to be there, how I should move them to the
> Linked Servers setting because the remote servers feature is for backward
> compatible reason and linked servers is more dynamic and is the one to
> replace it.
> Thanks in advance.
> Wingman
|||Ok, I tried that stored procedure and the server name now shows up in both
linked server and remote servers. And I still can't execute the remote
stored procedure. Here is my observation after reading the link. It said
the status for a remote server of a subscriber supposedly a 69. In order for
it to become a linked server of a subscriber it needs to be 229. Before I
executed the stored procedure, the server name that I want to change its
status is 1093 not 69. After the execution, it added 160 to it to become
1253. Is the 1253 status correct? The initial status number 1093 is not 69,
is it because there are other settings added values to it?
Here are my questions:
1) is it correct that the server name will show up both in the linked
servers and remote servers in EM?
2) Is the 1253 new status correct?
3) the link didn't say I need to do a service restart, what do you think? I
am getting this error when I execute a remote stored procedure:
"Could not execute procedure on remote server 'server1' because SQL Server
is not configured for remote access. Ask your system administrator to
reconfigure SQL Server to allow remote access."
Also, when I try to double click on the 'table' of the linked server, it
said the server doesn't exist or access denied. The SQL login name I
entered in the Linked server properties has the sys admin right and this
account exists in both servers.
Wingman
"Wingman" wrote:

> If I create a transactional replication - Push method in SQL 2K standard with
> sp4, will replication create entries in the Remote Servers setting in EM?
> Currently I found three entries in the Remote Servers listing, server name
> for the publishing server name, server name for the subscriber server, and
> repl_distrbutor.
> If the replication does make these entries, I have no problem with the
> repl_distributor being there. But I have problem with the subscriber server
> name being there because I want to create a Linked Server with that same name
> but I can't since the name is already in use by the remote servers.
> Please let me know which one or all of the above names are legit if indeed
> repliation put them in there to begin with.
> Say if the above entries need to be there, how I should move them to the
> Linked Servers setting because the remote servers feature is for backward
> compatible reason and linked servers is more dynamic and is the one to
> replace it.
> Thanks in advance.
> Wingman
|||Yes, it is correct to see the servers listed in more than one place. The
values you refer to are bit flags held in an integer field. Addition is not
the correct operation, logical OR is the correct operation.
You need to enable each server for remote access, just like it says. Login
to each remote SQL server and execute the following:
exec sp_configure 'remote access', 1
go
reconfigure with override
go
This tells the remote server to accept remote queries.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Wingman" <Wingman@.discussions.microsoft.com> wrote in message
news:59C3CADD-1BCB-45CD-9DB0-2EEEFCADCA6B@.microsoft.com...[vbcol=seagreen]
> Ok, I tried that stored procedure and the server name now shows up in both
> linked server and remote servers. And I still can't execute the remote
> stored procedure. Here is my observation after reading the link. It said
> the status for a remote server of a subscriber supposedly a 69. In order
> for
> it to become a linked server of a subscriber it needs to be 229. Before
> I
> executed the stored procedure, the server name that I want to change its
> status is 1093 not 69. After the execution, it added 160 to it to become
> 1253. Is the 1253 status correct? The initial status number 1093 is not
> 69,
> is it because there are other settings added values to it?
> Here are my questions:
> 1) is it correct that the server name will show up both in the linked
> servers and remote servers in EM?
> 2) Is the 1253 new status correct?
> 3) the link didn't say I need to do a service restart, what do you think?
> I
> am getting this error when I execute a remote stored procedure:
> "Could not execute procedure on remote server 'server1' because SQL Server
> is not configured for remote access. Ask your system administrator to
> reconfigure SQL Server to allow remote access."
> Also, when I try to double click on the 'table' of the linked server, it
> said the server doesn't exist or access denied. The SQL login name I
> entered in the Linked server properties has the sys admin right and this
> account exists in both servers.
>
> Wingman
>
> "Wingman" wrote:

Does Microsoft SQL Server support any partitioning method?

I was wondering if Microsoft SQL Server support any partitioning method (like range, list, hash or composite partitioning in Oracle) or you have to partition all tables manually?
Thanks in advance,
BraciaYukon (only beta version available so far) is designed to support partitioning, but in SQL 2K you have to deal with it manually.

Originally posted by Bracia
I was wondering if Microsoft SQL Server support any partitioning method (like range, list, hash or composite partitioning in Oracle) or you have to partition all tables manually?

Thanks in advance,

Bracia

Does LoadFromSqlServer2 method work?

Hi. There's little documentation on the Microsoft.SqlServer.Dts.Runtime.Application "LoadFromSqlServer2" method, and even less via any search engine.

http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.application.loadfromsqlserver2.aspx

I cannot seem to ever get the method to work; it returns "InvalidCastException: No such interface supported."

Is this code-speak for "does not work at this time" ?

Sample code (add a reference to c:\Program Files\Microsoft SQL Server\90\SDK\Assemblies\Microsoft.SQLServer.ManagedDTS.dll)

Dim app As New Microsoft.SqlServer.Dts.Runtime.Application

Dim pkg As Microsoft.SqlServer.Dts.Runtime.Package

Dim cnDatasource As New System.Data.SqlClient.SqlConnection

cnDatasource.ConnectionString = _

"Data Source=SQLOLEDB;SERVER=" & m_Datasource & ";Initial Catalog=msdb;Integrated Security=SSPI"

cnDatasource.Open()

pkg = app.LoadFromSqlServer2(m_PackageFolderPath & m_PackageName, cnDatasource, Nothing)

I am aware of the "LoadFromSqlServer" and "LoadFromDtsServer" methods; I like the idea of the Win-NT authentication (theoretically) available in the "LoadFromSqlServer2" method.

Did you read the first line of that link you sent?

"This method supports the SQL Server 2005 infrastructure and is not intended to be used directly from your code. "

|||

I guess I didn't. I've not met documentation that I wasn't supposed to use.

Thanks for the fact... it would have really been useful.