Sunday, February 26, 2012
help Simple question
I need to do some analysis on particular records.
For that I have one Table named EVENT in which I have a field named CODE.
From that field value I can get many entries with same CODE value.
Is there a way to extract the value of CODE field which occurs more often in
a table ?
thanks
regards
SergeHi
create table #test
(
col int not null primary key,
code int
)
insert into #test values (1,100)
insert into #test values (2,100)
insert into #test values (3,200)
insert into #test values (4,100)
insert into #test values (5,200)
insert into #test values (6,800)
select top 1 code,count(*)as occur from #test
group by code
order by occur desc
"serge calderara" <sergecalderara@.discussions.microsoft.com> wrote in
message news:2FC5F7A1-C1F4-4033-82B9-8F84EF8FFDD7@.microsoft.com...
> Dear all,
> I need to do some analysis on particular records.
> For that I have one Table named EVENT in which I have a field named CODE.
> From that field value I can get many entries with same CODE value.
> Is there a way to extract the value of CODE field which occurs more often
> in
> a table ?
> thanks
> regards
> Serge
Help shrinking database doesnt work..
backup log [public] with no_log
DBCC shrinkdatabase ( [public],0,truncateonly)
dump transaction [public] with no_log
GO
Please, Help Metry with this command on query analyzer
I hope this will solve ur problem
to get more explanation on this pl go through the help menu.
EXEC sp_dboption 'databasename', 'trunc. log on chkpt.', 'TRUE'
pl inform wheather it is working or not|||Originally posted by natas
On ower server (ms sql 2000) we have 5 databases who have to much unused space allocated. I all ready tried with the following script to shrink the database and release the allocated unused space to the Operating System. But it doesn't work. :confused: What I'm I doing wrong? :mad:
backup log [public] with no_log
DBCC shrinkdatabase ( [public],0,truncateonly)
dump transaction [public] with no_log
GO
Please, Help Me
I do not know whether your log file or data file is the problem. usually if the data file is larger than what you require ..
a checkdb followed by shrinkdatabase should take care of it..
if your log file is the problem then try shrinkfile instead of shrinkDB.. moreover make sure that you have no open transactions.. or if you are replicating your distributor is working.. before you try this.. even a lot of views ,being constantly used can cause the shrink to fail..
wish you luck..|||Originally posted by natas
On ower server (ms sql 2000) we have 5 databases who have to much unused space allocated. I all ready tried with the following script to shrink the database and release the allocated unused space to the Operating System. But it doesn't work. :confused: What I'm I doing wrong? :mad:
backup log [public] with no_log
DBCC shrinkdatabase ( [public],0,truncateonly)
dump transaction [public] with no_log
GO
Please, Help Me|||check with ur tempdb size if it is comparativly larger in size right click select shrinkfile both (temp log and tempdata ) select compress pages and then truncate free space from the file.
have u observed with any temporary cursors tables etc u have created for manipulation and forgot to close it.
have u selected autoshrink option .
if possible observe with the table's if index is corupted or fragmented to check this u can use dbcc showcontig option and observe scan density%.
if it is not nearing 100% u can run dbcc indexfrag for de-fragmenting the table this is related with tr log file.
reply me the result.|||<quote>
by vishy
I do not know whether your log file or data file is the problem. usually if the data file is larger than what you require ..
a checkdb followed by shrinkdatabase should take care of it..
if your log file is the problem then try shrinkfile instead of shrinkDB.. moreover make sure that you have no open transactions.. or if you are replicating your distributor is working.. before you try this.. even a lot of views ,being constantly used can cause the shrink to fail..
wish you luck..
</quote>
The problem is the data file i wil try out you're solution. Thnks.
I will reply soon.
Help setting up SQL2000
database server(SQL2000). I am wondering if I can use XP Home (which
we already have)for the clients and setting them all (including the
server -WS2003-) as workgroup? Or do I need a domain to setup the
connection to the database server? In that case we will have to
upgrade to Pro.
ThanksHi
I would go for the domain as you are at a level where it could well help for
administrative and other tasks. It will also be more secure. This is also
better as you already have a server! Even if you didn't go this route you
can access the server (at worse case by IP address, assuming the firewalls
are not blocking the ports!!!) and SQL authentication.
You will have to check the licencing to make sure that you have the right
CALs.
John
"lankids" <lankids@.brandalls.net> wrote in message
news:191285ee.0405280538.1b29cd43@.posting.google.c om...
> I am assigned to setup a small (less than 15 PC) network, accessing a
> database server(SQL2000). I am wondering if I can use XP Home (which
> we already have)for the clients and setting them all (including the
> server -WS2003-) as workgroup? Or do I need a domain to setup the
> connection to the database server? In that case we will have to
> upgrade to Pro.
> Thanks
Friday, February 24, 2012
Help setting up replication on remote IIS
Hello,
I am trying to setup merge replication for a sqlmobile database. I was able to set it up on a test environment which the sql instance and the iis were on the same box. I am trying now to go live. Our sql instance is on another box than the iis. I am now getting a 404 error when trying to test in the url https://www.domain.com/sqlmobile/sqlcesa30.dll?diag Is there a walk through for iis running on a different box, or does someone know of a solution?
HTTP Error 404 - File or directory not found.
Internet Information Services (IIS)
questions:
-what do you understand under a "box"?
-can you open the https://www.domain.com/sqlmobile/sqlcesa30.dll?diag site on the server where you are running the IIS? with the ipAdress of the server instead of the www.domain.com
-if so, can you access it from another computer in the network?
you can't synchronize until you can find this dialog from your mobile browser.
-have you updatet the Client Agent (sqlcesa30.dll) with the WebSynchronisation Wizard accordning to the new configuration?
- as you probably know, you are connecting with the anonymous user IUSR_servername of the SQL Server from the mobile device to the webserver, so on the IIS-Server you have to know this user an give him the needed accessrights
It seems to me that there is a problem with the configuration or the access rights
Greets Florian
|||
there are only two big "gotchas" with setting up replication with a separate IIS and SQL Server machine.
1. the account you plan to use that will provide credentials between the ISAPI dll (sqcesa30.dll) and the distributor must be known to both machines. If you were using the IIS Anonymous user's credentials (IUSR_{your machine name}), this will no longer work, because the distributor has no knowledge of this account when running on a separate machine. if both machines are on a domain, instead of IUSR_, use a domain account that it known to both IIS and SQL Server machines and grant it permissions on the IIS Virtual Directory, the publication, and the published articles themselves.
2. you must install the SQL Mobile server tools on both the IIS and SQL Server machine. use the SQL Server 2005 setup disc on the IIS machine, do a custom install, and select only the server tools for SQL Mobile.
Darren
Help setting up Peer-to-peer replication for approximately 500 db'
approximately 500 databases.
Obviously the Wizard will do it, but it would be extremely time consuming.
And, after setting up the publication you would still have to setup the
Peer-to-Peer topology.
Is there a simple way script the entire process?
peer-to-peer is only really scalable to 10 or so nodes.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Jarek Gal" <Jarek Gal@.discussions.microsoft.com> wrote in message
news:916ACC30-728E-4AA6-9D7D-0CDA7DD50407@.microsoft.com...
> We are looking for a script that will setup Peer-to-peer replication for
> approximately 500 databases.
> Obviously the Wizard will do it, but it would be extremely time consuming.
> And, after setting up the publication you would still have to setup the
> Peer-to-Peer topology.
> Is there a simple way script the entire process?
|||We have 2 SQL servers but need to do that 500 times. So the 10 nodes is not
an issue.
"Hilary Cotter" wrote:
> peer-to-peer is only really scalable to 10 or so nodes.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Jarek Gal" <Jarek Gal@.discussions.microsoft.com> wrote in message
> news:916ACC30-728E-4AA6-9D7D-0CDA7DD50407@.microsoft.com...
>
>
|||Once you've set it up for one node, scripting it out and amending the
scripts for each subsequent node shouldn't be too difficult:
http://www.replicationanswers.com/Script3.asp. You'll still need to get the
backup files restored on each node before commencing though.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
Help setting up Net Send operator
Failed to Net Send to the address "xxxxxxx".
I've tried multiple addresses, including my network sign-in name, computer
name.
Please help, thank you in advance for your time!
Leon ShargorodskyIs the messenger service installed and running on the machine you are trying
to use net send?
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message news:3AC999C9-A96E-4D79-AAD1-775D7B59FF92@.microsoft.com...
> I get this error every time I try to test Net Send operator:
> Failed to Net Send to the address "xxxxxxx".
> I've tried multiple addresses, including my network sign-in name, computer
> name.
> Please help, thank you in advance for your time!
> Leon Shargorodsky|||I'm able to use Net Send after enabling and starting Messenger service!
Thanks a lot for your help, Simon!
"Simon Worth" wrote:
> Is the messenger service installed and running on the machine you are trying
> to use net send?
> "Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
> message news:3AC999C9-A96E-4D79-AAD1-775D7B59FF92@.microsoft.com...
> > I get this error every time I try to test Net Send operator:
> >
> > Failed to Net Send to the address "xxxxxxx".
> >
> > I've tried multiple addresses, including my network sign-in name, computer
> > name.
> >
> > Please help, thank you in advance for your time!
> >
> > Leon Shargorodsky
>
>
Help setting up Net Send operator
Failed to Net Send to the address "xxxxxxx".
I've tried multiple addresses, including my network sign-in name, computer
name.
Please help, thank you in advance for your time!
Leon Shargorodsky
Is the messenger service installed and running on the machine you are trying
to use net send?
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message news:3AC999C9-A96E-4D79-AAD1-775D7B59FF92@.microsoft.com...
> I get this error every time I try to test Net Send operator:
> Failed to Net Send to the address "xxxxxxx".
> I've tried multiple addresses, including my network sign-in name, computer
> name.
> Please help, thank you in advance for your time!
> Leon Shargorodsky
|||I'm able to use Net Send after enabling and starting Messenger service!
Thanks a lot for your help, Simon!
"Simon Worth" wrote:
> Is the messenger service installed and running on the machine you are trying
> to use net send?
> "Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
> message news:3AC999C9-A96E-4D79-AAD1-775D7B59FF92@.microsoft.com...
>
>