Failure Details: remote

Showing posts with label remote. Show all posts

Tuesday, March 27, 2012

Getting 5105 error when I try to attach database

Here's what I did. I created a new database on SQL Server 2000, on a remote
server, using Enterprise Manager. I then exported some data from another
database (same instance) into my new database. I then detached the database
I created, and copied the .MDF and .LDF files to my machine.
I've been trying to attach the .MDF and .LDF files, again using Enterprise
Manager (I'm also running SQL Server 2000). In EM, I tell it to Attach
Database... I give it the path to my .MDF and .LDF files, hit Verify, and
they verify (both the .MDF and .LDF file paths show up in the window,
checked). The problem comes when I hit OK. It gives me error 5105 (device
activation error), it gives the same path that I gave it, and says that the
filename may be wrong.
I don't think this is a permissions problem, and I've checked whether any
other process has grabbed ahold of it, and there isn't any. So I'm not sure
what's wrong. Please help.
Thanks.Miller -
Please go through the following link :-
http://support.microsoft.com/default.aspx?scid=kb;en-us;304261
Let me know if you where able to get the help for your problem.
Regards
"Mark Miller" wrote:
> Here's what I did. I created a new database on SQL Server 2000, on a remote
> server, using Enterprise Manager. I then exported some data from another
> database (same instance) into my new database. I then detached the database
> I created, and copied the .MDF and .LDF files to my machine.
> I've been trying to attach the .MDF and .LDF files, again using Enterprise
> Manager (I'm also running SQL Server 2000). In EM, I tell it to Attach
> Database... I give it the path to my .MDF and .LDF files, hit Verify, and
> they verify (both the .MDF and .LDF file paths show up in the window,
> checked). The problem comes when I hit OK. It gives me error 5105 (device
> activation error), it gives the same path that I gave it, and says that the
> filename may be wrong.
> I don't think this is a permissions problem, and I've checked whether any
> other process has grabbed ahold of it, and there isn't any. So I'm not sure
> what's wrong. Please help.
> Thanks.
>|||I tried turning on trace flag 1807, like the article says, to turn off the
check SQL Server does to detect if I'm accessing a database file through a
network share, and I get the same error. I gave this a try because it seemed
to be in the ballpark of my problem, but I'm not trying to access the
database file over a network share anyway. It's on my computer's hard drive.
Other than this bit of information in the article, nothing else in it seemed
relevant.
"surajits" wrote:
> Miller -
> Please go through the following link :-
> http://support.microsoft.com/default.aspx?scid=kb;en-us;304261
> Let me know if you where able to get the help for your problem.
> Regards
>
> "Mark Miller" wrote:
> > Here's what I did. I created a new database on SQL Server 2000, on a remote
> > server, using Enterprise Manager. I then exported some data from another
> > database (same instance) into my new database. I then detached the database
> > I created, and copied the .MDF and .LDF files to my machine.
> >
> > I've been trying to attach the .MDF and .LDF files, again using Enterprise
> > Manager (I'm also running SQL Server 2000). In EM, I tell it to Attach
> > Database... I give it the path to my .MDF and .LDF files, hit Verify, and
> > they verify (both the .MDF and .LDF file paths show up in the window,
> > checked). The problem comes when I hit OK. It gives me error 5105 (device
> > activation error), it gives the same path that I gave it, and says that the
> > filename may be wrong.
> >
> > I don't think this is a permissions problem, and I've checked whether any
> > other process has grabbed ahold of it, and there isn't any. So I'm not sure
> > what's wrong. Please help.
> >
> > Thanks.
> >|||When you did the backup, did you specify a device or a file? If a device and
you are restoring from the file, you may be seeing a header conflict.
"Mark Miller" wrote:
> I tried turning on trace flag 1807, like the article says, to turn off the
> check SQL Server does to detect if I'm accessing a database file through a
> network share, and I get the same error. I gave this a try because it seemed
> to be in the ballpark of my problem, but I'm not trying to access the
> database file over a network share anyway. It's on my computer's hard drive.
> Other than this bit of information in the article, nothing else in it seemed
> relevant.
> "surajits" wrote:
> > Miller -
> > Please go through the following link :-
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;304261
> >
> > Let me know if you where able to get the help for your problem.
> >
> > Regards
> >
> >
> > "Mark Miller" wrote:
> >
> > > Here's what I did. I created a new database on SQL Server 2000, on a remote
> > > server, using Enterprise Manager. I then exported some data from another
> > > database (same instance) into my new database. I then detached the database
> > > I created, and copied the .MDF and .LDF files to my machine.
> > >
> > > I've been trying to attach the .MDF and .LDF files, again using Enterprise
> > > Manager (I'm also running SQL Server 2000). In EM, I tell it to Attach
> > > Database... I give it the path to my .MDF and .LDF files, hit Verify, and
> > > they verify (both the .MDF and .LDF file paths show up in the window,
> > > checked). The problem comes when I hit OK. It gives me error 5105 (device
> > > activation error), it gives the same path that I gave it, and says that the
> > > filename may be wrong.
> > >
> > > I don't think this is a permissions problem, and I've checked whether any
> > > other process has grabbed ahold of it, and there isn't any. So I'm not sure
> > > what's wrong. Please help.
> > >
> > > Thanks.
> > >|||I wasn't trying to back up data. I wanted to transfer data from one database
to another, because I'm working on a software development project. The
source database is behind a firewall, and I can't access it from my
application on my development system. All I need is a subset of the data on
the source database. So I decided to create a new database on the source
instance, export the data I needed into it, detach it, and then copy it to my
machine, where I have my own SQL Server 2000 instance, and where I was
planning on accessing it from my application. I transferred it using a
straight network file copy process (ie. copy from source file system and
paste to destination file system). No tape backup was involved. Is the
picture getting clearer now? :) Forgive me for not making this clearer. I
sometimes forget I'm not always talking to other developers.
"jrpm" wrote:
> When you did the backup, did you specify a device or a file? If a device and
> you are restoring from the file, you may be seeing a header conflict.
> "Mark Miller" wrote:
> > I tried turning on trace flag 1807, like the article says, to turn off the
> > check SQL Server does to detect if I'm accessing a database file through a
> > network share, and I get the same error. I gave this a try because it seemed
> > to be in the ballpark of my problem, but I'm not trying to access the
> > database file over a network share anyway. It's on my computer's hard drive.
> > Other than this bit of information in the article, nothing else in it seemed
> > relevant.
> >
> > "surajits" wrote:
> >
> > > Miller -
> > > Please go through the following link :-
> > > http://support.microsoft.com/default.aspx?scid=kb;en-us;304261
> > >
> > > Let me know if you where able to get the help for your problem.
> > >
> > > Regards
> > >
> > >
> > > "Mark Miller" wrote:
> > >
> > > > Here's what I did. I created a new database on SQL Server 2000, on a remote
> > > > server, using Enterprise Manager. I then exported some data from another
> > > > database (same instance) into my new database. I then detached the database
> > > > I created, and copied the .MDF and .LDF files to my machine.
> > > >
> > > > I've been trying to attach the .MDF and .LDF files, again using Enterprise
> > > > Manager (I'm also running SQL Server 2000). In EM, I tell it to Attach
> > > > Database... I give it the path to my .MDF and .LDF files, hit Verify, and
> > > > they verify (both the .MDF and .LDF file paths show up in the window,
> > > > checked). The problem comes when I hit OK. It gives me error 5105 (device
> > > > activation error), it gives the same path that I gave it, and says that the
> > > > filename may be wrong.
> > > >
> > > > I don't think this is a permissions problem, and I've checked whether any
> > > > other process has grabbed ahold of it, and there isn't any. So I'm not sure
> > > > what's wrong. Please help.
> > > >
> > > > Thanks.
> > > >|||I suggest to first try doing this from Query Analyzer using sp_attach_db and make sure you get the
parameters correct. Possibly, you need to specify correct path for the ldf file if not in same path
as on original SQL Server. If that doesn't work (and you feel that you got the parameters correct),
I'd try to attach the original files (before the file copy) on the originating server. If that work,
I'd copy the files over the network back onto the originating server and try to attach those
files...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Mark Miller" <MarkMiller@.discussions.microsoft.com> wrote in message
news:6637F49E-D3B5-4C20-800B-45CB72EE5F78@.microsoft.com...
>I wasn't trying to back up data. I wanted to transfer data from one database
> to another, because I'm working on a software development project. The
> source database is behind a firewall, and I can't access it from my
> application on my development system. All I need is a subset of the data on
> the source database. So I decided to create a new database on the source
> instance, export the data I needed into it, detach it, and then copy it to my
> machine, where I have my own SQL Server 2000 instance, and where I was
> planning on accessing it from my application. I transferred it using a
> straight network file copy process (ie. copy from source file system and
> paste to destination file system). No tape backup was involved. Is the
> picture getting clearer now? :) Forgive me for not making this clearer. I
> sometimes forget I'm not always talking to other developers.
> "jrpm" wrote:
>> When you did the backup, did you specify a device or a file? If a device and
>> you are restoring from the file, you may be seeing a header conflict.
>> "Mark Miller" wrote:
>> > I tried turning on trace flag 1807, like the article says, to turn off the
>> > check SQL Server does to detect if I'm accessing a database file through a
>> > network share, and I get the same error. I gave this a try because it seemed
>> > to be in the ballpark of my problem, but I'm not trying to access the
>> > database file over a network share anyway. It's on my computer's hard drive.
>> > Other than this bit of information in the article, nothing else in it seemed
>> > relevant.
>> >
>> > "surajits" wrote:
>> >
>> > > Miller -
>> > > Please go through the following link :-
>> > > http://support.microsoft.com/default.aspx?scid=kb;en-us;304261
>> > >
>> > > Let me know if you where able to get the help for your problem.
>> > >
>> > > Regards
>> > >
>> > >
>> > > "Mark Miller" wrote:
>> > >
>> > > > Here's what I did. I created a new database on SQL Server 2000, on a remote
>> > > > server, using Enterprise Manager. I then exported some data from another
>> > > > database (same instance) into my new database. I then detached the database
>> > > > I created, and copied the .MDF and .LDF files to my machine.
>> > > >
>> > > > I've been trying to attach the .MDF and .LDF files, again using Enterprise
>> > > > Manager (I'm also running SQL Server 2000). In EM, I tell it to Attach
>> > > > Database... I give it the path to my .MDF and .LDF files, hit Verify, and
>> > > > they verify (both the .MDF and .LDF file paths show up in the window,
>> > > > checked). The problem comes when I hit OK. It gives me error 5105 (device
>> > > > activation error), it gives the same path that I gave it, and says that the
>> > > > filename may be wrong.
>> > > >
>> > > > I don't think this is a permissions problem, and I've checked whether any
>> > > > other process has grabbed ahold of it, and there isn't any. So I'm not sure
>> > > > what's wrong. Please help.
>> > > >
>> > > > Thanks.
>> > > >sql

Getting "An existing connection was forcibly closed by the remote host (System)" error

I cannot connect to Analysis Services through SSMS. Receiving a "An existing connection was forcibly closed by the remote host (System) error." I changed my password this morning due to our company security policies and now I can't do squat. This is definitely a bug in the service as something is cached and not clearing out. I've rebooted both the server and client a couple of times. Running AS 2005 SP1 on Windows Server 2003. I can connect through another machine. Here's the message I'm getting. Don't know where to look to fix the problem.

===================================

Cannot connect to hctx-idwdev.

===================================

A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)

Program Location:

at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla()
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

===================================

Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)

Program Location:

at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ForceRead(Stream stream, Byte[] buffer, Int32 length)
at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ReadHeader()
at Microsoft.AnalysisServices.AdomdClient.DimeRecord..ctor(Stream stream)
at Microsoft.AnalysisServices.AdomdClient.DimeReader.ReadRecord()
at Microsoft.AnalysisServices.AdomdClient.TcpStream.GetResponseDataType()

===================================

An existing connection was forcibly closed by the remote host (System)

Program Location:

at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)

I've uninstalled the client tools and reinstalled. After rebooting, I STILL CANNOT CONNECT TO ANALYSIS SERVICES FROM THIS MACHINE.

Major issue addressed in next service pack? Is there a local cache I need to clear? Any help would be greatly appreciated.

|||Fixed the problem even though the solution is less than ideal. To resolve, we had to delete my user profile on the machine. Apparently, something used by the drivers is being stored in the Document and Settings for the current user. What exactly we weren't able to identify.

Getting "An existing connection was forcibly closed by the remote host (System)" e

===================================

Cannot connect to hctx-idwdev.

===================================

A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)

Program Location:

===================================

Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)

Program Location:

===================================

An existing connection was forcibly closed by the remote host (System)

Program Location:

at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)

I've uninstalled the client tools and reinstalled. After rebooting, I STILL CANNOT CONNECT TO ANALYSIS SERVICES FROM THIS MACHINE.

Major issue addressed in next service pack? Is there a local cache I need to clear? Any help would be greatly appreciated.

Friday, March 23, 2012

GETDATE() Function Issue

Hi Everyone,
I'm running into an issue trying to update a column on a remote database.
The server is linked from the server I'm calling this update statement. The
syntax is as follows:
UPDATE Server1.Test.dbo.Testdata
SET dtUpdated = GETDATE()
WHERE intID = 111
The problem is that the update takes a very long time to complete. Now if I
declare a variable with a datetime and set that variable to GETDATE(), the
update takes seconds. Is there some known issue? Can anyone help with this
?
I have noticed that I can update small size tables, but it takes much longer
to update large size tables. The columns in the "Where" clause have indexes
on them and that can't be the issue since my test using the variable worked
quicker. I'm just wondering why I can't use the GETDATE() function directly
.
DarrenDarren
No, it works fine with GETDATE() function too. Please take a look at
execution plan of the query (with GETDATE() and without) and see what is
going on
"Darren" <Darren@.discussions.microsoft.com> wrote in message
news:8D7E1367-7B04-4F57-B671-F79AB6F6E60C@.microsoft.com...
> Hi Everyone,
> I'm running into an issue trying to update a column on a remote database.
> The server is linked from the server I'm calling this update statement.
> The
> syntax is as follows:
> UPDATE Server1.Test.dbo.Testdata
> SET dtUpdated = GETDATE()
> WHERE intID = 111
> The problem is that the update takes a very long time to complete. Now if
> I
> declare a variable with a datetime and set that variable to GETDATE(), the
> update takes seconds. Is there some known issue? Can anyone help with
> this?
> I have noticed that I can update small size tables, but it takes much
> longer
> to update large size tables. The columns in the "Where" clause have
> indexes
> on them and that can't be the issue since my test using the variable
> worked
> quicker. I'm just wondering why I can't use the GETDATE() function
> directly.
> Darren|||Run it again and see if there is any issues
Madhivanan|||I looked at the execution plan and it is doing what I thought it would. The
execution plan shows that it does a remote scan to look at the whole table
then it will filter by the where clause. This is the source of my problem.
For a large table that holds over 4 million records, it has to scan that
whole table before filtering on the primary key I'm already passing it. I
don't understand why on the remote server it must scan the whole table
instead of already filtering by the where clause. When I use a variable to
update the date column it shows a remote query for the update. Why is this
happening? Did some setting happen that I don't know about? How can I trac
k
down this issue?
"Uri Dimant" wrote:

> Darren
> No, it works fine with GETDATE() function too. Please take a look at
> execution plan of the query (with GETDATE() and without) and see what is
> going on
>
>
>
> "Darren" <Darren@.discussions.microsoft.com> wrote in message
> news:8D7E1367-7B04-4F57-B671-F79AB6F6E60C@.microsoft.com...
>
>

Wednesday, March 7, 2012

Get SQL 2005 Server Licence Info

Hi!
I'm looking for a way to retrieve Licence Info from SQL 2005 Server with
VBScript
From a remote location I connect to the server and grab those info with my
administrative rights, but I'm not accessing the DB with a SA account...
With SQL 2000 Server I retrieved those info from registry...
In HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\80\MSSQLLicenseInfo\MSSQL8.00
Value Mode and ConcurrentLimit
But now hot to get this info for SQL 2005'
Thanks a lot!
FredOften, the quality of the responses received is related to our ability to
'bounce' ideas off of each other. In the future, to make it easier for us to
give you ideas, and to prevent folks from wasting time on already answered
questions, please:
Don't post to multiple newsgroups. Choose the one that best fits your
question and post there. Only post to another newsgroup if you get no answer
in a day or two (or if you accidentally posted to the wrong newsgroup -and
you indicate that you've already posted elsewhere).
If you really think that a question belongs into more than one newsgroup,
then use your newsreader's capability of multi-posting, i.e., posting one
occurrence of a message into several newsgroups at once. If you multi-post
appropriately, answers 'should' appear in all the newsgroups. Folks
responding in different newsgroups will see responses from each other, even
if the responses were posted in a different newsgroup.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"ShrimpBoy" <ShrimpBoy@.discussions.microsoft.com> wrote in message
news:EAE33983-35BB-49BD-B357-AF863B4FFA89@.microsoft.com...
> Hi!
> I'm looking for a way to retrieve Licence Info from SQL 2005 Server with
> VBScript
> From a remote location I connect to the server and grab those info with my
> administrative rights, but I'm not accessing the DB with a SA account...
> With SQL 2000 Server I retrieved those info from registry...
> In HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
> Server\80\MSSQLLicenseInfo\MSSQL8.00
> Value Mode and ConcurrentLimit
> But now hot to get this info for SQL 2005'
>
> Thanks a lot!
> Fred
>|||Hey
Could you please try to answer the question?
Your post is making me waste my precious time!
Go away with your completly boring comment!
You prevent people with real knowledge to answer my questions since all my
posts seem to be answered!!!
Fred
"Arnie Rowland" wrote:
> Often, the quality of the responses received is related to our ability to
> 'bounce' ideas off of each other. In the future, to make it easier for us to
> give you ideas, and to prevent folks from wasting time on already answered
> questions, please:
> Don't post to multiple newsgroups. Choose the one that best fits your
> question and post there. Only post to another newsgroup if you get no answer
> in a day or two (or if you accidentally posted to the wrong newsgroup -and
> you indicate that you've already posted elsewhere).
> If you really think that a question belongs into more than one newsgroup,
> then use your newsreader's capability of multi-posting, i.e., posting one
> occurrence of a message into several newsgroups at once. If you multi-post
> appropriately, answers 'should' appear in all the newsgroups. Folks
> responding in different newsgroups will see responses from each other, even
> if the responses were posted in a different newsgroup.
>
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "ShrimpBoy" <ShrimpBoy@.discussions.microsoft.com> wrote in message
> news:EAE33983-35BB-49BD-B357-AF863B4FFA89@.microsoft.com...
> >
> > Hi!
> >
> > I'm looking for a way to retrieve Licence Info from SQL 2005 Server with
> > VBScript
> >
> > From a remote location I connect to the server and grab those info with my
> > administrative rights, but I'm not accessing the DB with a SA account...
> >
> > With SQL 2000 Server I retrieved those info from registry...
> >
> > In HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
> > Server\80\MSSQLLicenseInfo\MSSQL8.00
> > Value Mode and ConcurrentLimit
> >
> > But now hot to get this info for SQL 2005'
> >
> >
> >
> > Thanks a lot!
> >
> > Fred
> >
>
>|||Arnie Rowland,
Your comment is not justified. Posting in multiple groups is very wise.
Different people visit different sites, and reaching them requires it.
Time is often critical, and waiting "a day or two" is out of the
question.
Sorry I can not help you Fred. Good luck.
Terry
Arnie Rowland wrote:
> Often, the quality of the responses received is related to our ability to
> 'bounce' ideas off of each other. In the future, to make it easier for us to
> give you ideas, and to prevent folks from wasting time on already answered
> questions, please:
> Don't post to multiple newsgroups. Choose the one that best fits your
> question and post there. Only post to another newsgroup if you get no answer
> in a day or two (or if you accidentally posted to the wrong newsgroup -and
> you indicate that you've already posted elsewhere).
> If you really think that a question belongs into more than one newsgroup,
> then use your newsreader's capability of multi-posting, i.e., posting one
> occurrence of a message into several newsgroups at once. If you multi-post
> appropriately, answers 'should' appear in all the newsgroups. Folks
> responding in different newsgroups will see responses from each other, even
> if the responses were posted in a different newsgroup.
>
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "ShrimpBoy" <ShrimpBoy@.discussions.microsoft.com> wrote in message
> news:EAE33983-35BB-49BD-B357-AF863B4FFA89@.microsoft.com...
> >
> > Hi!
> >
> > I'm looking for a way to retrieve Licence Info from SQL 2005 Server with
> > VBScript
> >
> > From a remote location I connect to the server and grab those info with my
> > administrative rights, but I'm not accessing the DB with a SA account...
> >
> > With SQL 2000 Server I retrieved those info from registry...
> >
> > In HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
> > Server\80\MSSQLLicenseInfo\MSSQL8.00
> > Value Mode and ConcurrentLimit
> >
> > But now hot to get this info for SQL 2005'
> >
> >
> >
> > Thanks a lot!
> >
> > Fred
> >|||> Your comment is not justified. Posting in multiple groups is very wise.
But if you multi-post instead of posting independently, all can see all answers. If you post
independently, one can spend 5 minutes writing an answer just to then find out that a satisfactory
answer has already been given in another group. Since there is a lot of traffic here, some posts go
un-answered (no-one here is paid to help), avoiding this waste of resources is considered polite.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Terry" <tduffy@.calamos.com> wrote in message
news:1159795280.559822.85290@.i42g2000cwa.googlegroups.com...
> Arnie Rowland,
> Your comment is not justified. Posting in multiple groups is very wise.
> Different people visit different sites, and reaching them requires it.
> Time is often critical, and waiting "a day or two" is out of the
> question.
> Sorry I can not help you Fred. Good luck.
> Terry
> Arnie Rowland wrote:
>> Often, the quality of the responses received is related to our ability to
>> 'bounce' ideas off of each other. In the future, to make it easier for us to
>> give you ideas, and to prevent folks from wasting time on already answered
>> questions, please:
>> Don't post to multiple newsgroups. Choose the one that best fits your
>> question and post there. Only post to another newsgroup if you get no answer
>> in a day or two (or if you accidentally posted to the wrong newsgroup -and
>> you indicate that you've already posted elsewhere).
>> If you really think that a question belongs into more than one newsgroup,
>> then use your newsreader's capability of multi-posting, i.e., posting one
>> occurrence of a message into several newsgroups at once. If you multi-post
>> appropriately, answers 'should' appear in all the newsgroups. Folks
>> responding in different newsgroups will see responses from each other, even
>> if the responses were posted in a different newsgroup.
>>
>>
>> --
>> Arnie Rowland, Ph.D.
>> Westwood Consulting, Inc
>> Most good judgment comes from experience.
>> Most experience comes from bad judgment.
>> - Anonymous
>>
>> "ShrimpBoy" <ShrimpBoy@.discussions.microsoft.com> wrote in message
>> news:EAE33983-35BB-49BD-B357-AF863B4FFA89@.microsoft.com...
>> >
>> > Hi!
>> >
>> > I'm looking for a way to retrieve Licence Info from SQL 2005 Server with
>> > VBScript
>> >
>> > From a remote location I connect to the server and grab those info with my
>> > administrative rights, but I'm not accessing the DB with a SA account...
>> >
>> > With SQL 2000 Server I retrieved those info from registry...
>> >
>> > In HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
>> > Server\80\MSSQLLicenseInfo\MSSQL8.00
>> > Value Mode and ConcurrentLimit
>> >
>> > But now hot to get this info for SQL 2005'
>> >
>> >
>> >
>> > Thanks a lot!
>> >
>> > Fred
>> >
>|||Yeah, I understand, but I'm not at home and I had to do a request to let me
go to this site to post question, it took about a week and now you're
requesting me to request an access to use another software than the webpage...
If Microsoft thought it would be better like this, they would do it...
They are the one who knows, aren't they?
Fred :P
"Tibor Karaszi" wrote:
> > Your comment is not justified. Posting in multiple groups is very wise.
> But if you multi-post instead of posting independently, all can see all answers. If you post
> independently, one can spend 5 minutes writing an answer just to then find out that a satisfactory
> answer has already been given in another group. Since there is a lot of traffic here, some posts go
> un-answered (no-one here is paid to help), avoiding this waste of resources is considered polite.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Terry" <tduffy@.calamos.com> wrote in message
> news:1159795280.559822.85290@.i42g2000cwa.googlegroups.com...
> > Arnie Rowland,
> >
> > Your comment is not justified. Posting in multiple groups is very wise.
> > Different people visit different sites, and reaching them requires it.
> > Time is often critical, and waiting "a day or two" is out of the
> > question.
> >
> > Sorry I can not help you Fred. Good luck.
> >
> > Terry
> >
> > Arnie Rowland wrote:
> >> Often, the quality of the responses received is related to our ability to
> >> 'bounce' ideas off of each other. In the future, to make it easier for us to
> >> give you ideas, and to prevent folks from wasting time on already answered
> >> questions, please:
> >>
> >> Don't post to multiple newsgroups. Choose the one that best fits your
> >> question and post there. Only post to another newsgroup if you get no answer
> >> in a day or two (or if you accidentally posted to the wrong newsgroup -and
> >> you indicate that you've already posted elsewhere).
> >>
> >> If you really think that a question belongs into more than one newsgroup,
> >> then use your newsreader's capability of multi-posting, i.e., posting one
> >> occurrence of a message into several newsgroups at once. If you multi-post
> >> appropriately, answers 'should' appear in all the newsgroups. Folks
> >> responding in different newsgroups will see responses from each other, even
> >> if the responses were posted in a different newsgroup.
> >>
> >>
> >>
> >>
> >> --
> >> Arnie Rowland, Ph.D.
> >> Westwood Consulting, Inc
> >>
> >> Most good judgment comes from experience.
> >> Most experience comes from bad judgment.
> >> - Anonymous
> >>
> >>
> >> "ShrimpBoy" <ShrimpBoy@.discussions.microsoft.com> wrote in message
> >> news:EAE33983-35BB-49BD-B357-AF863B4FFA89@.microsoft.com...
> >> >
> >> > Hi!
> >> >
> >> > I'm looking for a way to retrieve Licence Info from SQL 2005 Server with
> >> > VBScript
> >> >
> >> > From a remote location I connect to the server and grab those info with my
> >> > administrative rights, but I'm not accessing the DB with a SA account...
> >> >
> >> > With SQL 2000 Server I retrieved those info from registry...
> >> >
> >> > In HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
> >> > Server\80\MSSQLLicenseInfo\MSSQL8.00
> >> > Value Mode and ConcurrentLimit
> >> >
> >> > But now hot to get this info for SQL 2005'
> >> >
> >> >
> >> >
> >> > Thanks a lot!
> >> >
> >> > Fred
> >> >
> >
>

Get SQL 2005 Server Licence Info

Sunday, February 26, 2012

Get Remote SQL Server Date Time

Hi All,
I have 3 sql servers located at different time zones. Say, CST,PST,EST.
Now how can I get current time at EST,PST from the SQL server located
at CST? Is there any query to do that?
I have a stored proc located in SQL server at CST zone where I need to
query for the current date/time of the other zone sql servers.
I tried below query at CST SQL server
SELECT TOP 1 GETDATE() FROM [SERVER-PST].master.dbo.syslocks
But it always gives CST datetime.
Please reply...
Thanks
RP
Please don't multi-post, this question was answered in another group.
"Ram" <Ram@.discussions.microsoft.com> wrote in message
news:7368A848-06BD-4CD0-935D-B98A656B9A5D@.microsoft.com...
> Hi All,
> I have 3 sql servers located at different time zones. Say, CST,PST,EST.
> Now how can I get current time at EST,PST from the SQL server located
> at CST? Is there any query to do that?
> I have a stored proc located in SQL server at CST zone where I need to
> query for the current date/time of the other zone sql servers.
> I tried below query at CST SQL server
> SELECT TOP 1 GETDATE() FROM [SERVER-PST].master.dbo.syslocks
> But it always gives CST datetime.
> Please reply...
> Thanks
> RP
>

Get Remote SQL Server Date Time

Hi All,
I have 3 sql servers located at different time zones. Say, CST,PST,EST.
Now how can I get current time at EST,PST from the SQL server located
at CST? Is there any query to do that?
I have a stored proc located in SQL server at CST zone where I need to
query for the current date/time of the other zone sql servers.
I tried below query at CST SQL server
SELECT TOP 1 GETDATE() FROM [SERVER-PST].master.dbo.syslocks
But it always gives CST datetime.
Please reply...
Thanks
RPPlease don't multi-post, this question was answered in another group.
"Ram" <Ram@.discussions.microsoft.com> wrote in message
news:7368A848-06BD-4CD0-935D-B98A656B9A5D@.microsoft.com...
> Hi All,
> I have 3 sql servers located at different time zones. Say, CST,PST,EST.
> Now how can I get current time at EST,PST from the SQL server located
> at CST? Is there any query to do that?
> I have a stored proc located in SQL server at CST zone where I need to
> query for the current date/time of the other zone sql servers.
> I tried below query at CST SQL server
> SELECT TOP 1 GETDATE() FROM [SERVER-PST].master.dbo.syslocks
> But it always gives CST datetime.
> Please reply...
> Thanks
> RP
>

Get Remote SQL Server Date Time

Hi All,
I have 3 sql servers located at different time zones. Say, CST,PST,EST.
Now how can I get current time at EST,PST from the SQL server located
at CST? Is there any query to do that?
I have a stored proc located in SQL server at CST zone where I need to
query for the current date/time of the other zone sql servers.
I tried below query at CST SQL server
SELECT TOP 1 GETDATE() FROM [SERVER-PST].master.dbo.syslocks
But it always gives CST datetime.
Please reply...
Thanks
RPPlease don't multi-post, this question was answered in another group.
"Ram" <Ram@.discussions.microsoft.com> wrote in message
news:7368A848-06BD-4CD0-935D-B98A656B9A5D@.microsoft.com...
> Hi All,
> I have 3 sql servers located at different time zones. Say, CST,PST,EST.
> Now how can I get current time at EST,PST from the SQL server located
> at CST? Is there any query to do that?
> I have a stored proc located in SQL server at CST zone where I need to
> query for the current date/time of the other zone sql servers.
> I tried below query at CST SQL server
> SELECT TOP 1 GETDATE() FROM [SERVER-PST].master.dbo.syslocks
> But it always gives CST datetime.
> Please reply...
> Thanks
> RP
>

Tuesday, March 27, 2012

Getting 5105 error when I try to attach database

Getting "An existing connection was forcibly closed by the remote host (System)" error

Getting "An existing connection was forcibly closed by the remote host (System)" e

Friday, March 23, 2012

GETDATE() Function Issue

Wednesday, March 7, 2012

Get SQL 2005 Server Licence Info

Get SQL 2005 Server Licence Info

Get SQL 2005 Server Licence Info

Get SQL 2005 Server Licence Info

Get SQL 2005 Server Licence Info

Get SQL 2005 Server Licence Info

Sunday, February 26, 2012

Get Remote SQL Server Date Time

Get Remote SQL Server Date Time

Get Remote SQL Server Date Time

Failure Details

Blog Archive

About Me