Great MS SQL Sites?
Mar 17, 2004Does anyone know of any links to some great MS SQL sites I can check out to learn from?
Thanks for your thoughts.
Sincerely,
Tim
ADVERTISEMENT
SQL Hell....little Help Would Be Great!
Jan 4, 2005hi, im currently on sql hell right now. im having a hard time learning this sql thingie....
...the thing is this: im currently using the book ASP.NET Unleashed and most of the examples there are on SQL. what i was trying to do before was convert everything to OleDb to fit the ms access which i have right now.
unfortunately, some of the codes seem not to work properly. maybe its because of im using OleDb...
so what i did was i downloaded the MSDE sp3 package and installed it on my PC. now that i have an sql server for my WebMatrix, i just dont know what to do next? i mean, where do i put the sql sample databases like northwind and pubs???
im really confused about this sql thing. i really hate it.
help!!!
Between Or Great Than Operator
Feb 10, 2014 Im not getting data when I execute the below 0 Rows:
select mydate from [dbo].mytable
where convert(varchar, mydate,101) between '11/18/2013' and '02/08/2014'
However the below gives results...
select mydate from [dbo].mytable
where convert(varchar, mydate,101) between '01/01/2013' and '02/08/2014'
Morning - Any Help Would Be Great
Jan 30, 2007I have two servers both with different collation. Server A being SQL_Latin1_General_CP1_CI_AS and the live server and Server B being Latin1_General_CI_AS and a dev server. Now i have a load of data on the dev which i'm query to see if its on the live server.
select * from ServerA.Table1 where Col1 in
(select Col1 from ServerB.Table1)
I get this Error message.
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
TARA Is Great
Nov 28, 2007I am SQL server DBA for 4 years. ALways i am getting help from TARA and other SQL gurus. Salute to all
View 1 Replies View RelatedGreat Plains V8
Aug 20, 2007Hope someone can solve my problem
I have a working version of the above installed on a win 2000 machine with SQL ver (MSDE2000A.exe)
I purchase a laptop with vista home premium installed on it
MSDE2000A.exe would not install hence I installed SQL Server Express I managed to install the server and connect but when trying to login through Great Plains it says that I need SQL version 7. I have done a little research and found that SQL 7 is not supported by Vista.
Which way do I go now ?????
Do I install a copy of xp, update Great Plains or wait for an updated version of SQL Server Express SP ???
Please can anyone help !!!
and please dont get too technical Im not an expert
Many Thanks
Mr Magoo
One Db For Multiple Sites
Feb 23, 2008hi all. my question is simple: can i have 1 sql data base for multiple sites?
View 3 Replies View RelatedSql Server Dba Sites
Mar 3, 2002Can any one pls gime list of sql server websites similar to SWYNK.
also pls gime some good sql server links for diccussion groups.
Thanks in Advance
Kinds regards
sk
SQL Scripts Sites
May 5, 2006Hi,
Can any one help me in pointing to some good web sites where I can get SQL scripts for most common useful functions.
Thanks
-Sudhakar
CD, Books, Sites
May 24, 2006naresh writes "I would like to learn sql server 2000 and I do not have any programming experienc at all so how do i learn this programme. Do you have any suggestion or any basic books or materials you guys can refer to me
Thank you"
Help With Great Plains Query
May 31, 2006Greetings,
We currently use GP 8.00 with the SQL Server 8.0.
We are trying to develop a view based on manfacturing orders - when a finished good is placed on hold and then calculating the componet parts that are on hold.
The calculation runs fine, we multiply end quanity x componet quanity found on the BOM. But we are not getting the correct componet item numbers to display.
Here is the syntax we are using:
SELECT DISTINCT
TOP 100 dbo.BM010115.QUANTITY_I, dbo.WO010032.ENDQTY_I, dbo.WO010032.ENDQTY_I * dbo.BM010115.QUANTITY_I AS QTY_REQHOLDMO,
dbo.BM010115.CPN_I, dbo.WO010032.MANUFACTUREORDER_I, dbo.WO010032.ITEMNMBR, dbo.WO010032.MANUFACTUREORDERST_I
FROM dbo.TEC_MOSumm RIGHT OUTER JOIN
dbo.WO010032 ON dbo.TEC_MOSumm.ITEMNMBR = dbo.WO010032.ITEMNMBR RIGHT OUTER JOIN
dbo.BM010115 ON dbo.WO010032.BOMCAT_I = dbo.BM010115.BOMCAT_I
WHERE (dbo.WO010032.MANUFACTUREORDERST_I = 4)
We have tried several different types of joins but still no luck. The upshot is we need to know that when a finished good is placed on hold, - how many of its componet parts are placed on hold.
Any assistance you can provide will be appreciated.
Sam
Installing Great Plains V8.0
Feb 27, 2008Here is my problem.
I am setting up a new server with Great Plains v8.0 (I have migrated all the databases from the other server, which has a working version of Great Plains v8.0 at the present moment). We are planning on getting rid of that server as it causing a lot of problems at the moment. I start the install of Great Plains v8.0 on the new server, install the components. After Great Plains v8.0 installs I go into Great Plains Utilities, and get the following message (I have installed SQL Server 2005 on the new server, and SQL Server 2000 is being used on the old server).
After I run Great Plains Utilities, I get the following error message -
"The stored procedure verifyServerVersion() of form duSQLinstall: 111
Pass Through SQL returned the following results: DBMS: 0, Great Plains: 0."
and when I click OK, it gives me another notification message -
"Your current SQL SERVER is not a support version
Req: Microsoft SQL Server 7.0
Act: Microsoft Server 2005
You need to upgrade to SQL Server 7.0 before continuing".
Why am I get that error message when I have SQL Server 2005 installed?
Can someone point me in the right direction.
Thanks
Got Some Great Replication Links????
Nov 24, 2006can anybody give me some nice links with a detailed explaination of the various replication errors and solution
thanks in advance
Jacx
Great New Learning Resource
Mar 30, 2007 We've been working hard with our teams here to get better/more/good information out to our users. We€™ve created a new a customized Windows Live search, that limits results to Books Online. Check this out, and make sure you let your contacts know to visit it and provide feedback:
http://search.live.com/macros/sql_server_user_education/booksonline
We want to generate as much traffic as possible here so that we can see if this is useful to our users. We€™d love to hear back from everyone we can!
Help !! Lost Clients Sites
Sep 24, 2005“HELP !! We’ve lost about 25 client’s websites. The databases were backed up along with all the actual files contained within each CSK….in addition, all the original databases are intact & can be reattached to the new SQL server…..the problem that exists where the original CSK files do not recognize the original database once it is reattached to the new SQL server. Any help would be most appreciated.
This is the error……
Login failed for user 'DARRYL1ASPNET'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'DARRYL1ASPNET'.Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException: Login failed for user 'DARRYL1ASPNET'.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +472
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
ASPNET.StarterKit.Communities.CommunityUtility.GetAllCommunitiesFromDB() +93
ASPNET.StarterKit.Communities.CommunityUtility.GetAllCommunities() +58
ASPNET.StarterKit.Communities.CommunityUtility.GetCommunityInfo() +327
ASPNET.StarterKit.Communities.CommunitiesModule.Application_BeginRequest(Object source, EventArgs e) +221
System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() +60
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +87
SQLExpress - Hosting Web Sites
Feb 15, 2006If I were going to look into investing into a virtual dedicated server and wanted to save LOTS of $$$ by offerring SQLExpress (FREE) vs. SQL Server Enterprise $25,000 sticker price.
The Web sites that I build are for small businesses.
Is there an issue in using SQLExpress on the Internet? Considering it is the Web application account ID accessing the database so that is one user hitting the DB.
I am unclear on how I need to evaluate multiple calls to the system depending on how many users are on the Web site opening the connection performing SQL Commands then closing the connections all with the same user creditials.
<moojjoo />
Favorite SQL Forum Sites
Jan 25, 2008What are your favorite Forum sites?
SQLTeam.com
SQLSERVERCENTRAL.com
TekTips.com
MSDNSQL Forum
forums.sqlmag.com
I hate to ask for information such as this but with the low response to my questions I was wondering anyone knows of a better site for SQL Server database mail issues?
Thanks,
Thom
SQL Replication For Multiple Sites
Oct 5, 2007I am trrying to figure out what the best replication would be to use and or setup...
Her eis the current goal and structure..
We are just moving over to a new custom POS system that will be using SQL databases....We have have three locations and we want each location to be independent in case of network connectively failures to our primary location.
Basically, all three locations will be running SQL server 2005 and the POS app...
We want replication to occur overnight, so that each location will have the other locations transactions from the previous days, etc...
Essencially I want all three locations to "syncronize" their data every night....basically two-way replicaiton between all three sites...
Master Site will have say databaseA that the local POS system will use
Sencond Site will have say databaseA that the local POS system will use as well
Third Site will have say databaseA that the local POS system will use well...
Any thoughts or Ideas will be helpful
Thx
Martin
Incorrect Syntax Near '@Sites'.
Oct 31, 2006I have the following code but it keeps erroring on the last line and I'm unsure as to why it is doing it???
Here is the error message
Msg 102, Level 15, State 1, Line 42
Incorrect syntax near '@Sites'.
declare @Sites varchar(50)
declare @Kit_No char(20)
declare @Location char(2)
set @Location = 'Ho'
set @Kit_No = 'mo1k'
if (SELECT sitetype from gss.dbo.kup_regions where region_code = @Location) = 10
begin
set @Sites = '''Pe'',''Hg'',''Vo'',''' + @Location + ''''
end
select
KR.Region_Code,
KR.Region_Name,
Z.Qty,
Z.Kit_Description,
Z.BookedOutToDate as Usage,
Z.Local_Cost,
(select overstock from gss.dbo.vGss_overstock where region_code = Z.region_code and kit_no = 'm01k' )as Rolling_Avg,
C.Symbol,
Z.FOB,
(SELECT
Price
FROM
gss.dbo.FedEx_Rates Fed
WHERE
SourceRegion = (SELECT Region_Code FROM gss.dbo.KUP_Regions WHERE Region_Name = 'penistone')
AND Weight = (SELECT MAX (Weight) FROM gss.dbo.FedEx_Rates WHERE Weight < (SELECT Packed_Unit_Weight From gss.dbo.KUP_Kits WHERE Kit_Code = (select Kit_Code from gss.dbo.GSS_Kits where Kit_No = 'm01k' ))+0.5)
AND Fed.DestRegion=KR.Region_Code) as Fedex_Price
from
(gss.dbo.kup_regions KR with (nolock)
left outer join
(select KRD.Qty,KRD.BookedOutToDate,KRD.Local_Cost,KRD.FOB,GK.Kit_Description,KRD.Region_code,KRD.Archive_Date
from gss.dbo.kup_region_data KRD with (nolock) inner join gss.dbo.gss_kits GK
on KRD.kit_code = GK.kit_code where GK.kit_no =@Kit_No and KRD.archive_date is not null )Z
on KR.region_code = Z.region_code)
inner join gss.dbo.Currency C with (nolock) on C.Country_Code = KR.Country_Code
where KR.ExpectExtract = 1 and KR.Designation = 'p' and KR.Region_code in @Sites
Many thanks for any help
Great Circle Distance Calculation
Oct 15, 2007Great Circle distance calculation
Is there any stored procedure or application that implements Great Circle distance calculation
Anyone Know Of A Great Book For Learning Transact SQL?
Feb 26, 2001Hello, I have just started working with Microsoft SQL Server 7.0 and was wondering if anyone could recommend a great book for learning T-SQL. I was looking for something that would provide several examples on triggers and stored procedures.
View 5 Replies View RelatedDoes Anyone Know Of A Great Access Help Site Similar To This.
May 17, 2000Does any one have information on any good Access Sites that are similar to this one, which could be helpful in completing some task. Thanks.
View 1 Replies View RelatedReplication Of Great Plains Data
Jan 13, 2006Hi All,
We have the requirement to replicate financial data to Aus from the UK, however I dont know if Replication is the best solution around?
Reason why I ask this, is that to create the publication, there are in excess of 10000 articles, which takes forever and a day to create, then when setting up the push subscription, this takes equally as long.
DB's physically range between 100MB and 2GB. Link to Aus is 2MB E1.
The accounts server isnt the most powerful of beasts (HP DL380, 1x1.4Ghx CPU) and with 4 DB's to setup and replicate, it's going to take some time.
With this in mind, I would also be looking to script out the publication should there be any failures and put it into SourceSafe, however this would also take a vast amount of time.
I've thought about using Log Shipping, however I dont know if there are any better ways
?
Thoughts appreciated.
Steve
Great Plains Database Replication
Feb 1, 2007Our company has a database server (Windows Server 2003 x64 EE w/ SQL Server 2005 x64 EE) that has Great Plains installed. We have a database for one of our companies that I would like to begin replicating to another server. The reason behind this is that we want to run the GP/CRM Connector which requires 32-bit ODBC connections.
Anyways, what I need to do is enable replication to our 32-bit server. We have been successful in making this happen from 64-bit to 32-bit with a much smaller database. When I go to enable peer-to-peer in the properties of the publication (which I set up using all of the default settings), SQL Management Studio will hang and run for days while appearing to be working. However, when we end up killing Management Studio days later (we let it run for a week once) the peer-to-peer option does not seem to have been set properly.
Any ideas?
Great Circle Distance Calculation
Oct 15, 2007
Great Circle distance calculation
Is there any stored procedure or application that implements Great Circle distance calculation
SQL Restart Kills SQL-based Sites On IIS
Apr 12, 2007I have a SQL 2005 server on a separate machine from my IIS machine, and anytime the SQL server restarts (like for last night's automatic updates) the connection pooling seems to break. Among the apps on this IIS box is Community Server 2.1, along with some other custom-built apps. The only way to resolve it is to stop and restart the IIS services.
Previously all SQL-dependent apps on that IIS box broke when SQL was reset, but I seemed to have addressed it, at least on my custom-built apps, by forcing a TCP connection in the connection strings (instead of the default named pipes method). I did change the Community Server connection strings as well, but for some reason that didn't seem to work.
Has anyone else experienced similar problems with interruptions in SQL connectivity bringing down apps that connect to that SQL server? I hate to turn off automatic updates just to make sure my ASP.NET apps are available.
I apologize if this isn't clearly an ASP.NET question, but hopefully someone can help me out.
Thanks,Josh
How Do I: Create Data-Driven Web Sites?
Jun 13, 2007I'm very new at this and found this video very helpful. I downloaded Visual Web Developer 2005 Express Edition and following the direction except for changing a few column names. When I get to the point of viewing in browser I get the drop down box but nothing in it and the table doesn't show up either. I copied all the data to my website and tried to view it there but got some error that I don't understand. Can someone please help. The website I uploaded the files to is ocbeachrentals.net/default.aspx. Thanks.
View 1 Replies View RelatedMaintaining SQL Server At Customer Sites
Apr 18, 2003I am wondering how people maintain their SQL Servers which run at several customers sites and disk space is getting smaller and smaller? I want to say that we have tables in SQL dbs which hold a lot of date consisting of statistics, errors, logs etc.
They grow and grow and existing data is not needed anymore as soon as the data get older than let's say for one year. How do you overcome the problem reducing the tables but not charging the system too much as the major application also runs on the same server?
Thanks for any input
mipo
VB5 And RDO Connections Any Good Sites Out There To Provide Help?
Mar 25, 1999I am new to RDO and SQL I have been using DAO and know that the syntax is similar but the connections to the database is different. Does anyone know of a good site that explains this?
Thanks in advance.
LoPingKill
loping@inlink.com
Distributing Data To Client Sites...
Jul 15, 2004We have a large SQL database, and we need to send out updated records to many clients' sites which are not connected.
We currently have a tool which looks at the audit log of changes we made, creates a file based on this, which is then emailed to our clients. They then run a tool we created to remerge the changes.
I suspect SQL server replication might make all this possible. Am I right? Can SQL server produce a file automatically which can be applied to a remote database to update the tables as appropriate? From looking at some replication stuff it looks to me like you have to have the servers on the same network.
SQL 2012 :: Replication Between Different Sites And Domains
Jun 10, 2015Can we setup a replication ( publisher and subscriber are Sql server) between two different domains, basically different company databases.
View 1 Replies View RelatedGreat Tool To Compare Data From Two Different Queries
Feb 6, 2007http://www.download.com/Firefly-Dat...j=uo&tag=button
View 1 Replies View RelatedRestarted SQL Server 2005, And It's Working Great Now, But WHY??
Aug 3, 2007My small business has about 21GIGs of data in our database. This entire week we've been running absolutely slow. Posting transactions have been taking up to 30+ seconds when they're normally instant.
We ran the profiler and found that certain stored procedures were taking an absolutely long time to run. We checked for fragmentation, indexing, etc. Keep in mind our hardware was constantly pegged at 80%+ all the time. We have about 60 users connected to our server at any given time.
After much effort to no avail, we finally resorted to just restarting the software. Some have even suggested powering down and rebooting our hardware, but I halted that. We stopped and restarted the server via the management studio and now everything is just peachy. We're funning super fast and smooth.
My concern is that we're just bandaid-ing the problem and not resolving it; so eventually we're going to be faced with this problem again. Even though restarting the server is quite easy and not too effective on our downtime, personally, I'd like to know what the real issue is. Isn't sql server 2005 a self-tuning software to begin with?
Has anyone experienced this and share some insights on what they did and didn't do to resolve this quirk?