|
More site info...
Other SQL Server Topics | Forum profile
|
|
Forum profile page for Other SQL Server Topics on http://www.sqlmonster.com.
This report page is the aggregated overview from a single forum: Other SQL Server Topics, located on the Message Board at http://www.sqlmonster.com.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "Other SQL Server Topics" on the Message Board at http://www.sqlmonster.com is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on Other SQL Server Topics:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
34
|
113
|
292
|
|
Post:
|
64
|
220
|
618
|
|
|
Other SQL Server Topics Posting activity graph:
|
Top authors during last week:
user's latest post:
sql server tutorial
Published (2009-11-27 22:24:00)
And it comes with .Net Framework bundled, and will install if needed. Signature Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
user's latest post:
sql server tutorial
Published (2009-11-26 23:39:00)
I was going to search after reading all the links i've been finding trying to get sqlexpress working (have spent about the last 4 hours (on my slow dialup connection) following links trying to create a simple database sample). 40 is not a problem but if i can't even get an express version working i probably have no hope of getting a pro version up and if the sql server requires visual studio pro version to operate (as the samples...
user's latest post:
sql server as file server os?
Published (2009-11-25 06:57:00)
mp Very shortly SQL Server is a relational database management system (RDBMS) from Microsoft that's designed for the enterprise environment. SQL Server runs on T-SQL (Transact -SQL), Google for the subject and you will find the answer > total newbie question re: servers, > i have some programming experience but none in general IT or servers [quoted text clipped - 17 lines] > thanks > mark
user's latest post:
run scripts at regular intervals
Published (2009-11-22 19:56:00)
Thanks that, I have looked for info on creating a stored procedure to run these scripts but all I found are talking of passing variables, I simply need it to run script1.sql script2.sql script3.sql etc Can you advise how I would write that script? I have 14 in total. I then need the stored procedure to run at 05:00 each day, is it possible to include a method to check the server time to activate the script to...
user's latest post:
Column naming standard –...
Published (2009-11-25 01:01:00)
A>> If the naming template were attribute_role_property .. << that would split the base data element name and mess up the data dictionary. Roles occur only when a data element appears in two roles in one table so they are local
user's latest post:
sql server tutorial
Published (2009-11-26 23:28:00)
I think you should have searched for it, then you would KNOW what $ = low price. http://www.amazon.com/dp/B001B8EZR4/?tag=mh0b-20&hvadid=53017225&ref=pd_sl_15txs 9nop8_e&msclkid=8f21852d94d798499b5d2a82e0b9ce9c&mscbg=0 $40.91, free shipping. That low enough for you? :) Signature Kevin G. Boles Indicium Resources, Inc. SQL Server MVP kgboles a earthlink dt net >I can search for that but...
user's latest post:
self join returns unwanted rows
Published (2009-11-24 14:43:00)
The following will work, but it returns an extra row because ids 34191785 and 34191786 also satisfy your requirements: SELECT t1.EMP_ID , t1.DRV_ID , t1.SHIFT_ID , t1.ORDER_ID AS ORDid1 , t1.ORDER_TIME AS OTime1 , t1.SHIP_TIME AS STime1 , ...
user's latest post:
sql server as file server os?
Published (2009-11-25 16:17:00)
Possibly the system stores documents as XML in a SQL Server database.That is, XML text stored as a value in a table. Each record can be quite large and holds the entire text of the document. Possibly the system uses the SQL Server Filestream feature to store the documents in a file system and controls access through SQL Server. SQL Server is installed onto a Windows XP, Windows Vista, Windows 7, Windows Server 2003, or Windows Server 2008...
|
|
|
|
Latest active threads on Other SQL Server Topics::
Started 1 week, 2 days ago (2009-11-20 22:00:00)
by Erland Sommarskog
All lowercase, using underscore only exceptionally. (When no underscore would make the name to confusing.) Look at it this way: if you use different conventions for columns and class members, you can easily tell them apart. Signature Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207 ....
Started 5 days, 9 hours ago (2009-11-25 06:57:00)
by Uri Dimant
mp Very shortly SQL Server is a relational database management system (RDBMS) from Microsoft that's designed for the enterprise environment. SQL Server runs on T-SQL (Transact -SQL), Google for the subject and you will find the answer > total newbie question re: servers, > i have some programming experience but none in general IT or servers [quoted text clipped - 17 lines] > thanks > mark
Started 1 day, 6 hours ago (2009-11-29 09:35:00)
by Erland Sommarskog
Can't you just type in the instance name? Signature Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207 .aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970 .aspx SQL 2000: http://www.microsoft.com/sql/prodinfo/previousvers ions/books.mspx
Started 1 year, 4 months ago (2008-07-23 23:23:00)
by Chris Crowe
try the following SELECT COUNT(ID) AS [Total] isnull(GroupA, 'Total Count') AS [Group Name] FROM GroupsTable GROUP BY GroupA WITH ROLLUP Chris > When doing an aggregate, such as: > [quoted text clipped - 10 lines] > TIA, > Jim
Started 4 days ago (2009-11-26 15:14:00)
by TheSQLGuru
Consider purchasing the Developer's edition of SQL Server. FULL functionality and a VERY low price. Signature Kevin G. Boles Indicium Resources, Inc. SQL Server MVP kgboles a earthlink dt net >I dled the c# samples from msdn > Tried to run the create database sample (connects to sql server) [quoted text clipped - 37 lines] > shutdown. Trace ID = '1'. This is an informational ...
Started 3 days, 17 hours ago (2009-11-26 22:43:00)
by MP
sorry to hijack your thread but I also am trying to get this to run... I installed c# express and vbnet express which I'm pretty sure install sql express at the same time I think sql server is installed and running, as I can find sql server configuration manager and it shows sql server (running) but i can't find any shortcut to SQL Server Management Studio. i don't see any obviously named exe ...
Started 3 days, 17 hours ago (2009-11-26 22:28:00)
by Erland Sommarskog
Yes, it is possible to do Windows authentication in a workgroup, but it can be a battle. To start with, you must have the same login and password on both machines. There is also a Group Policy setting that needs to be set to Classic. But I have never seen the error message you quote. The group-policy setting eluded me for a long time, but I only got the message "is not associated with a ...
Started 4 days, 17 hours ago (2009-11-25 22:42:00)
by Erland Sommarskog
Generally, you can run both SQL 2000 and SQL 2005 on the same server. But what applies to SBS I don't know. I think you are better off asking in a forum devoted to SBS. Signature Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207 .aspx SQL 2005: http://msdn.microsoft.com/en-us/...
Started 5 days, 17 hours ago (2009-11-24 22:35:00)
by Erland Sommarskog
Could be. Are you the administrator for both servers? Should you see all logins? What version of SQL Server are you using? In what tool do you go this tab? Signature Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207 .aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970 ....
|
|
Hot threads for last week on Other SQL Server Topics::
Started 4 days ago (2009-11-26 15:14:00)
by TheSQLGuru
Consider purchasing the Developer's edition of SQL Server. FULL functionality and a VERY low price. Signature Kevin G. Boles Indicium Resources, Inc. SQL Server MVP kgboles a earthlink dt net >I dled the c# samples from msdn > Tried to run the create database sample (connects to sql server) [quoted text clipped - 37 lines] > shutdown. Trace ID = '1'. This is an informational ...
Started 1 week, 2 days ago (2009-11-20 22:00:00)
by Erland Sommarskog
All lowercase, using underscore only exceptionally. (When no underscore would make the name to confusing.) Look at it this way: if you use different conventions for columns and class members, you can easily tell them apart. Signature Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207 ....
Started 5 days, 9 hours ago (2009-11-25 06:57:00)
by Uri Dimant
mp Very shortly SQL Server is a relational database management system (RDBMS) from Microsoft that's designed for the enterprise environment. SQL Server runs on T-SQL (Transact -SQL), Google for the subject and you will find the answer > total newbie question re: servers, > i have some programming experience but none in general IT or servers [quoted text clipped - 17 lines] > thanks > mark
Started 1 week ago (2009-11-22 16:09:00)
by Erland Sommarskog
The easiest way would probably be to package the scripts as stored procedures that calls each other. Signature Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207 .aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970 .aspx SQL 2000: http://www.microsoft.com/sql/prodinfo/...
Started 5 days, 17 hours ago (2009-11-24 22:35:00)
by Erland Sommarskog
Could be. Are you the administrator for both servers? Should you see all logins? What version of SQL Server are you using? In what tool do you go this tab? Signature Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207 .aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970 ....
Started 3 days, 17 hours ago (2009-11-26 22:43:00)
by MP
sorry to hijack your thread but I also am trying to get this to run... I installed c# express and vbnet express which I'm pretty sure install sql express at the same time I think sql server is installed and running, as I can find sql server configuration manager and it shows sql server (running) but i can't find any shortcut to SQL Server Management Studio. i don't see any obviously named exe ...
Started 6 days, 2 hours ago (2009-11-24 13:11:00)
by --CELKO--
Not really; the DDL and specs are a bit vague. 1) Is the key to the table (emp_id, drv_id, order_id) or something else? 2) Does a NULL order_time mean that it has not been ordered yet? 3) Does a NULL ship_time mean that it has not been shipped yet? I see you allow something to shipped before it is ordered. 4) What does a NULL shift_id mean? How do we compare it with another known or NULL...
Started 5 days, 17 hours ago (2009-11-24 22:24:00)
by Erland Sommarskog
I would not call that a connectivity error, but a plain error at run-time. Since there is absolutely no context, I cannot really help you. The error message is what it says. There is an attempt to convert a non-numeric string to int. Signature Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/...
Started 1 week ago (2009-11-23 14:25:00)
by Plamen Ratchev
When you select SQL Server Services, just double click on the instance service (or right click and select Properties) and there you can change the service account credentials. Signature Plamen Ratchev http://www.SQLStudio.com
Started 5 days ago (2009-11-25 15:00:00)
by Andrew J. Kelly
As long as you have the other server registered in SSMS you can connect to it and do what you like. Signature Andrew J. Kelly SQL MVP Solid Quality Mentors > Hi, > [quoted text clipped - 3 lines] > server, and create maintenance plans? If yes, how? Or do I have to use the > Maintenance Plan Wizard on each server?
|
|
Size: 779 bytes
