About Experts Sitemap - Group 37 - Page 17 2015-04-14

MS SQL Server: Error trapping/ or error translation, violation error, access programming
violation error, access programming, application user: Hi , Each error message is having a number.Whenever a error occurs SQL Server will throw a error and a number associated with that error.As I told you earlier I don t know much about programming in access as far as I know what you can do is catch the error...

MS SQL Server: Error trapping/ or error translation, sql server 2005, error handlers
sql server 2005, error handlers, insert into table: not to my knowledge. what you can do is use a stored procedure and trap for errors and raise your own error something like: BEGIN TRAN INSERT INTO TABLE IF @@ERROR 0 GOTO err_handler COMMIT TRAN RETURN 0 ERR_HANDLER ROLLBACK TRAN RAISEERROR(...

MS SQL Server: Excel to SQL Database, excel spread sheet, sysobjects
excel spread sheet, sysobjects, contact number: Dear Ian, May you should try seleting name from sysobjects where xtype= u and thus you will get a list of all tables. They try making a while loop and put this select in the condition with a counter and in the loop write the code to select from the current...

MS SQL Server: Exchange data in DB with XML, exchange data, conjuction
exchange data, conjuction, dataset: There is a lot of information in the Books Online about how to use XML data in conjuction with SQL Server. That s probably the best way to start and then if you have specific questions I can try to help. There are a couple of ways to get data out of the...

MS SQL Server: Export SQL Server to Access, export sql server, destination tables
export sql server, destination tables, export wizard: Hi Alan, The problem is probably when you try to import whole table. If this is the case then try to first generate create script of the table and then import the data only. In another case when we try to import data theres on option on the page where...

MS SQL Server: error 1069, logon failure, mssqlserver service
logon failure, mssqlserver service, sql 7: It s a fairly straightforward error. Go into the Services MMC console and check which account the service is using to login. If it s a domain account, make sure the password hasn t changed. That s typically the issue. Or it can t reach the domain controller...

MS SQL Server: error, optional feature, datatypes
optional feature, datatypes, runtime error: Where is this error being thrown? From ADO? Often this is a parameter issue, but without seeing your code I have no idea. That particular error can be thrown for a lot of reasons. Are you by any chance migrating from Access? If so, make sure you are using...

MS SQL Server: export to access, export wizard, dts package
export wizard, dts package, sql server: you will probably either need to change the datatype of the column yourself or do a custom transform inside your DTS package. Are you using the SQL Server Import/Export Wizard? Have you tried creating the table in Access first and mapping the fields yourself?...

MS SQL Server: Faking user-defined functions in SQL Server 7, target user, functions in sql server
target user, functions in sql server, udfs: Yeah, that s a tough one. There are a couple ways to go, depending on what type of UDF it is. Either you ll have to duplicate the functionality within the query itself or build a stored procedure with an output variable that gives you the same information....

MS SQL Server: Fast retrival of Query result, execution plan, retrival
execution plan, retrival, query analyzer: I would probably have to know a lot more about your environment to be able to troubleshoot this. It s not the sort of thing I can figure out from a description. Sorry. A couple things you could look at would be the amount of RAM (should be at least 1 gig...

MS SQL Server: FK, local variable, table c
local variable, table c, pk: The only way I know of to do this is to do the whole thing inside a stored procedure. Assuming both PK columns are IDENTITY columns, you would have to first insert into A, use @@IDENTITY to get the value into a local variable, do the same for table C and...

MS SQL Server: Flat files in DTS, bulk insert, lana
bulk insert, lana: Hi Bilokonlana, IN SQL Server DTS, 1) Create a connection 2) We can select datasource as DB-IV. 3) We need to specify filename, user name and password. 4) We can use Execute SQL Task or bulk insert task. Try using the above steps. Regards...

MS SQL Server: Formatting Date and record Length, notepad format, sql server 7
notepad format, sql server 7, delimited text: Dear Richard, 1. The help can be found for date formatting by searching for cast or convert functions and you will get one table listing all the related values of date formatting. Here the date can be formatted this way: convert(char(10), columnname,...

MS SQL Server: Function and Stored Procedure, sql queries, datatype
sql queries, datatype, clarification: Dear R. J. Premnath, The function may have some select statements in it (mostly one) and stored procedure can have many many sql queries in it and the query may or may not depend upon the query executing just before it. So, when function gets an error it...

MS SQL Server: Function and Stored Procedure, followup questions, critical statements
followup questions, critical statements, david vaughn: In general, if an error occurs in a function, it will fail and cause whatever statement or object that called it to fail. In a procedure, if an error occurs the procedure continues to execute. That s why it s important to check the value of @@ERROR after...

MS SQL Server: Alter table, syntax
MS SQL Server: Alter table, syntax

MS SQL Server: Alternative to First Function in SQL Server 2005, column names
MS SQL Server: Alternative to First Function in SQL Server 2005, column names

MS SQL Server: IT advice, developer position, hr person
MS SQL Server: IT advice, developer position, hr person, uncomfortable questions

MS SQL Server: BCP utility, ignore duplicate rows
MS SQL Server: BCP utility, ignore duplicate rows

MS SQL Server: How to delete duplicate rows in the sql server 2000
MS SQL Server: How to delete duplicate rows in the sql server 2000

MS SQL Server: error 1069, local system
MS SQL Server: error 1069, local system

MS SQL Server: Fast retrival of Query result, image column
MS SQL Server: Fast retrival of Query result, image column

MS SQL Server: insert select with addtional value, product uid, detail product
MS SQL Server: insert select with addtional value, product uid, detail product, qt

MS SQL Server: MS Sql
MS SQL Server: MS Sql

MS SQL Server: I/O error (bad page ID) problem, sql 2000, sql server 2005
MS SQL Server: I/O error (bad page ID) problem, sql 2000, sql server 2005, grobbelaar

MS SQL Server: Question on EquiJoin, language point, index table
MS SQL Server: Question on EquiJoin, language point, index table, index values

MS SQL Server: Question on EquiJoin, execution plan, ssms
MS SQL Server: Question on EquiJoin, execution plan, ssms, query window

MS SQL Server: Row Number, select statement, varchar
MS SQL Server: Row Number, select statement, varchar

MS SQL Server: Run time error -2147467259, user accounts, ms access
MS SQL Server: Run time error -2147467259, user accounts, ms access

MS SQL Server: Select Query, sum total
MS SQL Server: Select Query, sum total

MS SQL Server: SQL Divide by, decimal place
MS SQL Server: SQL Divide by, decimal place

MS SQL Server: SQL Join Question, exact scenario
MS SQL Server: SQL Join Question, exact scenario

MS SQL Server: SQL Query Needed for identifying same duplicate rows.
MS SQL Server: SQL Query Needed for identifying same duplicate rows.

MS SQL Server: SQL Server Statistics: How can I access and delete them?, object id, schema
MS SQL Server: SQL Server Statistics: How can I access and delete them?, object id, schema, sys

MS SQL Server: SQL Server -vs- Lotus, domino server, page btw
MS SQL Server: SQL Server -vs- Lotus, domino server, page btw, lotus notes

MS SQL Server: SQL Server weird icon, green triangle, o clock
MS SQL Server: SQL Server weird icon, green triangle, o clock, red dot

MS SQL Server: Why is my SQL script taking ages to run?
MS SQL Server: Why is my SQL script taking ages to run?

MS SQL Server: SqlDumpExceptionHandler, affinity, processors
MS SQL Server: SqlDumpExceptionHandler, affinity, processors, mask

MS SQL Server: How do you turn off Must_Change?, check expiration, undocumented feature
MS SQL Server: How do you turn off Must_Change?, check expiration, undocumented feature, souza

MS SQL Server: fulltextsearch, microsoft search engine, sql server database
microsoft search engine, sql server database, exsample: Here is the steps: Go to programs, Then Program Group Items of SQL SERVER. Then Query Analyser. Once Query Anayser opens, select the server name, put user name and password. Once you are available with Blank Window, Copy paste your query...

MS SQL Server: Genera SQL Stuff Related Question, sql database developer, sql database programming
sql database developer, sql database programming, database design principles: Do you have an SQL Server development experience? I m not sure how you could be effective at this job if you have no development experience. I m assuming this is Microsoft SQL Server. Which version? You will at least be expected to know a lot about writing...

MS SQL Server: General Question, database size, access database
database size, access database, conversions: It s really hard to say, depends on the size of the Access database and the types of columns your tables have. You also need to take into account SQL Server will create a log file for your database that by default is 1 MB. Just as a guess, I would probably...

MS SQL Server: Good SQL statement, execution plan, optimization tips
execution plan, optimization tips, swartzentruber: Hi, There are all kinds of things you can talk about as far as a good sql statement. Your best bet would probably be to get a good t-sql book as it will have all kinds of optimization tips. On one level, a good SQL statement is one that gives you the...

MS SQL Server: Hello,I have data base of..., connection string, network library
connection string, network library, ip network: Hi Isabella, You can directly use the connection string and provide the machine name with IP in connection string and it will work. Alternativerly In SQL SERVER PROGRAM GROUP there is utility: SQL Server Client Network Utility, Click on Alias TAB and...

MS SQL Server: Index in sql server, salary range, thanks in advance
salary range, thanks in advance, clarification: Dear R.J.Premnath, The index on the table on any query is selected by the sql server automatically unless specified by the use of with index keyword. But, what sql server will look in to the index of empid is that, how to retrive those names for filtered...

MS SQL Server: Index in sql server, index scan, followup questions
index scan, followup questions, data distribution: I think what you re asking is Will the index be used to optimize the query? . And the answer is no. SQL will do a clustered index scan. If you create a non-clustered index on Salary, SQL will probably use that index (using an Index Seek to find a range...

MS SQL Server: Indexes, database indexes, nonclustered index
database indexes, nonclustered index, dateofbirth: No apology necessary, even if you are the enemy ( I m actually a .NET developer )... :-) 1. Correct 2. I may not be using the right term ( key value ). I simply meant the column(s) that the index is on . (If you have a non-clustered index on LastName,...

MS SQL Server: Inner Join question, deserved result, dynamic sql
deserved result, dynamic sql, inner join: I cannot understand why you would think that a CURSOR is a problem with millions of records. I know some people believe that SQL cannot handle cursors as well as Oracle. However I have yet to run into any problems provided that you properly use the cursor...

MS SQL Server: Integration Provider, integration provider, dear ryan
integration provider, dear ryan, ssis: Dear Ryan, The best possible way that comes in my mind is that using a query to update the table with the unique key of table b as the criteria to select the rows other than that should work. Thanks, Jwalant Natvarlal Soneji Mob: +91 9969059127 http://jwalant.soneji.googlepages.co...

MS SQL Server: Invalid column name When Grouping, field cd, case record
field cd, case record, select statement: SQL Server does not allow GROUP BY on calculated/aliased columns, at least not with the calculated/aliased name. (In my opinion, Microsoft really dropped the ball on that one. To do what you want, you COULD repeat the actual calculation: GROUP BY room_urn,...

MS SQL Server: identity column in a table, constraint name, precision scale
constraint name, precision scale, column name: Hi Abdallah, You can use alter statement command. here is the list of complete operations which you can perform thru ALTER TABLE ALTER TABLE table { [ ALTER COLUMN column_name { new_data_type [ ( precision [ , scale ] ) ] [ COLLATE ...

MS SQL Server: identity increment, column id, truncate table
column id, truncate table, thaks: Instead of deleting all records from the table, use the TRUNCATE table command. This will reset the IDENTITY. You can also use DBCC CHECKIDENT to reset it to whatever you want. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_5lv8.asp...

MS SQL Server: image & audio, sql server 2000, web based database
sql server 2000, web based database, enterprise version: Hi Amal, 1) You can work in SQL Server in XP (Provided you have Personal Edition of SQL SERVER 2000). If you are installing Enterprise version, (it will only install Client Software). 2) You can insert Images in SQL SERVER as fields, I will suggest you...

MS SQL Server: importing excel spreadsheet tinto sql, sql server table, import wizard
sql server table, import wizard, destination table: Dear Ann, what is the exact error you are getting, mostly it can be of inserting value in identity columns as you have said, There can be two ways 1. if you want that same identity you have in excel to come in sql the when seleting the destination table...

MS SQL Server: importing large file, string manipulation functions, comma seperated
string manipulation functions, comma seperated, sql server 2000: i am not big with VB.NET but this site seems to have some code that will do the ADO connection to the database and perform the simple insert/delete/update commands. http://www.startvbdotnet.com/ado/sqlserver1.aspx that should cover the DB connection....

MS SQL Server: indexes, status query, getdate
status query, getdate, runtimes: Dear Sue, Sorry for being strange. Well, I have already answered queries from Lisa and the summary is this: It depends upon the datatype of the column on which the index has been created. Its fast for numeric and slow for uniqueidentifier from my practice...

MS SQL Server: insert audio+images in SQL Server, software artisans, audio images
software artisans, audio images, free component: Hi, I hope you have wokred in FileSystem Objects of ASP. In that you have Method for working with file. One way you can do is create a DLL project in VB and make the functionality as Browse folder and copy file. Other way is take a free component from...

MS SQL Server: insert select with addtional value, product uid, sproc
product uid, sproc, detail product: You could probably do it with a stored procedure, but I don t know a way to do it in a single insert statement. with a sproc, you could pass in the 2 values and then do an if around each insert statement to see if you had anything to work with. Regards,...

MS SQL Server: Join tables, database instances, common records
database instances, common records, server1: Dear Frans Indroyono, Yes, all tables that exists can be joined throught sql queries. But if the server is different then the other server should be in the list of linked servers in the working server. There should be atleast one column on both the table...

MS SQL Server: Join tables, mr joshi, reply thanks
mr joshi, reply thanks, customer table: Dear Frans, There is no need any kind of setting for joining tables...As it is working on your computer..so it might have some problems on other computer..It will be helpful to me understanding your problem if you can send me exact error.And one more if...

MS SQL Server: linking my database with external files, sql server 2000, table cells
sql server 2000, table cells, fileshare: There are basically 2 approaches that people take. One, come up with some sort of standard directory structure on a server or fileshare and just put the link to the file in the table. The issue here is that there is nothing keeping the database and file...

MS SQL Server: listing all stored procedures/triggers in a db, microsoft newsgroups, sql script
microsoft newsgroups, sql script, google: Hi, There is nothing built-in that I know of, but it s fairly easy to write a sql script to do it. Try the Microsoft newsgroups http://groups-beta.google.com/group/microsoft.public.sqlserver.programming and search on list stored procedures there...

MS SQL Server: Meetings so far this year?, didnt work, getdate
didnt work, getdate: You should be able to use BETWEEN, although depending on the date format that can be tricky as well. Try this first BETWEEN 1/1/2007 AND 4/25/2007 if that doesn t work, try DECLARE @beginDate datetime DECLARE @endDate datetime SET @beginDate...

MS SQL Server: MS SQL Server, ms sql server, windows 2000 advanced server
ms sql server, windows 2000 advanced server, insight tools: Hi, William I don t know of a registry setting that would do that, although that doesn t mean there isn t one. I think I might have played with that tool myself quite awhile back. I have a feeling HP ships it with a modified version of the dll(s) necessary...

MS SQL Server: MS Sql, ms sql server, syscolumns
ms sql server, syscolumns, table structure: Try using sp_help MyTable and see if that gives you something similar. I m not sure what all is included in Oracle s command. You can also query the systables and syscolumns to find out other information, but that s a bit more complicated. Regards,...

MS SQL Server: MS sql views, sql views, sql scripts
sql views, sql scripts, sql view: Jana, Thank you for your question, and I apologize for the lateness of my reply. I presume you are speaking about viewing the T-SQL that created the View, correct? If so, there are a couple of ways to do this: 1. Right click on the...

MS SQL Server: MSSQL query logging, third party tools, sql 2000
third party tools, sql 2000, query statement: Assuming you have enough permission, you can use the Profiler that comes with SQL Server to figure this out. You can trace the database using all kinds of different filters to see any sql or stored procedures that are being called and that sort of thing....

MS SQL Server: MSSQL Server 2005, microsoft ssis, sql technologies
microsoft ssis, sql technologies, microsoft sql server 2005: Dear Rajiv, 1. However I am not very much aware of the way of directly upgrading the whole database from MS Access to SQL Server 2005. There is one way that I have used. Create one database in sql server 2005 with the same name, and right click the name--...

MS SQL Server: maximum in alphanumeric, last transaction, transaction id
last transaction, transaction id, table group: Dear Hemlatha, If its fixed that the first two letters of the id are alpha then you can take the rest of the letters and assume them to be numeric. Like this: ### Select left(id, 2) as IDAlpha, cast(substring(id, 3, len(id)) as int) as IDNumeric, (cast(substring(id,...

MS SQL Server: move database, move database, right click context menu
move database, right click context menu, click context menu: Dear Kumar, Doing this thing while the server is running leaves us with only one simple way and that is using Import Data or Export data found in tasks in right click (context) menu on the database name. Feel free to follow-up. Thanks, Jwalant Natvarlal...

MS SQL Server: ms sql server agent, sql server agent, ms sql server
sql server agent, ms sql server, task scheduler: Hi Michele, SQL Server Agent is..... - SQL Server Agent is the task scheduler for SQL Server.That watches the clock and runs backup,replication publishing and other items you have set to SQL Server to do an automated schedule. - You can start and...

MS SQL Server: NULL values in MS SQL server, sql server 2000, ms sql server
sql server 2000, ms sql server, null values: SQL Server 2000 does not store Null values in a separate table. Quoting from Inside SQL Server 2000 book: SQL Server keeps a special bitmap in every row to indicate which nullable columns actually are Null. If Nulls are allowed, SQL Server must decode...

MS SQL Server: Null makes Problem, ms access 97, blank field
ms access 97, blank field, null fields: Hi, That s one problem with these upsizing or data transfer wizards. They don t give you much flexibility. There is actually a difference in SQL Server between blank and null. Null means the data is indeterminate (you just don t know what it is). Blank...

MS SQL Server: Null value comparision in SQL2005, ansi sql, sql standard
ansi sql, sql standard, null value: The solution is to SET ANSI_NULLS OFF. Note that this is not recommended because it does not adhere to the ANSI SQL standard, which states that a NULL value must fail any equality test because a NULL value is, by definition, unknown . It is NOT the same...

MS SQL Server: needing some help, sql server administrator, execution plans
sql server administrator, execution plans, knowledge gain: Dear Hamada, SQL Server Developer-Those have to work with sql server queries more, have to make new queries, make new databases, have to design databases too, they may have knowledge of how to uses sql server database in applications, and thats what I do...

MS SQL Server: nested selects, joborder, candidate id
joborder, candidate id, virtual table: That is one...um... interesting query you ve got there. I ll break this down in to 2 parts: 1) Nested selects (AKA subselects ) are not all that complicated. Essentially you re creating a virtual table. When you have the syntax: ... FROM (Select field...

MS SQL Server: I/O error (bad page ID) problem, ms sql server 2000, sql server 2000 sp3
ms sql server 2000, sql server 2000 sp3, ms sql server: Yeah it seams to be the problem with hardware. It gives error while reading/writing the database file. This I/O happens in conjunction with various system commands. Microsft has given this error symptoms and has some resolution available for the same. ...

MS SQL Server: Planing, education purpose, logical design
education purpose, logical design, database search: Dear Seyed, I think this can surely help you. Don t go after the technology or programming language used, just have a look at the methodology and logical design of database. http://www.stardeveloper.com/articles/display.html?article=2000051001&page=1 ...

MS SQL Server: PROBLEM ACCESING A MDF FILE, error message number, sqlserver 2000
error message number, sqlserver 2000, ms sqlserver: Do you have backup files as .BAK file. If yes you can restore that database. If this does not helps you, delete the existing folder for SQL Server (of course after backing up the files). and then Re-install the SQL SERVER at new location. Try with this,...

MS SQL Server: problem while restoring database backup, destination database, destination server
destination database, destination server, database backup: Hi Prasad, The problem you are facing may depend upon something like- - whether the same database already running on the destination server - Here u say destination database, but if u want to restore the database then other database should not come in to...

MS SQL Server: problem while restoring database backup, fist time, destination database
fist time, destination database, filegroup: Hi Prasad, Can u tell me exactly which method you r following for restore.I mean through database,filegroup or from device. Here is one another method which you can use for restoring. Restore database databasename [From ur devicename or filename...

MS SQL Server: A Query, desktop application, vb
desktop application, vb, headache: Dear Pradip, I think connecting vb to mysql and php to sql would be easy rather than connecting sql to mysql and vb to php. If the requirement has to connect database to databae and application to application, then i think sql has linked server that can...

MS SQL Server: Query Timeout, sql server 7, tiny tools
sql server 7, tiny tools, query plans: My first question would be, why are you pulling back 30,000+ rows at a time? There is typically no reason to pull back this much data at once to display in most apps. No user is going to be able to scan anywhere close to that much data. So I would evaluate...

MS SQL Server: Query about union and union all, premnath, mob
premnath, mob, sql server: Dear R.J.Premnath, Theres one good site to provide all the info related to optimization and myths about the sql server. http://www.mssqlcity.com/Tips/tipTSQL.htm ########### Try to use UNION ALL statement instead of UNION, whenever possible. The UNION...

MS SQL Server: Query, ascending order, dear mr
ascending order, dear mr, asc: Dear Mr. H. Mohtashami, Here for one column given below, to get the desired data you have to use DISTINCT keyword. Table1: Column1 _______ a a a b b c c a a b c To maintain Ascending order use ASC and to sort in Descending...

MS SQL Server: Question on EquiJoin, execution plan, ssms
execution plan, ssms, query window: Dear R.J.Premnath, However I am not very sure about the manual method calculation of the size, if you are using the query analyzer (sql server 2000) or ssms (sql server 2005), you can right click in the query window and select estimated execution plan, and...

MS SQL Server: Question on EquiJoin, t2 data, followup questions
t2 data, followup questions, null values: 2 issues here: 1-A view has no size per se. I am going to assume you mean the # of rows returned by the view (and, thus, the size of any table you stored those rows into) 2-An equijoin is an INNER JOIN, so you will have 5 million records. If T1 and...

MS SQL Server: Question, selective area, sql server 2000
selective area, sql server 2000, data grid: Hi, I will give answer to both the points in the order which you have asked. Ans 1.) For this I have used a different way, and I am sending you the the link of site where there is a literature for using print for Datagrid (that too a selective area for...

MS SQL Server: query working in sql but not in vb 6.0 why, ado control, oracle data
ado control, oracle data, vb 6: Dear Periyasamy, If the date 01-OCT-07 is hardcoded in the query or is supplied from any control in vb code? Also, try to get the command line result for str while running the program and putting break poing just after the query has been assigned. Then go...

MS SQL Server: RETURN VALUE, open comm, personal sales
open comm, personal sales, initial catalog: Hi, Couple of potential issues with your approach. 1. You should never use RETURN values to return data. RETURN values are only meant to return the success or failure of the sproc. As such, I think they only return integers, but I could be wrong on...

MS SQL Server: Regarding postgresql server, windows version, win32
windows version, win32: Dear Narayana, The download information can be found at: ### http://www.postgresql.org/ftp/binary/v8.2.5/win32/ ### and the download file at: ### http://wwwmaster.postgresql.org/download/mirrors-ftp?file=%2Fbinary%2Fv8.2.5%2Fwin32%2Fpostgresql-8.2.5-1.zip...

MS SQL Server: Removing SQL, scott crump, sql server setup
scott crump, sql server setup, microsoft sql server: Hi, It might have been the accounting package. I would be certain you actually aren t using it before uninstalling, but sounds like you ve done that. Keep in mind I don t know what is on your machine, so do the following at your own risk. Check if...

MS SQL Server: Replace a field, sql 7, sql query
sql 7, sql query, ms sql: Hi Gary, Your procedure to replace string is perfectly alright.I have also tried the same way and it is working ..just as update TableA set name=replace(name, . , x ) where ID=2 This statement works fine.You might be facing some other problem if so...

MS SQL Server: Replication Problem, replication problem, network disruption
replication problem, network disruption, retention periods: Merge replication is notoriously sensitive to any kind of network disruption, timeouts, etc. It s not very good at recovering even from a temporarily loss of connectivity sometimes. Is there a whole lot of data? You could be getting timeouts, have the...

MS SQL Server: Restricting Query Sizes, execution timing, query sizes
execution timing, query sizes, query execution: Hi Lee, To restrict query size you can set some options at your server in Enterprise Manager. - First of all choose particular server and then go into its properties by right click.go to server setting tab.here you can see one query governor option in...

MS SQL Server: Retrieve Stored Procedures using SQL, server explorer, text column
server explorer, text column, object id: Stored procedures are contained in the TEXT column of the syscomments table (the correct way to access them in SQL 2005 is via the DEFINITION column of the sys.sql_modules view). You don t specify what kind of corruption your database has, but I think...

MS SQL Server: Retrieve Stored Procedures using SQL, server explorer, database right
server explorer, database right, sql syntax: I m not sure this will work depending on what type of corruption you are experiencing, but try sp_helptext storedprocname this should work for most objects (stored procedures, functions, views). don t think it works for tables though. Can you not...

MS SQL Server: Rollback in SP, rollback transaction, goto point
rollback transaction, goto point, errorcode: The code looks basically okay. Could be that DTS is enlisting in the transaction and not rolling it back properly. You may need to explicitly raise an error. One way to do it is something like this: DECLARE @sErrMsg varchar(500) DECLARE @iErr int ...

MS SQL Server: Row Number, sql server 2000, query condition
sql server 2000, query condition, code vb: Hi, If you just want to autonumber your results by position, you can insert into a temp table with an IDENTITY column, but it sounds like students with the same marks need the same number. In this case, there is no easy way to do this in SQL. It s possible,...

MS SQL Server: Run time error -2147467259, run time error, comma delimited file
run time error, comma delimited file, microsoft odbc: Normally I think your approach is a good one, that is closing the connection and setting it to nothing. generally this does clear up the connection. it sounds like something weird is going on with connection pooling. I used to see this occasionally with...

MS SQL Server: random function sql, random function, acceptable range
random function, acceptable range, query analyzer: If you re looking for something quick and dirty , you could run this 30 times, recording the results for use elsewhere: DECLARE @r INTEGER SET @r = -1 WHILE @r NOT BETWEEN 0 AND 2821 BEGIN SET @r = CAST(RAND() * 10000 AS INTEGER) END PRINT @r ...

MS SQL Server: rank (vba), rank1, sql query
rank1, sql query, point of view: Dear sue, this can be done with a good table in database and a good sql query. the one thing you can do is let the user enter the rank range, like 45 and 55 and show records that do fit to them, its very easy from sql point of view, here u just need to...

MS SQL Server: ranking records, sample databases, trap errors
sample databases, trap errors, isnull: Dear Sue, first of all ######## create table #temp1 (id bigint identity(1,1) , tasks datatype here , ranks datatype here ) insert into #temp1 from (select * from tblsummary)a ######## suppose you have one auto generate column in the temporary...

MS SQL Server: When the last reindexing done?, profound apologies, tibu
profound apologies, tibu: Profound apologies for the delay. I was absolutely certain that the information you want was available, but I have not been able to find it myself. You can re-post your question to allexperts.com and see if anyone else can answer. Also, if you tell...

MS SQL Server: report server matrix, result table, weekend dates
result table, weekend dates, question thanks: Dear Todd, There will surely a good query to run to get the desired result. Here I am saying what I have thought regarding this: Try using while loop on the first table, and you don t need the second table, OK. Then use while loop for date starting from...

MS SQL Server: run a sql script in visual basic 6.0, sql script, filesystemobject
sql script, filesystemobject, long strings: Haven t worked in VB in awhile, this is trivial in .NET though. Try looking up the FileSystemObject if I recall correctly, there should be examples of reading a text file into a string. I don t think it s terribly difficult. This is definitely a good idea...

MS SQL Server: Say no to cursors?, database object, sql commands
database object, sql commands, database name: Hi, Cursor is a database object used by applications to manipulate data in a set on a row-by-row basis, instead of the typical SQL commands that operate on all the rows in the set at one time. For example, you can use cursor to include a list of all...

MS SQL Server: Secondary data file, bad sector, mega bytes
bad sector, mega bytes, sql 2000: URL s are: http://www.sql-server-performance.com/clustering_intro1.asp http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx http://www.windowsitpro.com/SQLServer/Article/ArticleID/5331/5331.html http://sqlservices.redrock.net.au/services/implement/sqlclusterimplement/default.as...

MS SQL Server: Select Query, sum total, schema
sum total, schema: Dear Girish Kumar Sharma, Sorry as I was somewhat busy. SELECT SchoolCode , [First] = Sum(First) , [Second] = Sum(Second) , [Third] = Sum(Third) , [Fail] = Sum(Fail) , [Total] = Sum(Total) FROM ...

MS SQL Server: Select Query Help, rtrim, thanks in advance
rtrim, thanks in advance, m3: Dear Girish Kumar Sharma, This needs that you should have one more column in your Marks table as unique identifier and should be incresed by for every new row. if i add the same in Marks table. then the query would be like: SELECT C.RollNo ...

MS SQL Server: Select Query, query output, warm regards
query output, warm regards, zero value: Dear Girish Sharma, The query just needed to put one where condition and its there below. ###### SELECT b.Schcode , isnull(c.Candidates1, 0) AS Candidates1 , isnull(d.Candidates2, 0) AS Candidates2 , Diff = isnull(c.Candidates1, 0) -...

MS SQL Server: Set SQL sever start automatically, sq server, tibu
sq server, tibu, progress status: Dear Tibu George, Sorry for so late answer. Starting sql server means starting the services. You should try scheduling the services for sql server in the services item found in administartive tools in control panel. The realted service names are: -SQL...

MS SQL Server: Snytax for migration from Access 2000, import wizard, sql queries
import wizard, sql queries, database table: Dear Davin Hampton, If you have sql server 2005 with you, i prefer you use the data import wizard available there. Thanks, Jwalant Natvarlal Soneji Dear why do you think so, yes that great if one can be his own answering person. But as per you question...

MS SQL Server: SP, object browser, query analyzer
object browser, query analyzer, query builder: I don t know of any free ones. There are some 3rd party tools. A couple things you can try that might speed up the process. One, you can get a list of the columns for any table by using the object browser in Query Analyzer and right-clicking on the table....

MS SQL Server: SQL, artificial key, social security number
artificial key, social security number, normalization rules: The answer as always is, it depends. There are some rules, but it depends on how strict you want to be with normalization rules. Technically, the primary key should be that one piece (or pieces) of data that is unique about the row and that will only ever...

MS SQL Server: SQL, kalen delaney, computer hardware technician
kalen delaney, computer hardware technician, google groups: This might be a good start, I actually know one of the authors Beginning SQL Server 2000 DBA: From Novice to Professional http://www.amazon.com/gp/product/159059293X/ Anything by Kalen Delaney is great, if you do an Amazon search for her you ll find...

MS SQL Server: SQL 2000 permissions, server role, recommended approach
server role, recommended approach, domain admin: There are a couple of ways this is typically done. Without going into a lot of detail, here is the approach. Put all the users that you want to access the app in a domain user group. Grant that user group access to the database, optionally putting the...

MS SQL Server: SQL 2000 & Windows 2003, terminal services session, sql application
terminal services session, sql application, good afternoon: It s probably permissions. Try logging into the terminal services session using a local administrator s account and see if you have the same issues. Terminal services connections tend to be locked down fairly significantly, there are probably things the...

MS SQL Server: SQL 2005 Not Loading, new dell, dell 2950 server
new dell, dell 2950 server, reporting services: Dear Jerry, Sorry for not being perfectly known to the answer, but you may try the surface area configuration to start the reporting services and then server configuration utility to configure the reporting services. May you need to try configuring reporting...

MS SQL Server: SQL, ms sql server 2000, sql server 2000 service pack
ms sql server 2000, sql server 2000 service pack, ms sql server: hmmm, kinda sounds like a linked server permission issue related to the server rebuild. do you get any errors if you just run the same sql in query analyzer? any difference when run on the actual sql server vs a remote box? how about if you just run EXEC(@vcCmd)...

MS SQL Server: SQL, ms sql server, database management software
ms sql server, database management software, open source software: Well, your costs are going to be similar with any enterprise level database platform. MS SQL 2000 Standard Edition was not free, are you sure you aren t using the desktop edition? that s the one with the 2GB limit. You could move to SQL Express 2005 as...

MS SQL Server: SQL, ashu, table group
ashu, table group, datatype: Dear Ashu, To do the same with query you need to have one unique id column in that table, and if it has int kind of datatype then it can be done with the following way. ########## Select id from table where id in (select id from table where name in...

MS SQL Server: SQL 7 Replication Troubleshooting, sql server agent, info recieved
sql server agent, info recieved, sql 7: You can do almost anything with replication from T-SQL, but it isn t necessarily easy to figure out or do correctly. There is a bunch of information in Books Online about the various syntax. You might try just removing replication completely from Enterprise...

MS SQL Server: SQL BACKUP AND RESTORE, differential backups, backup directory
differential backups, backup directory, backup set: While log shipping is not TOO complex, there are too many variables for me to give you full details here. However, I can give you an overview and recommend that you check this out: http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship1.mspx...

MS SQL Server: SQL Backup, sql server help, sql server database
sql server help, sql server database, mdf file: Each SQL Server database has 2 files associated with it, an mdf file (data) and ldf file (log). You can see the paths when you restore a backup. If you restore over an existing database, you ll want to make sure that it is using the same locations for the...

MS SQL Server: SQL Create View Command, query execution, virtual table
query execution, virtual table, execution time: Hi, A view is a virtual table that consists of columns from one or more tables. Though it is similar to a table, it is stored in the database. It is a query stored as an object. Hence, a view is an object that derives its data from one or more tables....

MS SQL Server: SQL Database stored on removable harddisk, communication link failure, sql server service
communication link failure, sql server service, external hard disk: As long as the external hard disk is coming up on the same drive letter, SQL Server should be able to figure it out. Haven t tested that out though, but seems similar to the way people use external network attached storage. Try connecting the hard drive...

MS SQL Server: SQL Divide by, 66666666, employee id
66666666, employee id, allexperts: Ian, Can you give me some examples of the numbers you get back for Count(hours_worked)? I m wondering if maybe there are some nulls in the data or something and you are getting back a zero. probably not, but this is s bit weird. Also, I noticed you...

MS SQL Server: SQL error, retail management systems, retail management system
retail management systems, retail management system, microsoft odbc: I am not farmiliar with Microsoft Retail Management Systems I am not sure if your POS software is using SQL or not. You did not mention it. however i believe the error -2147467259 is a Microsoft ODBC SQL Server Driver TCP/IP Socket Error . In short......

MS SQL Server: SQL FileGroup, sql server 2000, quick response
sql server 2000, quick response, year 2000: Really the only way is to create a view that pre-filters the data for you, but you will still take the performance hit of the where clause. Most people just create archive tables and move the data over each year, each quarter, each day or whatever. You...

MS SQL Server: SQL Join Question, syntax example, level case
syntax example, level case, result table: I don t understand your criteria for joining the 2 tables. Is it if Data1 0 or Data2 0 or both? this might get you close, but not sure it will always return the results that you want. create table #test (Level int, Data1 int, Data2 int) create...

MS SQL Server: SQL Local Administrator Rights, computer conversion, accounting system
computer conversion, accounting system, db administrator: You could probably do it either way, but given that this is your accounting system, and another firm (supposedly) has responsibility for it, if I was in your shoes I would not WANT any rights that let me modify ANYthing in any way. I m not sure if you re subject...

MS SQL Server: SQL Query Needed for identifying same duplicate rows., convienience, varchar
convienience, varchar, object id: Dear Pram, Here i have created one Stored Procedure which solves the problem of duplication.Just to make it understandable i have inserted data here but for your convienience you can set parameters for inserting data. ------------------------*************************-----------------...

MS SQL Server: SQL Query Needed for identifying same duplicate rows, premnath, occurences
premnath, occurences, cursor: Hi R. J. Premnath, 1) when we want to see the same rows of the table, use of self join will do. on the other hand a simple way can be this... use it like this: select T1.*, count(*) from table1 T1 group by t1.field1, t1.field2,.... having count(*) 1...

MS SQL Server: SQL Query, spelling mistake, author names
spelling mistake, author names, party tools: There is nothing built into SQL Server that can really do this for you. You can potentially use the function SOUNDEX (see Books Online). It will give you a score comparing 2 values and if they are close enough, you could investigate further. This is still...

MS SQL Server: SQL query, question thanks, select statement
question thanks, select statement, minimum time: Dear Robert, I think unless your custid is character or uniqueidentifier then would take more time with more records otherwise for integer custid it will take minimum time. Try to use indexes and it will surely help. Thanks, Jwalant Natvarlal Sonej...

MS SQL Server: SQL query, numeric expression, syntax error
numeric expression, syntax error, sql 7: Ceiling has a different usage in SQL Server. Here is the definition from the Books Online. Returns the smallest integer greater than, or equal to, the given numeric expression. would something like this work SELECT CASE WHEN real_seconds 60...

MS SQL Server: SQL question, sql server 2000, auto increment
sql server 2000, auto increment, vb applications: Yes, multiple users can surely access your data at the same time. But be careful when theres any insert operation is being done. If the table in which the data is being put dont have any identity auto increment column then it will create problems if...

MS SQL Server: SQL question!, temp table, room numbers
temp table, room numbers, loop through: This is the sort of thing that doesn t really lend itself to t-sql to be honest. It would be better to do this using code of some sort. If you wanted to use t-sql, the only way I can think of off the top of my head is using cursors. You would loop through...

MS SQL Server: SQL retrieving data from Oracle, regional databases, oracle driver
regional databases, oracle driver, sql server 2000: Dear Oliver, 1. I guess you can start reading the MSDN BOL for sql server 2005 and also get more information about the components in the same and try to learn from start. You may need to use data source and transforms and then putting data in to the destination....

MS SQL Server: SQL SERVER, single user mode, database properties
single user mode, database properties, sql server 7: Check the database properties in Enterprise Manager and make sure the database is not in single-user mode. There are various processes that can leave the database in single-user mode even if you don t set it explicitly, such as a failed backup. That is the...

MS SQL Server: SQL Server 2000 Connection to Database, sql server 2000, girish
sql server 2000, girish, problem thanks: This is a common problem, but the steps to fix it are rather involved. I will explain the problem and you can decide which direction you want to pursue. When you use Windows Auth in SQL Server, you must connect from a web application using a Windows account...

MS SQL Server: SQL Server 2005 and DTS, ms access database, sql server 2000
ms access database, sql server 2000, trap errors: DTS changed a lot in SQL Server 2005 and is now called Integration Services. From what I ve seen, it s a bit more complicated to use, but I think importing and exporting data is still pretty straight forward. I don t think they changed that a whole lot,...

MS SQL Server: SQL Server Authentication, server authentication, mssqlserver service
server authentication, mssqlserver service, sql server 2000: You should be able to just go into Services and change the password there for the MSSQLSERVER service. You may also need to change the password for the SQLSERVERAGENT service. Another thing you can do is run SQL Server under a different account than...

MS SQL Server: SQL Server DTS Job, work thanks, joshi
work thanks, joshi, background color: Hi Bharat, I think this is not possible to do formatting of Excel file through DTS.Because in DTS if you are able to write code for formatting at any how then also will not be able to use it in Excel file. I m telling as per my knowledge.Do not know...

MS SQL Server: SQL Server HDD For Transaction Logs, raid 5 array, transaction log files
raid 5 array, transaction log files, usb hdd: I don t have any experience with this, but it seems possible. The biggest thing you run into with attached drives are them not being available yet when SQL Server tries to start. But this would happen more with Network Attached Storage or something like...

MS SQL Server: SQL Server Move, ip address change, hosts files
ip address change, hosts files, all the web: You do have to be a bit careful. SQL Server is better about handling this, at least with the default instance, than it used to be. See if this KB article helps at all: http://support.microsoft.com/kb/303774 Also, keep in mind that you may have some...

MS SQL Server: Can SQL Server replication be turned in an active system (Database are currently being updated), server replication, minimal downtime
server replication, minimal downtime, production tables: Without knowing the details of your implementation, I m hesitant to say this will cause no problems. It shouldn t cause problems, but I ve seen replication get a little screwy from time to time. That being said, it should cause minimal downtime, but really...

MS SQL Server: SQL Server Too Slow, null question, collate
null question, collate, question id: This might be a long shot, but I ve seen this before with other collations and may be the same for yours. All of your input fields (in the WHERE clause) are being sent in as integers, but all the fields in the table are nvarchar. Because of this, it is likely...

MS SQL Server: SQL Server Too Slow, execution plan, statistics network
execution plan, statistics network, network statistics: Hi, 1) Run Update Query through Stored Procedure. 2) Secondly, Put the update statement into a transaction. (very important) 3) Thirdly, pls put all the filter into a select statement and get some unique row identifier for which update needs to be done....

MS SQL Server: SQL Server Statistics: How can I access and delete them?, drop column, statistics table
drop column, statistics table, server statistics: Hi Danny, Have you tried DROP STATISTICS {table}.hind_0522454? You can generally temporarily get rid of stats without causing issues and SQL will rebuild them as needed. I would try that first. You might want to do a rebuild statistics afterwards if that...

MS SQL Server: SQL Server -vs- Lotus, collaboration tool, lotus notes
collaboration tool, lotus notes, relational databases: Hello, Let me preface my answer by saying I don t know much about Lotus Notes, but I have worked with a number of people who have used it and I rarely heard a positive comment about it. And as far as I know, you are correct that it doesn t provide any...

MS SQL Server: SQL Server weird icon, something weird, red line
something weird, red line, triangle: Hi Gabriel Aragon, The server with a circle and a triangle means that SQL Server is running, i.e Services related to SQL are also running. Vertical red line, similar to a lightning, pls let me know or upload the screen shot, so that i can see exactly what...

MS SQL Server: SQL Statement, colorcode
colorcode: You ll probably have to get the max ColorCode first and put it in a WHERE clause You could also try something like: SELECT RepNO,max(ColorCode),SUM(Ttl) FROM myTable WHERE ColorCode IN (SELECT max(ColorCode) FROM myTable) GROUP BY RepNo I think...

MS SQL Server: Why is my SQL script taking ages to run?, contract base, stts
contract base, stts, sce: It s hard to say. That many left joins alone doesn t necessarily mean a query is bad. It will certainly take some time depending on the size of the tables. A couple things to check. Do you know how to use the query plans in SQL Query Analyzer? Pop the...

MS SQL Server: SQL server transaction, server transaction, server 2000
server transaction, server 2000, many thanks: There are different levels of locking depending on the update statement. SQL Server 2000 can lock down to the row level. So if one user is updating one row and another user is updating another row, they could both potentially update at the same time. If...

MS SQL Server: SQL server, open source database, manageable groups
open source database, manageable groups, server groups: Creating Server groups help us to organize a large number of servers into a few manageable groups.E.g In a project you have multiple servers. So create a group named Projects. Then in this group, add the Servers which are reguired to be managed. Similar way...

MS SQL Server: SQL Table Question w Access comparison, sql enterprise manager, sql server database
sql enterprise manager, sql server database, combo boxes: The short answer is no. It is expected that any access to a SQL Server database will be through some sort of application, whether web or Windows. You can do combo boxes in either of those environments. The correct way to do it in SQL Server is to have a...

MS SQL Server: SQL Undo, chandan singh, exec sql
chandan singh, exec sql, execution time: Dear Chandan Singh, One can not undo queries unless transactions used. Use transactions and rollback to do the same. But in general situations you can get with this query: ############### Select dmStats.last_execution_time as Last Executed Time ,...

MS SQL Server: SQL Update, mapping table, first glance
mapping table, first glance, farmen: Couple of questions Why does it break at 99? Are the mappings between Organisation and Address always the same? Why aren t you updating the Organisation when the rest of the row is updated? I understand there may be a good reason for this, just curious....

MS SQL Server: SQL, select statement, query engine
select statement, query engine, many thanks: Sure, that s the same as doing SELECT * from table1 it just means select all the columns in the table. It is generally recommended to explicitly put in the columns you want in any select statement though. This is more efficient for the query engine...

MS SQL Server: SQl Server 2000 - Excel sheet, sql server 2000, excel sheet
sql server 2000, excel sheet, result sets: Dhaval - you have two options. OPENROWSET-you can use this to access the data in a remote server.The OPENROWSET function can be referenced in the FROM clause of a query as if it were a table name. The OPENROWSET function can also be referenced as the...

MS SQL Server: SQlServer, data transformation services, microsoft ole db provider
data transformation services, microsoft ole db provider, export wizard: Dear Ganesh, Easiest way is to use Data Transformation Services(DTS) of SQL Server. DTS is a set of tools you can use to import, export, and transform heterogeneous data between one or more data sources, such as Microsoft SQL Server, Microsoft Excel,...

MS SQL Server: Sql 2000 Server, sql services, computer name
sql services, computer name, sql 2000: Hi, For question 1, I believe you have to reinstall SQL Server to get it to pick up the new name. There is a stored procedure to change the server name, but I believe you have to run it before changing the computer name. You could try changing your computer...

MS SQL Server: Sql Question, cpu usage, multiple users
cpu usage, multiple users, server performance: Dear Hussain, It seems that there should not be any problem with the view, but the query that is put into the view can make the variation, try doing following: 1. check for server performance and cpu usage when executing view, as it takes too much of them,...

MS SQL Server: Sql Server DTS, dts package, dscm
dts package, dscm, variable value: Dear Tristan, May be the declaration of the variable value in the stored procedure is making the variable reset and not setting the approprite value. try setting the variable as output. thanks, Jwalant Natvarlal Soneji Mob: +91 9969059127 http://jwalant.soneji.googlepages.co...

MS SQL Server: Sql Server Stored proc exectuion error, exectuing from VB, destination databases, exact parameters
destination databases, exact parameters, vb dll: OK, that s a LITTLE more detail, but not nearly enough. This is going to require a methodical approach and some sleuthing. The 1st thing to do is determine if the fault is in the VB DLL or the stored proc. I would use Profiler to monitor the SQL Server...

MS SQL Server: Sql server DTS Package, 2 steps, select count
2 steps, select count, occured: Well, you are raising an error. So your step is not successful from the standpoint of SQL Server. If you don t want to treat this like an error, you should do logging or something instead. If you want this raised as an error, but still want the next step...

MS SQL Server: SqlDumpExceptionHandler, ent ed, sql 2000
ent ed, sql 2000, application exception: I would need more information to have any idea what is causing it. That is a generic application exception message. I ve seen it happen when there is a password change on an account used by SQL Server, when a disk is full, different things like that. ...

MS SQL Server: Store Procedure, element array, split function
element array, split function, gfd: SQL Server does not have a built in Split() function. You can create your own UDF if you want to. Since you know the number of parameters as also the separator string, you could use a solution depicted below. Please note that the ParseName() function uses...

MS SQL Server: Stored Procedure/ASP.NET question, nvarchar, sproc
nvarchar, sproc, vb web: I m not sure if you have having difficulty passing the data into the sproc or with the logic itself. I could be wrong, but I think what you may want is the following: 1. only pass in the ittNumber 2. do a standard INNER JOIN, not a CROSS JOIN 3. add...

MS SQL Server: Stored Procedure, output flag, local variable
output flag, local variable, mstr: One way is to define a local variable in the second proc and then call it with the OUTPUT flag. I m not sure if you can use the same variable defined in the second procedure. you don t really need it necessarily CREATE PROCEDURE GetStringVal AS DECLARE...

MS SQL Server: Stored Procedures / Triggers, middleware application, target database
middleware application, target database, mssql server: Dear Michael, This may help: http://www.databasejournal.com/features/mssql/article.php/3581846 Well, The trigger should have filter on the required condition and then just insert or update queries for the target database. Thanks, Jwalant Natvarlal Sonej...

MS SQL Server: String function, nvarchar, abcdefg
nvarchar, abcdefg, string function: I see nothing wrong with what you ve type. To validate, I just tried the following and it worked as expected. Is this different from what you re doing?-- --try it with a var first: declare @x nvarchar(12) set @x = N abcdefg select substring(@x,2,12)...

MS SQL Server: SUM function, employee id, sum function
employee id, sum function, customer id: You should be able to just do hours_worked * pay_rate as amount_paid in your original query to get that value. your second query should work, but you may want to just call it behind the scenes and set a variable to the sum and then display it on the...

MS SQL Server: Substr command in SQL (ADO), code vb, ms access
code vb, ms access, blob: you can t use substring on a column of type TEXT. text fields are up to 2GB of data stored as a binary blob. if you know your data is smaller than that, you can try to convert to varchar first and then use substring. but if you have a lot of data it would...

MS SQL Server: Suggest me, ms sql database, sql server management
ms sql database, sql server management, ms sql server: Dear Ashish, You may need to login to server and then expand the databases node and then expand the approprite database node and then exapand tables node and then right click the approprite table and click open. Now, in the screen coming you you can manually,...

MS SQL Server: select flat file name in DTS, dbaseiv, sql table
dbaseiv, sql table, export wizard: The main way I can think of doing this is a custom DTS job that you write in VB or C++, using the DTS Library. That s a pretty technical thing to do and too complex to go into here. There are some tutorials online I believe. Is there a way you can trigger...

MS SQL Server: How to select the top result (with complications), banging my head, related games
banging my head, related games, dodgeball: This might be a case where if you are banging your head against the wall, you might be using the wrong tool. This isn t logic that lends itself well to t-sql. I m not saying it s impossible to come up with some solution, but it will probably involve some...

MS SQL Server: How to set data cube in MS SQL Server??, ms sql server, olap cube
ms sql server, olap cube, data cube: To add an OLAP cube to a project On the Model menu, click Import Cubes. If asked, enter the name of the Analysis server on which the database resides, select the name of the database. From the Available list, double-click the desired OLAP cube...

MS SQL Server: show the values two fields in one, sql query, column data
sql query, column data, lastname: select EMPNO, FIRSTNAME + + LASTNAME as FULLNAME from table you can do this with almost any column, but if the column data type is numeric, like an int or something, you ll have to convert it to varchar first select convert(varchar(10), empno) ...

MS SQL Server: A simple move, basic data types, sql server 2005
basic data types, sql server 2005, import option: Autonumber is not compatible. You should probably remove that from the table before trying to import. You can use a column with the IDENTITY attribute to get similar behavior in SQL Server. I don t think currency is compatible either and maybe not yes/no....

MS SQL Server: space for mdf,ldf, production server, good answer
production server, good answer, free space: There is not enough information here for a good answer. It depends on many factors, including: 1-How much data will your database hold (how many MB) 2-How will your database be used (frequency and size of updates throughout the day) 3-Is there just one...

MS SQL Server: sp_attach_db, database level, query analyzer
database level, query analyzer, master database: The error message basically tells you the problem. SQL Server allows you to set character set, sort order, etc at the database level. You can t attach a backup with different options than the database you are trying to attach to. The Unicode comparison...

MS SQL Server: sp_MsGetVersion, gary wong, sql server 7
gary wong, sql server 7, sql servers: Thanks Gary, Yes, I ve read similar articles before. I m still not seeing anything on that particular extended sproc, although I agree that other extended sprocs can be more problematic. You really have to know what you are doing before you just start...

MS SQL Server: sql, database level, database c
database level, database c, level users: If I understand your question, granting any privileges on a table to a user just lets that user do those priveleges to THAT table. If that table has FKs that reference another table to which the user does not have any priveleges, the user would not be able...

MS SQL Server: sql 2000 restore, back ups, incremental backups
back ups, incremental backups, database backups: You would have to have incremental backups to do what you want to do. And even then it would be tricky. There are a couple basic ways to do backups in SQL Server. 1. Restore a full backup only 2. Restore a full backup and put one or more incremental...

MS SQL Server: sql 2005, dt 5, database statement
dt 5, database statement, ldf: Now we re getting somewhere. But the most important thing is to make sure you re in the SS_L04 database (either with the USE SS_L04 command, or using the SSMS database dropdown). After you execute the CREATE TABLE statement, you can do: SELECT * FROM lab04...

MS SQL Server: sql 2005, select system, conn
select system, conn, sql server: OK, that confirms that the CREATE TABLE command worked. It created the table named lab04 in whatever database you re in (you still haven t addressed that.. have you confirmed you re in SS_L04 ?) So, now where are we? How are you connecting to the sql...

MS SQL Server: sql 2005 server, server authentication, minimum memory
server authentication, minimum memory, network protocols: Dear sue, sorry for so late reply. The services for sql server processes and sql agent process and if installed other things like analysis service or reporting services, then they all by defaulty manual serivces and enabled. thanks, Jwalant Natvarlal Sonej...

MS SQL Server: sql 2005 server, windows xp service pack, sql server 2000
windows xp service pack, sql server 2000, minimum memory: Dear Sue, I guess I have answer to some of your questions. 1. Service for sql server and sql server agent is active and automatic as they are very critical. Others like full text search, integration services (sql server 2005) and reporting services (add...

MS SQL Server: sql 2005 server, minimum memory, server authentication
minimum memory, server authentication, network protocols: Welllll... you wouldn t get what I would call a screen . You d see the results of the SELECT in the results pane. But that may be what you meant. sys.sysconfigurations exists in every database, so you do not have to select nor specify one. -dav...

MS SQL Server: sql batch operation, batch operation, vani
batch operation, vani, req: Dear Vani, If I am not misunderstanding, what you need to have is the multiple select statements or one select with order by that sid. Try putting the select in a loop in the stored procedure and will give you multiple select results (If you really need...

MS SQL Server: sql doesn't connect to local server, sql connection, network error
sql connection, network error, network documentation: Glad you got it working. Yeah, if that fixed it, it sounds like some local host file problem or something is a bit off in networking. I have seen what you did work before though (using 127.0.0.1), so I guess if it works that s the important thing. c...

MS SQL Server: sql help, database data files, mdf file
database data files, mdf file, location column: Hi, I have already sent u an answer to this, kindly let me know is it working or not? You go to Enterprise Manager and attach the database. Steps are as follows: 1) Expand a server group, and then expand a server. 2) Right-click Databases, and...

MS SQL Server: Why is sql so inconsistent?, google groups, lname
google groups, lname, server names: I guess I don t find it inconsistent, there is nothing requiring a stored procedure to return any kind of data or resultset. How would you enforce any kind of select syntax without also enforcing that a stored procedure returns a data result? I understand...

MS SQL Server: sql server, odbc server driver, sql server database
odbc server driver, sql server database, microsoft odbc: This is typically some sort of network problem, either on your computer or the network itself. Can be hard to diagnose. I would try troubleshooting using some of the following steps: 1. Does the problem happen on other computers on the lan? try a different...

MS SQL Server: sql server 2000, sql server 2000, ms sql
sql server 2000, ms sql, competitor: MS SQL is the same as SQL Server. I don t know if you are referring to MySQL which is a competitor to SQL Server just as Linux is to Windows. I don t know much about MySQL, but SQL Server can be used as the backend for websites and can surely be used with...

MS SQL Server: sql server 2000, sql server 2000, posible thanks
sql server 2000, posible thanks, ramaswamy: Dear Ramaswamy, There can be one easy way to do this. Just put all the results to a temporaray table in the same query and temp table should have one column as identity and seed=1. then it will show the no of row. thanks, Jwalant Natvarlal Soneji Mob:...

MS SQL Server: sql server 2005 trigger, christable, audit table
christable, audit table, osql: there is no to file command using select. you will need to call isql using xp_cmdshell. generally not recommended, it s not going to perform very well. why can t you just put data into an audit table? there are a lot of security implications involved...

MS SQL Server: sql server help, mdf file, partition table
mdf file, partition table, ldf file: One thing you can try is to forget about the ldf and just try to attach the mdf file. Sql Server can create the ldf file and you should still have most of your data. But if the mdf is corrupt, not sure what your options are. sp_attach_single_file_db ...

MS SQL Server: sql server, microsoft sql server 2000, microsoft sql server
microsoft sql server 2000, microsoft sql server, sql server 2000: Hi, Basically if the user account has the ability to update tables, they can do the same thing with Sql Enterprise Manager. I would handle this 2 ways. The first is, don t let users who shouldn t have Enterprise Manager access have the software. So...

MS SQL Server: sql, data validation, laguage
data validation, laguage, server objects: Dear brent, the one way that i have myseft tried to learn sql server is that start from sql book like one small book by evan byross and rdbms by h f korth and then go to management studio and can do more with it once you are done with basics of database...

MS SQL Server: sqlserver2000, renu, select name
renu, select name, sql database: Dear Renu, i am doing a project in telecom domain in sqlserver2000 i need an query that when i dropped the phone how many analysts are there in queue Here if I assume that analysts are the users that are trying to connect call to you, then you must be...

MS SQL Server: How can i stop and start SQL server, sql server 2000, followup questions
sql server 2000, followup questions, cmd file: Put the following commands in a CMD file and set a scheduled task to execute it whenever you want SQL Server stopped & restarted: @ECHO OFF NET STOP SQLSERVERAGENT NET STOP MSSQLSERVER NET START MSSQLSERVER NET START SQLSERVERAGENT (the above is...

MS SQL Server: stored procedures, vbtab, select count
vbtab, select count, getstring: A variation on this example from MSDN should do what you need. The NextResult method on the reader is what you need. Regards, Curtis ------------------------------ Dim myReader As SqlDataReader = myCMD.ExecuteReader() Dim fNextResult As Boolean...

MS SQL Server: T-SQL - Restrict child record selection to 1, query parser, fellow volunteer
query parser, fellow volunteer, sql problem: You might be able to do something like: LEFT JOIN (select top 1 providerid from SalesTeam where providerid = c.providerid order by providerid asc) s ON c.providerid = s.providerid that might confuse the heck out of the query parser, but it could work....

MS SQL Server: Table row protection, initial data, data tables
initial data, data tables, access applications: Assuming you design your user interface properly, the database should take care of the locking for you. if you are going to have the potential of 2 users actually live-editing the data at the same time, then you may have to control it a bit more. there are...

MS SQL Server: Temporary Table Confusion, hash mark, intermediate calculations
hash mark, intermediate calculations, input table: It is a limitation of temp tables. Basically, they can t bee seen by any entity higher up the call chain. When you execute dynamic sql, no temp tables can be seen. There may be a convoluted way to create the table in your proc, then use ALTER TABLE commands...

MS SQL Server: Temporary table mystery, temp table, column id
temp table, column id, odd behavior: Do you always get the same number of records in the temp table? I m wondering if the ROWCOUNT has gotten set to something other than unlimited. Try running the script in query analyzer (pull it out of the stored proc) and put this at the very beginning....

MS SQL Server: Terminal Services and Remote Desktop, proper permissions, default options
proper permissions, default options, remote desktop: The only thing I can think of to check would be the built-in firewall. I don t think it allows connections on that port by default. If you are actually running a true Terminal Server and not just connecting using the default options, then I don t have much...

MS SQL Server: The problem is that I am also..., excel code, choice field
excel code, choice field, macro code: There is probably no way I can give you enough background for you to do it in ASP.NET if you haven t tried it yet. But I would encourage you to check it out when you can. As far as sql, I would approach it something like this. It would need to be a stored...

MS SQL Server: TIMEOUT problem in SQLSVR 2000, relevant index, dbserver
relevant index, dbserver, orderly fashion: That was helpful information. 1. If possible, I d recommend more memory for the server. The CPU is fine, but 512MB is (IMO) barely adequate for production environments. Also, I forgot to ask: what does your disk subsystem look like (local or SAN drives?...

MS SQL Server: Tiggers or procedure, positive reply, server agent
positive reply, server agent, tiggers: You cannot write a Trigger in this situation as it s execution is dependent on some event (insert / update / delete). Instead, you could write a Stored Procedure and schedule a Job (SQL Server Agent) to execute the procedure daily, so that it can check the...

MS SQL Server: Time Based Data Retrival, problem with this approach, sql operations
problem with this approach, sql operations, updation: You can t really, unless you do it in the program layer. This could be either in the application hitting the database or in the stored procedures that do the data update/select etc. But there is nothing in SQL Server security that allows this. However,...

MS SQL Server: Transform a global variable value from Execute SQL Tasks, source connection, visual fox
source connection, visual fox, pro database: Dear May, Can you please verify the visual fox pro data source connection is working fine? If that is not a problem, then I would like to ask you to send me a sample visual fox pro database file on the email id (jwalant.soneji@gmail.com), so that I can try...

MS SQL Server: Transform a global variable value to Visual FoxPro Fee Table, input parameter, variable value
input parameter, variable value, dropdown list: Dear May, You may need to create one global variable first and then put parameter place-holder (?) in the query. Now click on parameter and you will find it there. If parameter has not been created earlier then click on create global variable and then will...

MS SQL Server: Trigger To Move Records, nvarchar, col3
nvarchar, col3, pseudocode: Hi, Ted You ll need some sort of unique key for this to work. The pseudocode would be something like CREATE TRIGGER trgMove ON Table1 FOR UPDATE AS INSERT INTO Table1 (Col1, Col2, etc) select Col1, col2, col3, col4 from inserted DELETE Table1...

MS SQL Server: Trigger, two tables
two tables: Something like this should be close... CREATE TRIGGER trg_tblTransfer_i ON tblTransfer FOR INSERT AS BEGIN UPDATE tblMember SET Status = Non-Member FROM tblMember m, inserted i WHERE m.memberID = i.memberID AND i.TransferType = Transfer...

MS SQL Server: Triggers and Foreign Key Constraints, customer id, constraint
customer id, constraint, customer information: It gets a bit messy. If you want to use a trigger, you almost have to grab all the data from table B, delete the row in table B and reinsert the row. either that or use a stored procedure that takes care of table B anytime you change the CustomerID of table...

MS SQL Server: TSQL Link Two Tables?, two tables, james brown
two tables, james brown, nancy: select col1, col2 from table1 UNION ALL select col1, col2 from table2 that should do the trick. there are a couple different types of UNIONs that change the way the combining is done, so if that doesn t work for you, let me know. regards, c...

MS SQL Server: How do you turn off Must_Change?, sql server data, sql server error
sql server data, sql server error, ms sql server: Dear Elizabeth, If you are not able to delete the database then the server administrator can surely do that. Well otherwise there can be one way out. Try to detach the database by right clicking on the database name and all tasks-- detach database then...

MS SQL Server: Update trigger...., customer id, best bet
customer id, best bet, database users: That s one of the reasons I don t like using MAX(customer_id) for stuff like this. I don t think this is going to work with a trigger since you can t pass in an ID to the trigger. Your best bet is to do the insert into the other table when you do the original...

MS SQL Server: Upgrading Microsoft SQL Server, microsoft sql server, sql server 7
microsoft sql server, sql server 7, sql 7: You can do an inline upgrade to 2000 and it will upgrade your databases at the same time. Just make sure you have backups of all your 7.0 databases, including your master and msdb databases before you do it. I don t think you can have both 7 and 2000 running...

MS SQL Server: Uploading MS SQL Database, ms sql database, sql server database
ms sql database, sql server database, ms sql server: No, you will either need to send your hosting company a backup to restore (if they allow this) or use the Database Import/Export Wizard to move your objects and data to the hosting company s server. If they have the server open for outside access, such as...

MS SQL Server: URGENT!! maintain supplier information, ms sql server 2000, ms sql server
ms sql server 2000, ms sql server, sql server 2000: Dear n.g, I hope you are using some type of web based or windows based form to enable the supplier access his rights. On the page you can show the data availabe in a datagrid and then give him dropdowns and list boxes to update the existing record. ...

MS SQL Server: Use of MS SQL Server verses MS Access, ms sql server, true relational database
ms sql server, true relational database, party interfaces: This is a common question for a small business and there is no easy answer. I m not a big fan of Access because it just isn t meant to be used by more than a couple people at a time and starts having issues at a certain size. That being said, it is much...

MS SQL Server: Using Group By with Joins, pub name, state group
pub name, state group, publishers: Hi, You can use this query. This shows example for Group By clause with joins SELECT a.au_fname, a.au_lname, p.pub_name FROM authors AS a INNER JOIN publishers AS p ON a.city = p.city AND a.state = p.state Group by a.au_fname, a.au_lname, p.pub_name...

MS SQL Server: Using stored procedure output within a stored procedure, dynamic sql, sproc
dynamic sql, sproc, variable output: Hi, Can you give me an example of the output of the stored procedure? I m trying to visualize what your column list looks like. You should certainly be able to do it as an output parameter or even insert the result of the sproc into a temp table and populate...

MS SQL Server: unique nonclustered index, nonclustered index, dts package
nonclustered index, dts package, null values: Without a true unique index, you are going to get that message. The purpose of ignore_dup_key isn t meant to let you leave non-unique values in the index, but to give you a chance to go ahead and create the index before fixing the bad data. I wouldn t leave...

MS SQL Server: update table, column c, dear frankie
column c, dear frankie, max value: Dear Frankie, Fetch results with select query for the details you want, It will have a and b as the output and then use inner join of that query with a simple select from this table. The join should be on columns a and b. And so you can update the table...

MS SQL Server: update table, column c, syntax error
column c, syntax error, max value: Ooops. Try this (I added T2. in fron of the C in SELECT A, C... UPDATE Tbl SET C = T3.C FROM Tbl JOIN ( SELECT T2.A, T2.C FROM Tbl T2 JOIN (SELECT A, B=MAX(B) FROM Tbl GROUP BY A) T1 ON T2.A = T1.A AND T2.B = T1.B ) T3 ON Tbl.A...

MS SQL Server: use of select and set statements in TSQL, database column, select statement
database column, select statement, sql select: There is no difference between the 2 statements when assigning hardcoded values, such as those given in your example. The only difference is that Select statement has the functionality to assign the value from a database column while this cannot be done in...

MS SQL Server: useage of Select and set in T-SQL, sql select, computer issues
sql select, computer issues, good answer: Sorry for the delay in answering, I have been having some computer issues. There is no huge difference, although in certain cases the behavior is slightly different. This Google thread might provide a good answer rather than me typing it out. http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&selm=eP%24w78LuCHA.2332%40TK2MSFTNGP12...

MS SQL Server: VB-Sql Server, girish, sql server
girish, sql server, two ways: Dear Girish, There can be two ways for the same. It can be a simple stored procedure or an insert statement. As you have to insert data depending upon the condition, I would prefer to use stored procedure and perform whatever checkins there and then...

MS SQL Server: VB6.0&sql2000, sql book, inventory mgt
sql book, inventory mgt, pl sql: Dear Suja Shyam, creating queries in sql is easy but provided you have knowledge of basics of database and their relationships. start with pl/sql book by evan byross and will get fair knowledege of writing queries. thanks, Jwalant Natvarlal Sonej...

MS SQL Server: View Index, raveendran, select sum
raveendran, select sum, enterprise manager: Creating an indexed view requires the following options set to ON ARITHABORT,CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER, ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS that s probably what you are running into. as far as I know, there is no way to get this...

MS SQL Server: Viewed index, sql server 2000, professional sql server 2000 programming
sql server 2000, professional sql server 2000 programming, indepth study: Dear S.Raveendran, One indexed voiew must not reference any other view(s) It can allow tables and udf s in it only. So here it would be necessary to remove the view from the table or just index the original view (that is orders here) A indepth study...

MS SQL Server: vb & sql server 2000, sql server 2000, master db
sql server 2000, master db, multicomputer: Dear Azarah, For that you need to use ADO or RDO. And more information can be found here: ### http://www.vbexplorer.com/VBExplorer/vb_feature/june2000/Database_Beginner_ADO_DAO.asp http://www.freevbcode.com/source/DMORDODAOADO.zip ### The database server...

MS SQL Server: vbscript, performance degradation issues, excel objects
performance degradation issues, excel objects, asp scripts: I can tell u about using in ASP. and I suppose i will be same in VBScript also. There are a different ways to deal with Excel from an ASP page. The first is to use Excel as an ADO data source (which we cover in our Excel Data sample). This offers a...

MS SQL Server: Windows authentication, sql server connection, server authentication
sql server connection, server authentication, sql server express: This link might help, although it looks like you are getting to the server: http://www.cryer.co.uk/brian/sqlserver/hresult_0x2%20npp_error_establishing_connection.htm sounds like SQL Server Express is not in mixed mode, but in Windows Auth only mode....

MS SQL Server: Working mostly with Stored Procedures in RDBMS., data manipulation, database level
data manipulation, database level, business logic: 1. In general it s better to do as much data manipulation (insert, delete, update, select) from inside stored procs as possible. One reason is that stored procedures are pre-optimized (some say compiled ) and therefore run considerably faster. Another is...

MS SQL Server: How can i work with my programm that use sql database without install SqlServer on pc ?, sql server 2000, sql server express
sql server 2000, sql server express, microsoft desktop: Look into using SQL Server Express 2005 or Microsoft Desktop Edition of SQL Server 2000 (MSDE), you can include this in your installer and install it with the rest of your software. It is a bit tricky since there are other programs that use MSDE and you don...

MS SQL Server: writing user-defined function in SQL SERVER FUNCTION, s stor, sql server 2000
s stor, sql server 2000, server function: This example is from SQL Online Books, you can use this as follows: USE pubs GO CREATE FUNCTION SalesByStore (@storeid varchar(30)) RETURNS TABLE AS RETURN (SELECT title, qty FROM sales s, titles t WHERE s.stor_id = @storeid and ...

Multiple Sclerosis: medicine's side effects, male fertility, chemical signals
male fertility, chemical signals, signaling pathways: Hello Anita, I consulted with our MS Clinic experts regarding your question. They state: I am unaware of Avonex, itself, causing any direct adverse effects on either a man’s attempts to conceive or on fetal development (immediate or long term). As...

Multiple Sclerosis: Just Got Diagnosed, emotional illness, hi chris
emotional illness, hi chris, neurologist: Hi Chris, Being diagnosed with M/S is very disturbing! I was diagnosed in 2004 and I remember how scared I was. However, treatments for MS have come a long way. People are diagnosed early on and start a treatment plan that works for them. My advise...

Multiple Sclerosis: Diagnosis, inner ear infection, hereditary condition
inner ear infection, hereditary condition, question thanks: Hi L, Yes, most likely, there will be swelling, rash and possible itching at the injection site. However, this will not last long after the injection. If it does, please contact your doctor and/or your Neurologist. According to the many books I...

Multiple Sclerosis: Matrix Energetics, matrix energetics, symptoms of multiple sclerosis
matrix energetics, symptoms of multiple sclerosis, integrative manual therapy: Hi Kim, Exercise is very good for people with M/S. However, making sure the person stays in a cool environment is critical. What is also helpful is eating fish because of the vitamins. I would definitely talk to your Neurologist about taking vitamins,...

Multiple Sclerosis: Diagnosis, inner ear infection, hereditary condition
inner ear infection, hereditary condition, question thanks: Hi L, Yes, most likely, there will be swelling, rash and possible itching at the injection site. However, this will not last long after the injection. If it does, please contact your doctor and/or your Neurologist. According to the many books I...

Multiple Sclerosis: Could I have MS?, myoclonic seizures, doctor asap
myoclonic seizures, doctor asap, sinus infection: Hi Kelcy, First of all, I apologize for the length of time it took me to respond to your question/concerns. (I have been experiencing PC problems.) My advise to you is go see your doctor asap and let him/her know the symptoms you have been experiencing....

Multiple Sclerosis: M.S. and Unusual Itching, laundry detergent, medication interaction
laundry detergent, medication interaction, allergy medication: Pruritis (itching) may occur as a symptom of MS, however it has some characteristics that help you to differentiate it from allergic itching. It is different from the generalized itching that can accompany an allergic reaction, in that there is not an external...

Multiple Sclerosis: MS Doctor, productive practice, disclosure requirements
productive practice, disclosure requirements, safety aspect: I am not an expert on medical board requirements, but I can share my opinion about the safety aspect of this. Whether or not it is safe for patients can really only be addressed by knowing the specialty of the physician. As an example, if a physician is...

Multiple Sclerosis: Supplements/herbs - studies vs stories, nerve sheath, medicinal mushroom
nerve sheath, medicinal mushroom, medicinal mushrooms: Hi Li, I suggest you Google Alternative Medicine For Multiple Sclerosis . There are several excellent web sites that have some great information about vitamins, etc., for folks with Multiple Sclerosis. Also, Amazon.com has several outstanding books on...

Multiple Sclerosis: possible ms, multiple sclerosis society, mri changes
multiple sclerosis society, mri changes, symptoms of multiple sclerosis: Hi Regenia, I can imagine how frustrating this is. One of the very frustrating things about MS is that symptoms are sometimes vague and elusive. For this reason, the best and most current set of criteria for diagnosing MS is the McDonald Criteria. The McDonald...

Multiple Sclerosis: Do I have early signs of MS?, full blood test, low neutrophils
full blood test, low neutrophils, heart palpitations: Hello Alex, First, please accept my apology for the delayed response to your question. I had to tend to a family illness that took me away from my computer for several days, so I appreciate your waiting! As a nurse, I defer to diagnosticians such as...

Multiple Sclerosis: tips on dealing with leg drag, national ms society, rehab counselor
national ms society, rehab counselor, nerve pathways: Hi Nicole, First of all, a HUGE hats off to you for doing what you do! I have always been so amazed at the teamwork and camaraderie that goes on between garbage collection specialists. It s like a choreographed dance to watch teams at work. You are amazing!...

Multiple Sclerosis: weird ms symptom, ms diagnosis, dizzy spells
ms diagnosis, dizzy spells, good news bad news: Hello and thank you for your question. Since I am not a diagnostician, I cannot make any kind of diagnosis as to what is going on, but I can share some thoughts from my experience and hopefully send you in the right direction! Although you did not say specifically,...

Multiple Sclerosis: dragging left leg, neurological exam, neurological problems
neurological exam, neurological problems, herniated disc: This can be a symptom of MS, but it can also be a symptom of other neurological problems, such as a herniated disc for example. He would definitely benefit from seeing a neurologist who get could get a clear history, as well as perform a thorough neurological...

Multiple Sclerosis: MS Questions...Thank you in advance, mri brain scan, ms questions
mri brain scan, ms questions, extreme difficulty: Hello A, My advise to you is to make an appointment with your doctor as soon as possible and tell him/her the symptoms you have been experiencing. What he/she will probably do is refer to a Neurologist and recommend a MRI (brain scan). After the results...

Multiple Sclerosis: Coping with stairs, least five years, floor condo
least five years, floor condo, mssociety: Hello there, I can understand your concern about the stairs, as you look ahead to the future. I must admit that assisted devices such as lifts, are not my area of expertise, that being said, I am not aware of any other device that would do the same job...

Multiple Sclerosis: Coping with stairs, expert websites, answering the question
Multiple Sclerosis: Coping with stairs, expert websites, answering the question

Multiple Sclerosis: ms and dental fillings, amalgam fillings, mercury vapors
Multiple Sclerosis: ms and dental fillings, amalgam fillings, mercury vapors, dental amalgam

Multiple Sclerosis: Hot weather, coffee drinker, cold soups
coffee drinker, cold soups, refrigeration products: Hi Andre, Since we live in two different countries, perhaps it would be easier for you to talk this over with patients with multiple sclerosis within your group. Also, another suggestion is to contact your local M/S Foundation. I know I indicated in my...

Multiple Sclerosis: MS, national ms society, multiple sclerosis society
national ms society, multiple sclerosis society, national multiple sclerosis society: Hi Adam, and you re welcome! To answer your further questions, tingling, numbness, muscle spasm can originate from central OR peripheral nervous system. So the strategy is to find out which it is, with the further diagnostic testing. You do not have...

Multiple Sclerosis: MS in children, eye tics, pediatric neurologist
eye tics, pediatric neurologist, james bowen: Hi Diane, Thank you for your kind words; I love what I do and your thoughtful feedback makes it all worthwhile. This is what I would like to do. This is a lot of good, specific information and I would like to try to get more information for you. Being...

Multiple Sclerosis: MS diagnosis, multiple sclerosis society, lumbar puncture
multiple sclerosis society, lumbar puncture, ms diagnosis: Hello, Scott and thank you for your question! MS is diagnosed by a fulfillment of diagnostic criteria. The best and most current set of criteria for diagnosing MS is the McDonald Criteria. The McDonald Criteria were developed in April, 2001 by an international...

Multiple Sclerosis: ms and dental fillings, mercury in dental fillings, silver dental fillings
mercury in dental fillings, silver dental fillings, amalgam fillings: Hi Nicole, this is a GREAT question! There has been much controversy and investigation of this matter, and here is what I have found out. As you have noted, there has been speculation back to the 1970’s that mercury in dental fillings (called dental amalgam...

Multiple Sclerosis: orhovisc, ms, joint
ms, joint, arthritis: Hi there. I am not all that familiar with this medication as OrthoVisc is indicated for the symptomatic treatment of osteoarthritis of the knee, and not specifically used in MS. That being said, one must remember that a person with MS is at the same risk...

Multiple Sclerosis: MS, robinul forte, left flank
robinul forte, left flank, extreme fatigue: Ah! Well all the more reason to pursue this. Be sure to give the provider good, specific information as you have given me. If possible, even starting a bowel journal (I know it sounds weird, but trust me , it s valuable information for diagnosticians) keeping...

Multiple Sclerosis: History and question, mega cisterna magna, freshmen year
mega cisterna magna, freshmen year, dizzy light: Hi Stephanie, WOW. It really sounds like you have been through a lot. Good for you in being persistent and seeking answers to these events. I would like to respond to several aspects of your question. Many of the symptoms and experiences you describe sound...

Multiple Sclerosis: Muscle weakness/twitching, good shape, muscle weakness
good shape, muscle weakness, left leg: The best description that differentiates these two is what YOU feel vs. what SOMEONE ELSE feels. For example, you said you tried seeing the amount of weight you can use with your legs , and you are absolutely correct, without a baseline to start from...

Multiple Sclerosis: ms, als genetics, amyotrophic lateral sclerosis, amyotrophic lateral sclerosis als
amyotrophic lateral sclerosis, amyotrophic lateral sclerosis als, disability increases: Hello there, I will give you a very brief and general answer to your question ,as i am not an immunologist or geneticist and cannot comment on the possibility of a connection to MS and ALS. Multiple sclerosis (MS) is believed to be an autoimmune disorder...

Multiple Sclerosis: My Sister And MS, swallowing
swallowing: Hi Angie, ABSOLUTELY this could be a MS related problem, especially for someone who has lived with the disease for 20 years. It sounds like, from what you describe, your sister is having a problem with dysphagia, or difficulty swallowing. The process of...

Multiple Sclerosis: Violence a symptom of MS?, temper tantrums, brain circuits
temper tantrums, brain circuits, james bowen: Hi Leslie, I appreciate the time you have taken to get some answers for this very difficult situation. I imagine it is incredibly stressful for you to experience these sorts of behavior, especially from a sibling. Your question relates to the relationship...

Multiple Sclerosis: complex sxs, mitochondrial myopathy, brisk reflexes
mitochondrial myopathy, brisk reflexes, muscle biopsy: Sounds like it is time to repeat the MRI and LP again. It was a long time ago, and we follow our MS patients with MRI once a year. Try to find a facility that has a Tesla 3 unit, the best there is. Also with and without contrast. Also I wonder if there would...

Multiple Sclerosis: eyes, optic neuritis symptoms, noticeable vision loss
optic neuritis symptoms, noticeable vision loss, exercise vision: Hi Andrea, with the usual disclaimer that I am not a diagnostician, I can say that with the experience of working with many patients with optic neuritis that this doesn t sound like what I usually see. Optic neuritis usually affects one eye, although it may...

Multiple Sclerosis: Could I have MS, multiple sclerosis society, national multiple sclerosis society
multiple sclerosis society, national multiple sclerosis society, national multiple sclerosis: Hi Mackenzie, wow it really sounds like you have had a LOT going in! How difficult it must be to have all of these things happen and not have a clear-cut answer for what is causing it. You are absolutely doing the right thing in enlisting the help from professional...

Multiple Sclerosis: could it be ms, chest x rays, multiple sclerosis society
chest x rays, multiple sclerosis society, vitamin d deficiency: Hi again Brittney, I am glad to hear you have a MRI scheduled, along with a follow up appointment. It is important to keep track of these symptoms and questions, and also you should feel free to call your doctors office at any time and ask to speak to a nurse...

Multiple Sclerosis: MS Diagnosis and Asberger's, autism spectrum disorder, auditory signals
autism spectrum disorder, auditory signals, electrical arc: Hello Wade, Thank you for this interesting question, and I can imagine it is very frustrating to seek diagnostic advice and not have a provider focus on your concern. What you have described as obstacles to effective one-on-one communication with providers...

Multiple Sclerosis: ms-peripheral neuropathy, peripheral neuropathy, peripheral nerves
peripheral neuropathy, peripheral nerves, knee cap: Hi Chris, thank you for this interesting question. Please don t ever feel I am too busy and you must be brief...I love what I do, and donation of my time is something that is very enjoyable for me! For the benefit of those reading this question who are...

Multiple Sclerosis: falling over to right side in wheelchair, electric wheelchair, reclined position
electric wheelchair, reclined position, bowel dysfunction: I spoke with our Physical Medicine MD here in Seattle, and she recommended Dr. J. Han (or any of his colleagues) at UC Davis. Below is the contact info: Location: UC Davis Department of Physical Medicine and Rehabilitation Mailing address: ...

Multiple Sclerosis: question, definitive tests, hamstrings
definitive tests, hamstrings, muscle weakness: Hi Andrea and thank you for your question! I appreciate your honesty regarding being an anxious/stressed person! It helps me to know this about you to make sure I address your question thoroughly! If a personal trainer advised you that your quads and hamstrings...

Multiple Sclerosis: MS - Numbness in left hand, numbness in left hand, ms relapses
numbness in left hand, ms relapses, intravenous steroids: The itching (pruritus) he has in the left hand can most definitely be a symptom of his MS as well. It is one of the family of abnormal sensations—such as “pins and needles” and burning, —which may be experienced by people with MS. These sensations are known...

Multiple Sclerosis: MS? Thanks in advance, mood swings depression, lesion load
mood swings depression, lesion load, extreme fatigue: Thank-you for your question. I am pleased that you have made an appointment to see a neurologist,as I think your history paired along with a thorough neurological exam will give much insight into the possible causes of your symptoms.The abnormal visual evoked...

Multiple Sclerosis: Does it sound like MS?, mood swings depression, extreme fatigue
mood swings depression, extreme fatigue, vision test: Hi L, Yes, the symptoms you are experiencing sound a lot like M/S. However, I am not a Medical Doctor. (I am speaking of my personal experience/knowledge when it comes to M/S.) I am very happy you are going to see a Neurologist. That is very important!...

Multiple Sclerosis: EEG test, nonspecific abnormality, eeg test
nonspecific abnormality, eeg test, vertigo problems: Hi Lise, The best I can say with the information you provided is that the provider who ordered the EEG is really the best person to interpret any findings. If you read through some of my previous responses to others, you will learn that one of the standards...

Multiple Sclerosis: peripheral neuropathy or ms?, peripheral neuropathy, jot down
peripheral neuropathy, jot down, neuropathy symptoms: Hi Lori, You are very wise to go see a Neurologist. I m not a Medical Doctor so I really couldn t honestly answer your question. I would jot down all of your questions/concerns before going to meet your Neurologist. That way there won t be a question...

Multiple Sclerosis: MS?, personal life experiences, liver levels
personal life experiences, liver levels, pins and needles: Hi Scott, I m glad you had a brain MRI done and no masses and/or lesions were noted. That is GREAT news! Please remember that I m not in the medical field nor have I ever been. My responses to the folks asking my opinion and/or advise comes from my own...

Multiple Sclerosis: MS, brain lesions, sore joints
brain lesions, sore joints, exrays: Hi Michelle, There is an excellent web site pertaining to Multiple Sclerosis. It is: http://www.everydayheath.com. I am not a medical doctor so it is difficult for me to answer your questions. I suggest you contact a Neurologist and discuss how...

Multiple Sclerosis: ms now maybe, numb lips, desk job
numb lips, desk job, center chest: Hello Matt, Having negative results for an MRI isn t unusual. I have heard that happens more than not! You should contact your Neurologist and tell him/her your concerns and how you are feeling. If he/she doesn t show you immediate attention, I would...

Multiple Sclerosis: i am getting worried, pins and needles, brain mri
pins and needles, brain mri, extreme fatigue: Hi Sarah, There is some excellent information regarding M/S on the site http://www.everydayhealth.com I am not a medical doctor; therefore, I couldn t honestly answer your question if it is possible to have M/S and show a clear brain MRI. I would talk...

Multiple Sclerosis: Hello, multiple sclorosis, balance problem
multiple sclorosis, balance problem, kindest regards: Hello Jairo, Make an appointment with your doctor and discuss with him/her your symptoms. A good idea is take notes (document the date and time you experience these symptoms); that way you can advise him/her. Mention to him/her that you would like to...

Multiple Sclerosis: MS, marian cox, short memory
marian cox, short memory, balance problems: Hello Marian, First of all, I too, have M/S. I was diagnosed in 2005; so I can totally understand your concern. From my own experience, I have had numbness along with different parts of my body feeling tingly. In 2007, my speech became very slurred;...

Multiple Sclerosis: Please help me, regarding MS., generalized anxiety disorder, upper cervical spine
generalized anxiety disorder, upper cervical spine, human sole: Hi Dylan, The symptoms you are experiencing could be caused by stress and/or medication; you mentioned you experienced a flare-up when you were returning to school after the Christmas break which no doubt caused you some anxiety. I m very happy...

Multiple Sclerosis: Wanting to start a non-profit organization to help people with major illnesses!, private insurance companies, blue cross blue shield
private insurance companies, blue cross blue shield, healthcare world: Hi Keri, Medications for MS differ per person; i.e., depending on when they were diagnosed and what their Neurologist recommends. I am on Medicare and AARP. Co-payments differ depending on the medication and how often it is taken by the individual. ...

Multiple Sclerosis: ms
Hello Martha, As I said earlier (in my last response to you), I don t have the problem of excessive urinating; however, I know it is not unusual for lots of people. I would avoid drinking anything a couple of hours before you go to bed. When you do...

Multiple Sclerosis: ms and scared
Hello Martha, Make sure you bring your urinating problem to your Doctor s attention and tell him/her you need something to take. He/she will be able to prescribe a med to you for this issue. (Personally, I haven t had this problem, but I know it is not...

Multiple Sclerosis: Looking for some help
Hello Stefanie, I m sorry you are going through this! It sounds like no one is taking your concerns seriously and that really concerns me. Waiting seven Months for an MRI is unacceptable and the Neurologist and your GP have no right to second guess you!...

Multiple Sclerosis: like to talk, barre syndrome, mild cases
barre syndrome, mild cases, guillain barre: Hello Anas, You should make an appointment with your Doctor and let him/her know the symptoms you are experiencing. I m sure he/she would suggest you getting an MRI. I know this is very scary, however, the sooner you know, the quicker you can start treatment....

Multiple Sclerosis: Mri no contrast brain, angiography of the brain, lateral ventricle
angiography of the brain, lateral ventricle, matter lesions: Hello Mark, Perhaps I m not understanding your post; you have had several scans and they have came back normal; however, you had an MRI a week ago and you got the results today and it was not normal. That doesn t make any sense to me. First of all, your...

Multiple Sclerosis: ??ms??, reebok sneakers, leg exercises
reebok sneakers, leg exercises, painful experience: Hello Carol, If you can t afford to go to the doctor, go to your local ER. They have to treat you. No one is supposed to be turned down in the ER because of no Insurance or mot having the money to pay. You really need to get X-rays taken and go from...

Multiple Sclerosis: concerned, neurologist, multiple sclerosis
neurologist, multiple sclerosis, 17 years: Hello Porsher, There is no medical proof that Multiple Sclerosis is hereditary. Unless you have symptoms that are causing you to be concerned, I wouldn t worry about it. However, to make yourself feel at ease, talk to a Neurologist and have some tests taken....

Multiple Sclerosis: Ms?, bladder problem, emergency appointment
bladder problem, emergency appointment, legs feet: Hello Martha, No, not at first did I experience burning,tingling or numbness. However, as time past, I began experiencing these symptoms. That is why it is so important you see a Neurologist and have a complete MRI done. Depending on the State you...

Multiple Sclerosis: ms, medical card, neurologists
medical card, neurologists, neurologist: HI Martha, I have Medicare, so that is different from Medical. You might call you local Medical office and check. There telephone number should be on your Medical card or in your local telephone book. Please rate my response. Kindest rgards, ...

Multiple Sclerosis: Brain, centrum semiovale, matter lesions
centrum semiovale, matter lesions, cold sensation: Hello Mark, I would make an appointment with a Fibromyalgia Specialist and discuss this situation with him/her and tell him/her that you are concerned you may have Multiple Sclerosis. As to your question; do I think your symptoms may be an M/S case?...

Multiple Sclerosis: MS, tongue numbness, crp blood
tongue numbness, crp blood, low wbc: Hello Mark, I would make another appointment with your Neurologist and DEMAND some answers. Tell him/her you want to know what you have and what you can do. It is your life and you are the one that who will have to deal with whatever you have. I m not...

Multiple Sclerosis: my left hand & left leg is trembling from 2 days., stiff neck, trembling hands
stiff neck, trembling hands, left leg: Hello Amit; I can certainly understand your concern regarding the symptoms you have been experiencing. The best advice I can give you is to try and take a deep breath, slow down and not worry so much about this matter. Wait until you are seen by your...

Multiple Sclerosis: MS or Anxiety
Hello Lou, While MS has the potential to cause several different symptoms, the specific symptoms each person experiences vary greatly. When experiencing one or more of these symptoms, an individual should consult his or her physician, medications are available...

Multiple Sclerosis: symptoms
Hello Dave, A few common symptoms of M/S are: Fatigue, visual disturbances, cognitive dysfunction, sensory problems/pain, spasticity, depression dizziness/vertigo, bladder/bowel dysfunction, gait impairment, speech/swallowing problems, tremor, sexual dysfunction,...

Multiple Sclerosis: BULLYING
Hello Courtney, I apologize for taking so much time answering your questions regarding bullying; I had problems with my Internet connection and was unable to log on and/or answer any emails. Q: What should a school or parent watch out for in a child s...

Mt. Ranier NP: Climbing Mt Ranier, mt ranier, rainier mountaineering
mt ranier, rainier mountaineering, winter storms: Hi Chris, Sept to Dec would not be an ideal time to climb the mountain as this is the winter season and the mountain is more prone to severe winter storms and weather. Not that it could not be done, and many people do make the climb, however not near as...

Mt. Ranier NP: camping sites, cougar rock, water toilets
cougar rock, water toilets, rollar blades: Hello, I am sorry for the long delay in getting back with you I have tried two times prior only to be kicked off the WWW portal. However All esperts has fixed the problem. There are six auto campgrounds in the park with 600 sites. Reservations are required...

Mt. Ranier NP: Guided climb on Mt Rainier, dee molenaar, rainier mountaineering
dee molenaar, rainier mountaineering, popular mountain: Robert, I think that is a great idea to take your 13 year old son on a climbing trip. You will have to judge you son and his determination, maturity and fear level. I wish more father s would spend time like that with their son s. One of the best guiding...

Mt. Ranier NP: Mountain Conditions, rainier mountaineering, average snowfall
rainier mountaineering, average snowfall, strange weather: Dear Aspiring Mountaineer, I can t be certain but I would think that during the warm summer season from May to Sept that the climbing conditions would not vary a great deal based on the dry season this past year. I would think you could go either early...

Mt. Ranier NP: Mt. Rainier Park, national weather service, snow storms
national weather service, snow storms, road conditions: Yes the park is open all year. However the roads during the winter months may be closed from time to time due to snow storms. Check with the National Weather service to check road conditions for the area, or call the park service during the Winter months....

Mt. Ranier NP: Mt. Rainier, sunshine point, answer man
sunshine point, answer man, snow conditions: Dear Jean, The opening of the campgrounds can vary each year depending on the snow conditions but generally Ipsut Creek is open year round, as is Sunshine Point. The others tend to open in late June or July. I hope you have a great time. Your Rainier...

Mt. Ranier NP: Visiting Seattle, visiting seattle, olympic national park
visiting seattle, olympic national park, rain gear: Dear Bill, You might want to consider Olympic National Park. It has beautiful monutains and is the only place in the US that has a Rain Forest. It has mild winters in the lower elevations (besure you bring your rain gear and layered clothing) and can get...

Mules: Weaning donkies, nurse babies, happy trails
nurse babies, happy trails, opportunists: Carolyn, Your jenny will continue to make milk as long as these titty babies continue to nurse. I ve always weaned my mule babies around 4 months, especially the boys. I had a yearling mule consider nursing his mom when, at a year, he was put back in...

Mules: Use of Mule in Mounted Patrol, saddle mule, mules
Mules: Use of Mule in Mounted Patrol, saddle mule, mules, kentucky horse park

Mules: New Mule, russian horses, race horses
russian horses, race horses, feed hay: She s a bully! And, she is a complete savage. Her universe revolves around her and her lack of manners. She has to become totally dependent on you for everything before she respects you. Take away all free feed, hay and water. She only get those basics...

Mules: Use of Mule in Mounted Patrol, texas peace officer, mules
texas peace officer, mules, mule: The Dallas, Texas mounted patrol used one of our mules during the state fair parade twice. Just for fun though. Our mule had been used in the round pen with colts so he was certainly safe in crowds and didn t mind pushing and my husband could shoot off him....

Mules: donkey life span, average life span, age expectancy
average life span, age expectancy, vet care: My donkey is 25 years old, but I m sure their age expectancy is as varied as they are. I would think that if a donkey is taken care of and given the best vet care, it s possible to live to late teens. I m not sure about association with camels. But, I...

Mules: She's our first donkey, bad weather, donk
bad weather, donk, first experience: Just a follow up...........if you should get Emily a donkey companion be sure and get her a girlfriend. Don t get her a donkey jack for a friend. A bigger one can hurt her or you. And, handling jacks, any size, takes experiences. *********************************************************************...

Mules: hoof problem, coffin bone, surgical nurse
coffin bone, surgical nurse, sticky material: I would make a arrangements for your donkey to be evaluated by a vet. If this is founder, indicated by her gait, it certainly can cause rotation of the coffin bone and can threaten your donkey s soundness and thus her life. Remember.................no...

Mules: breeding, mules, mule
mules, mule, surrogate: While infertile, an unaltered mule will breed. That is why male mules are always gelded. Female mules have estrus cycles and sometimes are spayed. Having said that, it is unlikely that there will be any produce of this breeding as, with few exceptions,...

Mules: Donkey Foal, donkey foal, female donkey
donkey foal, female donkey, bermuda grass: Congratulations on the wee one! They are sooooooooo adorable! A) when is it a good time to let them all be together again. I d wait until the baby is a couple months just to be sure. But, if you see the girls getting along, by all means, follow your...

Mules: Donkey, herd of cows, sheep goats
herd of cows, sheep goats, predator control: As I said in my letter I have a donkey..not a mule. Cheryl, I don t understand. I answered for jack donkeys. Male mules are referred to Johns. Our donkey is a great overseer of the cattle..Why only one donkey? Why a Jenny instead of a Jack for Predator...

Mules: Donkey, donkeys, herd
Mules: Donkey, donkeys, herd, farming

Mules: Bumps on my mules skin, draft mule, insects bites
draft mule, insects bites, tb mare: Deborah, You ve got me! You didn t say where you lived, but could it be from insects? Bites? Mites? Some insects leave larvae to grow under the skin. I m not familiar with all your treatments, but, did some attack fungus? Seems to me, you...

Mules: Bumps on my mules skin, andalucia spain, animal surgery
Mules: Bumps on my mules skin, andalucia spain, animal surgery, cattle farms

Mules: Mules vs. horse, pat parelli, mules
Mules: Mules vs. horse, pat parelli, mules, good luck

Mules: Mules vs. horse, herd behavior, long periods of time
herd behavior, long periods of time, horse legs: Remember each mule is different depending on how much horse he inherits and how much donkey he inherits. Having said that: 1. They appear smarter than horses because the donkey is not a flight animal. Donkeys stay and fight rather than flee. Consequently,...

Mules: donkey behavior, walking in circles, behavior question
walking in circles, behavior question, clean slate: Yes, stop him from following you with his ears pinned and his head low. Soon he ll be nipping at you. The whip is a great idea. Use it across his front knees like his mother would nip him. If, however, at all possible, since he s engaging in this behvior,...

Mules: Molly mule, temper tantrum, fence line
temper tantrum, fence line, qh: Give her sometime to settle in before you identify this a problem. Most mules have an affinity for horses since mom was one. She s worried about being left in her new surroundings. (She doesn t care if you take her away and leave the QH alone.) If you...

Mules: need help with my new mule, trust level, mules
trust level, mules, group of horses: At fifteen, you may not be able to reform this behavior. Unfortunately, many mules develop this bad herd habit. You might try riding with just one person for awhile to get him use to a small group. Eventually, ride farther and farther either behind...

Mules: mule doesn't like goats or dogs, stock panels, small stock
stock panels, small stock, kittens: Mules are not generous with young and/or small animals. Since your mule has exhibited these tendencies, I d keep her away from all young and/or small stock. Those mules so inclinded can and will kill another animal. Our mule Bubba can go through a litter...

Mules: Our new Donkey, mare in foal, foam sword
mare in foal, foam sword, plastic bat: You are doing the right discipline for now. His mom would bite or kick him on the lower leg to get him to settle down. You can use a little riding crop if you think he needs a little sting. A wiffle ball bat makes noise to surprise him. And, when he acts...

Mules: mule killing baby goat, baby goat, predator control
baby goat, predator control, kittens: Mules are notorious for attacking young stock. I can t tell you why, but I have horses that have done the same thing. One of our mules can go through a litter of kittens with six stomps. And, I doubt he ll ever stop. Yet, his half brother is the weanlings...

Mules: donkey, sheep and goats, dairy ration
sheep and goats, dairy ration, apear: Ooops. Your girl has a fat roll. It s quite common in donkeys and will probably be there forever. If your farrier does not think she has foundered, then she probably has not. BUT, the roll can be become so big it will fall over if you do not restrict...

Mules: Lost mule, case move, farrier
case move, farrier, search and rescue: I m so sorry. Mules are not easy to kidnap. She may have let herself out. In either case, move NOW. Photos, Photos, Photos. Put them up at your local stores, veterinarians, gas stations, boarding barns, anywhere you can think of. And, do it...

Mules: Miniature Donkeys in foal, miniature donkeys, many a night
miniature donkeys, many a night, active one: Since you do not know the breeding date, you are doing the right thing observing their behavior. I wish I could help you more. I know your frustration. Mother Nature and the baby are in complete control. There s been many a night I ve sat up with the...

Mules: Mixing mules & donkeys, mammoth donkey, horse gelding
mammoth donkey, horse gelding, mammoth donkeys: Horse mules are notorious for running other animals to death. Mine were pastured with a Mammoth donkey gelding and he could never really keep his own with them. And, he was a jack for 8 years before gelding and sire to some of the mules. Donkey s are...

Mules: mini donkey... and my horse, mini donkey, young stud
mini donkey, young stud, mare: Any equine whom you do not intend to breed should be gelded. It will make him a better companion for your mare and you. Just because he s a mini does not mean his testosterone is mini also. I ve seen mini jacks and stallions be just as dangerous as large...

Mules: breeding mules, male donkey, female donkey
male donkey, female donkey, number of chromosomes: Mules, while sterile, will breed. However, rarely have they produced offspring. Horse mules are always gelded. Jack..........male donkey Jennet........female donkey Stallion......male horse Mare..........female horse Horse Mule....male mule Mare...

Mules: Ground Manner for Donkey, rain rot, ground manners
rain rot, ground manners, sloughs off: Get another farrier. Donkeys are the easiest of the equine to train. Just begin to do the things that she s never experienced and she ll soon learn there is nothing to be afraid of. Halter her. Take her temperature. Pick up her feet and pat on them....

Mules: introducing ungelded jack, angora goat, solitary animals
angora goat, solitary animals, gelding horse: No there are no exceptions to the rule with jacks. Sorry. It can happen in a split second without warning. I would keep him separated from your gelding and your goats. I would also have him gelded and then let him live with others and enjoy their company....

Mules: mule from dry lot on pasture, lush pasture, grass hay
Mules: mule from dry lot on pasture, lush pasture, grass hay, short grass

Mules: mule from dry lot on pasture, pasture, last nite
pasture, last nite, mule: I m sure your mule will be fine on pasture without supplements. If, however, your pasture is lush, be sure to watch for changes in the fat along the neck. If you see any crustiness, large fat deposits along the mane, remove your mule from pasture and dry...

Mules: Donkey Handling, donkey shelter, farrier work
donkey shelter, farrier work, positive reinforcements: I m not defending any abuse of donkeys or mules. However, if a donkey in a herd was being difficult, they would get kicked by the other animals as a punishment. So the farrier is adopting a herd discipline. Of course, one kick is usually sufficient...

Mules: mule height, cannon bone, hairline
cannon bone, hairline, zorro: The best indicator I have found is to measure the cannon bone from the hairline to the middle of the knee. Whatever inches you get, that will be hands. The fraction of an inch is a toss up. i.e. Zorro s cannon was 16.1 inches at two days. He grew to...

Mules: mule shots, tetanus shot, baby teeth
tetanus shot, baby teeth, crupper: Carol, you are doing everything right. You just need lots more time. And, yes he is training you and getting everything on his terms, but that s a mule. You ll have to outsmart him. Is he gelded? If not do so. Next, most mules are not fond of needles,...

Mules: aging mule, vet check, mule
vet check, mule, respiration: He ll let you know when he s had enough. Look for lameness, respiration recovery, reluctance to be saddled, etc. Do a complete vet check once a year. I ll bet this guy has many more years to share with you in the mountains. Let me know how he does...

Mules: get mule to gait, gaited mules, gaited mare
gaited mules, gaited mare, weighted shoes: If you find that your mule has a natural running walk, single foot or other quick walk, you might be able to enhance it with weighted shoes. However, I would suggest that you get help from a person who trains gaited mules or horses as they will be able to...

Mules: pregnat donkeys, herd animal, jennet
herd animal, jennet, jennies: If you intend to keep a jack and jennets, you must separate them. A jack will breed a pregnant jennet until she aborts bringing her in heat so he can breed her and/or is likely to kill any foal she has. Jacks are my favorite animal, however, having said...

Mules: Trailering Mule, hocks, halters
hocks, halters, mule: First make sure she s learned how to back. If she doesn t understand that command, it s useless to ask her to enter a trailer she has to back out of. It s like teaching a child to divide......he has to know how to multiply first. Then............. ...

Mules: Molly Heat Cycles, dressage clinic, heat cycles
Mules: Molly Heat Cycles, dressage clinic, heat cycles, face book

Mules: Molly Heat Cycles, molly mules, heat cycles
molly mules, heat cycles, heat cycle: It depends on your mule. One of my mollies I NEVER saw come into heat and neither did the trainer. The other, comes in like a horse. I prefer geldings so those were the only two mollies I kept. Since she is soooooooo into her heat cycle, you might wait...

Mules: Mule will not stay in any fence, dull moment, mules
dull moment, mules, companionship: Well.............. You ve just learned an important lesson about the tenacity of mules.:) Does the molly have other horses to be with? It would help for her to have a companion where she lives. But, allowing her to never be weaned from mom for three...

Mules: molly in heat ?, mollies, molly
mollies, molly, vet: Mollies show differently than horses. Some mollies will demonstrate very noticeable signs and some none. I ve had both. So there is no NORMAL for them. It s up to us to interpret their signs. Sigh! If you ve noticed blood in her urine, it may be nothing,...

Mules: My Donkey, foam sword, playful baby
foam sword, playful baby, baby behavior: He sounds like he s being a little toot! They are playful and are rough in their play. Having said that, the behavior also sounds like an adolescent male. If your vet did not geld him, talk to the vet who did and make sure that he did not have a retained...

Mules: grooming clipping, mane and tail, manes
mane and tail, manes, mules: I would suggest you go to www.nasma.net. There will be some photos of mules and donkeys and the differant way they can be clipped. I usually roach their manes and on the horse mules shave about 2 inches at the dock of the tail. On the mare mules, I just...

Mules: Horses and mules or donkeys, baby lambs, pecking order
baby lambs, pecking order, mules: Mine are always together. No problems. When first introduced, they may engage in the same pecking order rituals that a pasture of only horses will go through. But, generally, the horse ends up on top. (After all, the mule s mom was a horse so they give...

Mules: riding age, horse grain, grass hay
horse grain, grass hay, protein content: Mules knees tend to close at three years old. However, each is an individual so only x-rays can tell you for sure. Having said that, at 2 a mule certainly could carry you and the saddle for light riding. Just remember, intense training which takes a...

Mules: DONKEY DISPOSITION, herd leader, herd animals
herd leader, herd animals, herd animal: Donkeys don t seem to develop that buddy behavior. They always seem enjoy the company of the human they are will and generally are eager to go off from their friends. (Exception might be an in tact jack with testosterone issues.) Actually, I don t think...

Mules: Mules and Water/Ditches, feed bucket, hinny
feed bucket, hinny, looksee: I d always do it on her back. Start with easy at home. Develop a command for one step at a time. Then use that as you approach your water obstacle so she knows that vaulting across is not on the agenda. She may jump the first couple of times, but...

Mules: do mules spook, flight instinct, mules
flight instinct, mules, mule: It s been my experience that mules do spook and are wary of certain things. The difference I see between the two equine, is that mules may spook, but their flight instinct doesn t take over. Instead, they try to figure out the danger before they commit into...

Mules: kicking and biting, anyting, growing pains
anyting, growing pains, toot: Ah, yes. She has the terrible ten month old syndrome! She s just being a toot because she can. And, your inclination on how to handle her is correct. But, first, make her jealous by paying lots of attention to another animal. When she comes over swish...

Mules: mule/donkey breeding, male donkey, best bet
male donkey, best bet, equine: They won t produce, but may breed. If you want a guardian, you need to get a donkey jenny and let her run with your sheep as if it were her herd. She needs to be alone with the sheep or she will prefer the company of another equine and not stay with your...

Mules: Gaited Mules, gaited mules, gaited mule
gaited mules, gaited mule, mule association: While mules usually inherit their way of going from their dam, not all mules out of gaited mares will do so. The only way you will know for sure is when you get them under saddle. Make sure who ever starts your mules knows how to train gaited horses. ...

Mules: jenny born 1-3-11, jennies, rear ends
jennies, rear ends, neutering: Well, I think one of your jacks (if no other donkey got in your pasture) has a retrained testicle which was not removed when he was cut. If all of them have been together for three years and no recently castrated jack has been allowed to run with them, that...

Mules: Our Mule Stretches her head out laying ears back when I 'm around her with other equine., shoe nail, horse shoe
shoe nail, horse shoe, riding crop: I m sure she ll bite but not because she s being mean, just because she s being silly. If you don t nip it the bud, it will end in a bite. Don t back up. Stand your ground. Two things I used to stop this is: 1. Have your farrier make a ring for you...

Mules: mule colt or pony colt?, stud colt, miniature mare
stud colt, miniature mare, shetland ponies: How cute! Either mule or horse, he s adorable. He looks like a horse to me, but you can measure his ears now. What ever their measurement now, should be close to their s at maturity. If his ears are no bigger than mom s, bet he is a horse. If they are...

Mules: how to train your mule, mules and more magazine, beautiful head
mules and more magazine, beautiful head, bedroom window: Oh dear! I would suggest you get professional help. Mules haven t read the books and so they don t usually act the way the book says they should. You really need hands on help. Clarice (beautiful head, by the way) should be at a trainer who can help...

Mules: miniature donkey behavior, miniature donkey, baby jenny
miniature donkey, baby jenny, little donkey: DO NOT PUT THEM TOGETHER. The jack can and will kill the foal if he feels it is a threat to his passing on his gene pool. The mother may try to protect the baby, but a jack s furry, not matter his size, may be too much for her to fight leaving the foal...

Mules: best animal option, hoss cartwright, saddle mule
hoss cartwright, saddle mule, tennessee walking horse: I would not suggest a mule, but I would suggest either a Tennessee Walking Horse or a Spotted Saddle Horse. With a mule, I would suggest that it will need much more attention than one or two days a week. Your weight is not a problem for a big horse or big...

Mules: mules, sheep dogs, dogs cats
sheep dogs, dogs cats, baby beef: The donkey, your mule s parent, is not a flight animal and will attack and fight a predator. The horse, also your mule s parent, is a flight animal and will run with the herd for safety. The mule tends to inherit the stand your ground approach and will...

Mules: Mules
John mules are known for killing small stock. Keep him away from them since he has already shown an inclination to do so. The donkey side of him is responsible for this since donkeys fight rather than flee. His spooky behavior can be dealt with by having...

Mules: Breeding gaited mules from Paso Finos, time world champion, likelihood of pregnancy
time world champion, likelihood of pregnancy, gaited mules: Yes, Paso Fino mules are very popular in Brazil. And, being very hardwired, their gaits generally are inherited to some degree in the mules. I am not familiar with the trocha gait. The problem will not be ovulation, but if your stallion finds her...

Mules: Breeding hinnies, endurance races, racing time
endurance races, racing time, hinny: In regard to the breeding, I would not put the foal into the pasture with your stallion. You never know what the stallion will do and Mom is no match for him. You would be heartbroken if something happened. I d put the foal up safely with the other...

Mules: dangerous, expertese, mules
expertese, mules, mule: I have no statistics in regard to your question. I m sure there a few. I ve heard of two. Neither was caused by the mule or donkey, but the negligence of the handler. If you are implying that mules and donkeys are more dangerous than any other equine,...

Mules: docility, cold bloods, warm bloods
cold bloods, warm bloods, draft breeds: John mules are always gelded so that they will be more docile than a stud. However, the geldings tend to grow up much later than the girls. The old timers preferred the mare mules because they said they were more tractable. I prefer the John geldings because...

Mules: donkey hoof, skin cells, qh
skin cells, qh, frogs: Equine shed their frogs just like we shed skin cells. After it the old one is shed, a new one will grow to replace it. The frog, as it hits ground, creates the circulation for blood in the foot. If she s a little sensitive, it might be that until the new...

Mules: donkeys, spring grass, grass hay
spring grass, grass hay, straight legs: Depending on what you expect your donkeys to do, you can feed them any good equine grain your feed store carries. Keep in mind that they are a desert type animal and have, over the eons, developed the ability to get by on much less than a horse. If they...

Mules: gaited mules, gaited horse breeds, mule foals
gaited horse breeds, mule foals, gaited mules: There are a number of gaited horse breeds which you can use. It depends on what kind of gait you want your mule to have. There are Walking Horses, Foxtrotters, Pasos, Spotted Saddle Horses........................ There is no one good breed, but there is...

Mules: loading a donkey, vocalizations, busy bee
vocalizations, busy bee, donk: Ah. Yes, the enjoyment of loading a donkey. Everyone has had the problem with their donk. Your standard and my Mammoth are a little heavy for manhandling and carrying in. And when a donkey makes up his mind an act of Congress is not going to change his...

Mules: loading on a trailer, mini donkey, time deal
mini donkey, time deal, short trips: Sorry I didn t get to answer your question immediately. I had the same problem with one of my donkeys in traveling to the show. He was very nervous in the trailer, broke out in a sweat and came out dripping wet, but, while at the show, he was just fine....

Mules: mule identification, saddle mule, mule association
saddle mule, mule association, jaw bone: Sometimes it is difficult to see the difference, especially when only looking at one at a time. Side by side, it s easier. You might go to my website and look at my donkey and mules. Another good website is www.nasma.net of the North American Saddle Mule...

Mules: mule, time and patience, abusive treatment
time and patience, abusive treatment, mule: Time and patience will be required to get Henry to trust you. Be very careful when around Henry not to make quick movements, but be slow and deliberate when trying to touch his head. Never, jerk or hurt him when he allows you to pet him on the face and head....

Mules: Ringworm, cattle shows, definite diagnosis
cattle shows, definite diagnosis, soapy water: Mules are subject to the same dermatitis problems that all equine are. Because it is a fungus, Ringworm, presents a number of concerns. It’s always best to contact your veterinarian for a definite diagnosis before treating any skin problems. This is not...

Mules: How much running is too much for donkey foal?, donkey foal, dam sire
donkey foal, dam sire, hills forest: I think you a great Mom! Everything you are doing is exactly what I would do. Two weeks is REALLY young. Maybe when she s a little older you will feel more comfortable with her play. Keep up the good work! Your instincts are great. I know you ll...

Mules: How tall will my mule filly grow?, tennessee walking horse, cannon bone
tennessee walking horse, cannon bone, mental maturity: On the day they are born, you can measure the length of the cannon bone from the mid knee to the top of the hoof. Zorro s cannon bone was 16.1 and he grew to 16.2 hands. It s worked for all my mules. The cannon bone does not grow an longer and their ears...

Multimedia Sound: media players-winamp, google search, miro program
google search, miro program, winamp player: You answered your own question regarding winamp - it is most likely a codec. Check the program for any log files or logs of errors. Sometimes information like that can be found in the install directory. It will also help to make sure your system is updated...

Multimedia Sound: Choosing a set of headphones, sennheiser hd 201, sennheiser hd 650
sennheiser hd 201, sennheiser hd 650, sennheiser hd 280 pro: Hi, Sennheiser, AKG, Grado, or Koss. Sennheiser is perhaps the best out there - and most expensive. AKG is a close second. Grado is more practical, including for the uses with which you are seeking. Koss is a little over-rated in my opinion but is still...

Multimedia Sound: external speakers, metal fibers, lumber yard
metal fibers, lumber yard, size quarter: Hi, I m assuming by mini jack you mean 1/8th inch, the smaller size (quarter inch being the larger). I recommend you stop by a local electronics store, such as Radio Shack or Circuit City, and ask if they have a wire that has 1/8th inch on one side and...

Multimedia Sound: Music on CD's, channel 1, channel 2
Multimedia Sound: Music on CD's, channel 1, channel 2, separate entities

Multimedia Sound: Media Player image stops for a few seconds, tug o war, audio codecs
tug o war, audio codecs, player image: Hello, The cause could be either a live streaming video from the internet (lag issues), a large file that is playing tug-o -war with your computer, your computer playing tug-o -war with itself, or if none of the above possibly it is a bad (corrupt) file....

Multimedia Sound: MP3 editing, google search, search criterion
google search, search criterion, term shareware: Hi, The number one software that I use at present for such things is Soung Forge . It s not free, unfortunately, unless you want to get a bootleg copy, which I do not recommend. There is freeware, or at least short-term shareware (i.e., 30 days), software...

Multimedia Sound: Music on CD's, extreme temperatures, vinyl to cd
extreme temperatures, vinyl to cd, type music: Hello, Thank you for writing. There are a few steps you can take in finding out what the possible causes of the poor quality sound might be. Consider everything involved: the CD itself, when the performance was recorded, any possible mention in the liner...

Multimedia Sound: music files for website, digital rights management, hosting marketing
digital rights management, hosting marketing, creating a website: Right, i think i understand what you re asking and i must say you re touching on something that can t be answered with a straight forward response...anyhow, lets take this one step at a time... First, are you really sure you want to distribute your music...

Multimedia Sound: Omline music, sound engineering, streaming audio
sound engineering, streaming audio, shout: Hey Michael good choice by the way...i ve been into streaming and multimedia audio for about 7 years now and there isn t all that available that focuses just on the audio element. First question, where are you? Second question, do you think a course...

Multimedia Sound: recording vinyl records into mpeg3 format onto a computer., cables rca, internet radio station
cables rca, internet radio station, drive memory: Hey Dave could you tell me what computer gear you have, aswell as equipment like mixers, decks, and most importantly your sound card...it would be useful to know budget aswell and whether you could go without vinyl for a short time to add more money to...

Multimedia Sound: Shooting a video - I want..., shotgun mic, radio mics
shotgun mic, radio mics, budget stretch: Hi there do you still need help with this? if so, then my only piece of advice is don t use the method you described above. Sound recording for film is difficult enough even when you have professional equipment, especially when using radio mics, is there...

Multimedia Sound: sound effects/ ringtones, sound effects, best of luck
sound effects, best of luck, service provider: Hi, Yes and no. There are some phones that will allow for that while others unfortunately will not. The phones that do work with that often times have software, or at least that which you can purchase separately, that you install on your computer. On those...

Multimedia Sound: When did speeding up music without changing the pitch become available to recording studios?, digital sampling, low fidelity
digital sampling, low fidelity, mid eighties: Hi Roark If i understand your question correctly then the answer is yes...by 1986 Akai, Emu, Boss and a few other manufacturers already had affordable samplers on the market. Digital sampling has been around since 1979 but the first afforable ones for studio...

Multimedia Sound: surround sound systems, loud explosion, power amp
loud explosion, power amp, standby mode: Hi, I had this website set me to on vacation but apparently it didn t work. Well, I m in town now, on with the question... It is hard to tell given the specs of the equipment you have whether or not the power amp/receiver uses a fuse but more than...

Music Business: Publishing deals and Selling songs, double edged sword, performance royalties
double edged sword, performance royalties, time publishers: Hello Benjamin, Advances from either Labels or Music Publishers are a double edged sword at best. Basically speaking, this is how they work: 1) If you re coming to the company from another company and have a proven track record chances are that you re...

Music Business: Publishing Song Music and Lyrics, professional demo, vocal recording
professional demo, vocal recording, dww: Hi Nina, Depends on how much input you want to invite. If you want this to be YOUR project alone you should go as professional and complete as you can afford. If you re presenting it to a possible collaborator on the project you could probably get by with...

Music Business: copyright infringement, copyright act of 1976, compulsory fee
copyright act of 1976, compulsory fee, lead belly: Hi Mimi, I wish it were that easy. Public domain, however, isn t a fixed target; it s more like one of those moving animals you have to hit at a carnival in order to win a prize. The prize in this case is gratis usability, and in the case of Lead Belly...

Music Business: music reviews, keystoning, http www myspace com
keystoning, http www myspace com, publicists: Hi Caryn, Sounds like we need to discuss media kits, keystoning and target lists. But first, a defining question: what is your budget? If you have a budget, then I can recommend some publicists that would do a beautiful job with this. If you don...

Music Business: music reviews, broadjam, film projects
broadjam, film projects, http www myspace com: Follow up: I was trying to get this question out of the pending mode after your follow up, so it sent you a few emails. Hope all is well. Happy New Year! Carol carol@livemusichome.com www.myspace.com/livemusicchick Myspace is a good one for that....

Music Business: Entertainment Industry, rough demo, hootie the blowfish
rough demo, hootie the blowfish, rihanna: Hi Jen, Sorry for the holiday-related delay. You are correct that getting signed is a tedious process; in fact, it s hardly the end. It s only the beginning. Getting signed by a major label does not necessarily guarantee success, as these companies...

Music Business: living room concerts, home concerts, concert in home
home concerts, concert in home, private concerts: Hi Rich, I ve only heard of that once before and that was because I received a friend request from a midwest promoter on myspace. They would probably have more information about that than I do. Their myspace address is www.myspace.com/concertsinyourhome....

Music Business: Music, radio airplay, burning a cd
radio airplay, burning a cd, length albums: Hi Ava, A single is a reference to when artists released a single song at a time, as opposed to full-length albums. Each single was expected to be a hit and was positioned to receive radio airplay to insure it did. Today, artists release either LP s (10+...

Music Business: mixer for recording our band, mixer, sound board
mixer, sound board, audio: Hey Brian, For reasons I stated in a previous live sound performance question, I highly recommend no less than 16 channel. Room for growth and the better bang for the buck being the biggest reasons. Also, you don t want to have your board maxed out if something...

Music Business: live performance sound question, drums and bass, thanks norman
drums and bass, thanks norman, two guitars: Hi Norman, Generally we d suggest at a minimum a 16 channel board, especially if you re outdoors. Even if you don t use them all you ll leave room for growth and improvements and it s a better bang for the buck. If outdoors you ll want to mic everything...

Music Business: Managing New Artist From Another Country, licensing companies, american stage
licensing companies, american stage, neil diamond: The first thing you need to do is outline a plan. This will give both of you a sense of direction. By plan, I mean a contract. Especially if you re planning on investing your own money into the artist. He ll need accommodation, food, traveling expenses not...

Music Business: music management company, music management company, natural knack
music management company, natural knack, absolute prerequisite: Hello Chris, Thanks for taking the time to post your question here. There s no simple or short answer to this question and depending on the manager/company, the profession of artist management can be quite diversified. There are numerous responsibilities...

Music Business: music management company, music management company, kathie nicolet
music management company, kathie nicolet, solo musician: Hello, Chris - Thanks for your question. I admit I am not a music manager and am not sure if you are inquiring about management of a famous band or a local band? I will tell you that management involves marketing the band, drawing up contracts, securing hotel...

Music Business: Protecting band names, mark thanks, mr willis
mark thanks, mr willis, band names: Hello Mark, Thanks for asking your question here at AllExperts. This is not my area of expertise but I will try provide you with at least a path forward. My attorney always recommended that I get business and band names trademarked. I took his advice...

Music Business: getting a record deal, social networking sites, investor loans
social networking sites, investor loans, getting a record deal: Hello Cobretti, Thanks for asking your question here at AllExperts. Unfortunately banks and other reputable finance agencies are not to excited about lending money to staving artists unless you enter into a collateral based loan. You may want to see...

Music Business: singing and song writing, confidence builder, internet days
confidence builder, internet days, abundant opportunities: Hello Dereck, Thanks so much for your question. All songwriters and artists, young or old, seek the same sort of destiny as you ve described. Having the passion and drive to get there is 50% of the solution. The other 50% lay within the realms of luck....

Music Business: helping bands get foot in the door, professional business cards, cd demos
professional business cards, cd demos, venue owners: Carey, First off, I apologize for my tardiness replying to your question here and want to thank you for your patience and understanding. Networking has always been, and I suspect will remain, the number one method for anyone getting anywhere in this...

Music Business: Music Managers, duties of a manager, rehearsal space
duties of a manager, rehearsal space, music managers: Hey Taylor, Thanks for your question. Artists are usually not ready for agents until they are being booked on a large scale level or signed to a record label. If and when that happens, nine times out of ten, the agency will find you, whether it be through...

Music Business: Contacts, team baseball, personal drive
team baseball, personal drive, baseball teams: Chris, While it s always a positive thing when anyone likes your music, it s important to retain your focus and stay on track. This business is very difficult even at the best of times. Most of us struggle 98% of time. The remaining 2% is what I like to...

Music Business: being a guitarist for a band, situation plan, necessary experience
situation plan, necessary experience, heavy gear: Alejandro, Sorry, I can t really answer your question as there are no real answers which I can provide for you. The bottom line however, with regard to your 6 queries is, motivation and inspiration. Musicians are driven by the love of music. If you do not...

Music Business: songwriting business, Russian, music business
Russian, music business, selling music: Hello Sergey, It sounds like you already have a good idea where to start. Whether the degree helps at all depends on the area of music you specialized. If it s more music oriented it will be helpful in communicating with musicians. If it s more music BUSINESS...

Music Business: christian songwriting, christian songwriting, mainstream pop
christian songwriting, mainstream pop, hip hop artists: Hello Wendy, Thanks for submitting your question here at AllExperts. First off, it s great to see you supporting your daughter in a possible career in music. In many instances, this is an excellent proponent toward a young person s success. Their...

Music Business: ??, hip hop artist, webpage community
hip hop artist, webpage community, classical musician: Hello Day, I can t recommend a college for you based on a few factors: 1) Are you finished high school yet? 2) Where do you live? 3) What type of music do you hope to study in college? While it s a wonderful thing that you re excited and already...

Music Business: singing/song writing, recording, singing, songwriting
singing, songwriting, music business: Hi Chris, Sorry it took so long to answer. It s been a busy summer for me, but I like to take some time when I answer these. You re going to have to get a fanbase somewhere. They re going to be your best promotion. If bars aren t your thing try the...

Music Business: Management & Distribution, hip hop music, contingent compensation
hip hop music, contingent compensation, cd photos: I m sorry to hear about your dad - the loss of a parent, whether expected or unexpected, is always tragic. Please post your email address and I will send you a message with our postal address for you to send your press materials. Thanks, Patrick ...

Music Business: about your answer, music contract, music copyright
music contract, music copyright, entertainment contract: Hi Caryn, His company is www.broadjam.com. They have a lot of resources for getting music out there in a professional network for very reasonable prices. I ve had some friends say the first jobs they got through there paid for their memberships and submission...

Music Business: Getting Started in the Country Music Bizz, mom dad, vocal teacher
mom dad, vocal teacher, wedding industry: Mariah, Thank you for your note. You sound like a very accomplished musician! I understand your parents concern that music is not always considered the best career to follow as an entertainer in that becoming successful is so VERY difficult. Your...

Music Business: Copyright music, copywriting music, ASCAP
copywriting music, ASCAP, licensing music: Hi Aaron, This question is a little outside of my expertise. I m fairly sure it depends on the terms of the license agreement and is negotiable in acquiring it. Usually acquiring a license agreement involves stating a purpose for that agreement and negotiating...

Music Business: Starting a Music Career., music career, music agent
music career, music agent, music professional: Hi Dana, I just noticed I often start responses like this, but sorry it took so long to respond. I like to wait until I have the time to respond thoughtfully, rather than just shoot off some short, generic response. Sounds like you re on the right track....

Music Business: getting my songs to artists
Music Business: getting my songs to artists

Music Business: Meeting a song publisher, publisher, record company
publisher, record company, meet contacts: Hello Ufoma, That s a pretty broad question. In short, you would probably have better luck getting an artist or an agent who is involved with a publisher or record company to sign you as a regular writer. To elaborate, if your songs have a commercial...

Music Business: getting my songs to artists, song promotion, paramount group
song promotion, paramount group, proctor gamble: Hi Christina, It looks like you ve already taken a solid first step toward marketing your songs - signing with a music publisher. I ve not heard of the Paramount Group and my expertise does not lie in the Nashville scene, but I do think you should determine...

Music Business: TV Royalties, composing work, pilot stage
composing work, pilot stage, synchronization license: Hi Phil, Thanks for bringing my attention to this rather interesting situation. It s easy for musicians to get burned when it comes to sync rights, which, along with the mechanical license, are what comprises the necessary clearances for a television show...

Music Business: attendance record, concert attendance, ticket sales
concert attendance, ticket sales, popular bands: Hi Jon, Had a hard time finding a definitive answer for that, but close to it is this one from the Guinness Book.... Led Zeppelin broke the world record for the Highest Demand for Tickets for One Music Concert when 20 million requests came through the...

Music Business: copyright songs, copyright, should I copyright?
copyright, should I copyright?: ******Since answering this question yesterday I came across a website in beta test mode (not quite ready) called a href= http://www.myows.com www.myows.com /a (My Original Works) It has some trouble working properly and completely in Internet Explorer browsers...

Music Business: karaoke, karaoke CD, karaoke systems
karaoke CD, karaoke systems, karaoke disc: Hi Jim, That question really is not my area, but I know they are often made by either removing a vocal track that resides on an original master music file, or by removing the frequency or frequencies that allow you to hear the vocal on the system that it...

Music Business: Music, copyright infringement, music copyright
copyright infringement, music copyright: ******Since answering this question yesterday I came across a website in beta test mode (not quite ready) called a href= http://www.myows.com www.myows.com /a (My Original Works) It has some trouble working properly and completely in Internet Explorer browsers...

Music Business: RIAA certifications, RIAA certification, gold record
RIAA certification, gold record, platinum record: Hi Karen, This question is a bit outside of my expertise. I suppose it could be an error. If not error I would venture a guess it would be that they registered one before the other, and that the certification process might have had something to do with...

Music Business: Difference between Record Company and Music Publisher, music publisher, record label
music publisher, record label, the difference between record label and music publisher: Hi Chamsy, Seems like it would be pretty straight forward that a record label produces the content and the publisher distributes it. However, in a constantly fluctuating industry like music they are likely one and the same in many cases, or at least different...

Music Business: Difference between Record Company and Music Publisher, major record labels, incorrect music
Music Business: Difference between Record Company and Music Publisher, major record labels, incorrect music, distributor distributors

Music Business: National Music Month, National Music Month, music month
National Music Month, music month: Hi Jan, I can t resist the urge to put this out there: To me every month is International Music Month. Ha ha No but really, if your Google search did not reveal it, then it s probably not official, or is official in one particular organization or another...

Music Business: 60/40 split on publishing, music compensation, licensing
music compensation, licensing, music sales: Hi James, Not knowing more than what you ve stated, it looks like you will be splitting the management fee. You re each getting 40%, but he covers the management bill with 10% from you and 10% from his cut. Depending on the size of the deal, and his...

Music Business: Contract/Liability Laws for minor age musicians, Idaho child labor, minor
Idaho child labor, minor, bars: Hi Karen, I am no legal expert, but I was able to find this little piece of info... http://legislature.idaho.gov/idstat/Title44/T44CH13SECT44-1307.htm which just shows this code... TITLE 44 ...

Music Business: at source vs net receipts on the master side, music sales, sales and marketing
music sales, sales and marketing, receipts: Hi James, Is this the same James I just responded to a few minutes ago? It seems to me you should only be asking for a percentage of the of the source if you re willing to take the risk on the expenses. Sales and marketing expenses fluctuate with the...

Music Business: Why do few international artists find mass commercial success in the US?, music sales, commercial success
music sales, commercial success, international stars: Hi Victor, I believe it has more to do with marketing and distribution than the music itself. The music hubs in the US like LA, New York, Chicago, Nashville, etc. have some very experienced and vast networks of music professionals who know how to get their...

Music Business: Royalty questions for having musicians play in our bookstore, royalty payment, beatles song
royalty payment, beatles song, jazz piece: That is a wonderful idea!! You will save ALOT of money - and she will be a smash. GUARANTEED. Excellent marketing - and she will have an absolutely wonderful time. In that she is so young, she may not stick with this. Ask her if she has friends who may...

Music Business: Music career, music career, old girl
music career, old girl, good luck: Hello, Brandi -- Happy to hear you want to get that career started! I have answered questions very similar to yours before on All Experts. See if you can find those questions - if not... let me know and I ll see what I can do for you. But I will tell...

Music Business: ARTIST DEVELOPMENT / STAGE PRESENCE, department signs, artist and repertoire
department signs, artist and repertoire, physical appeal: Terry, good questions. The answers could sustain an entire hardcover book however, I ll lend an opinion or two which I hope will set you in a positive direction. I ll answer your second question first: A great artist should be one of two things; either...

Music Business: Booking Tour in USA?, jim halsey, many moons
jim halsey, many moons, young lads: Hi Ronnie, Thanks for writing in. Sounds like you have been around the block yourself. Nice bio! As far as touring in the U.S. goes, there are some sources on the web that you should check out such as www.pollstar.com, www.performancemagazine.com, and www.musiciansatlas.com....

Music Business: Booking Tours?, many moons, billboard charts
many moons, billboard charts, australia tour: Contact Toby Ludwig who runs a very sucessful agency in NYC. Tell him you are a client/friend of mine and he will be able to help you as each State has different laws. You may want to do a split deal as a learning curve and he may be able to do that with you....

Music Business: Booking USA Tour?, e booking, possition
e booking, possition, convienience: The agency normally pays a salary plus a bonus of what income you bring in from the acts you book. That is the norm, but if you are booking bus s and things like that then you are really doing the work of a tour manager as well in which case a larger salary...

Music Business: band on tour - paying bills at home?, intermittent employment, tax accountants
intermittent employment, tax accountants, accounting methods: Hello Rob, Although I m no financial expert there are a couple of ways in which an artist or band can successfully manage their business affairs while on the road, away from home. Most successful artists and bands find it necessary to employ accountants...

Music Business: Copyrights and submission of music to studios, david sloane, hip hop producer
david sloane, hip hop producer, instrumental tracks: It depends on where you live. If you are in the States or the United Kingdom then a shortened versioned will do although it is always best to copyright the full version so that elements of the track cannot be copied. I would not leave a copy with the studio...

Music Business: c.d. sales, donald passman, 1 million dollars
donald passman, 1 million dollars, music consultant: Mike, Thanks for writing. It s really difficult to say. Remember, that before an artist sees ANY money, they must reimburse the label (with sales) for all the money the label spent. These costs include production of the album and usually all of the marketing...

Music Business: categories, songwriting career, secular world
songwriting career, secular world, sucess: I think you wll find that the industry loves good songwriters period. Persue both and stick to your belief that you arer god in both areas. You will be respected for it and as soon as you have even the least of sucess then you will see both sides turn around...

Music Business: Finding work difficult, quality demo, beverage directors
quality demo, beverage directors, vocal trio: Hello, Mike.. Greetings to the UK ! I can t say I ve had much experience across the ocean, so I ll give you my best advice based on what I know about the U.S. hotels, clubs, etc. First and foremost.... You MUST have a quality demo CD that showcases...

Music Business: how to find a publisher, household name, completed works
household name, completed works, best bet: Your best bet is to find THE artist you have in mind. Myspace has become a powerful tool in putting the average person in touch with at least the agent of the performer. Give them a little sample without giving away too much. Don t be offended if they re...

Music Business: Gospel promotions, neighborhood associations, talent showcase
neighborhood associations, talent showcase, carol lee: Depending on where you live, a good place to start is with your local neighborhood associations. They will have the information and contact people to reach for each church. You may be able to get a list of neighborhood associations from your chamber of commerce....

Music Business: getting gigs, billy joel music, commercial niche
billy joel music, commercial niche, city opportunities: Joel - Thanks for your note. I am not sure who I had advised in the past about being able to sell Elton John/Billy Joel music to ~ This may have been taken out of context so if you d like to fill me in, that would be great. As far as playing nursing homes,...

Music Business: Label Rep or somthing, high school graduates, label rep
high school graduates, label rep, ear to the street: Dear Madeline, Thanks for your question. I ll start by answering your question about the qualifications. Really there are no set qualifications for being a an A&R person. I ve met A&R people who are high school graduates and A&R people with Phds. I think...

Music Business: Music Publishing, legal business entity, professional experiences
legal business entity, professional experiences, legal publishing: Hello Daniel, Thanks for your posting your question here. With regard to CD Baby it s best that you contact their support team directly http://cdbaby.com/contact and communicate with them directly regarding your queries. Pertaining to publishing/royalty...

Music Business: Music, kathie nicolet, mike thanks
kathie nicolet, mike thanks, billy preston: Hi, Mike... Thanks for your note. It would have been helpful to know how old you were... and if you have the time to take up an instrument to study. If you want to compose an instrumental someday, you might want to just buy a keyboard and start plinking....

Music Business: Musician Business, showcase your talents, digital musician
showcase your talents, digital musician, vocal arranger: Hey Sonny, Thanks for your question. There s no substitute that works as well as networking does. The more you hang out with like minded individuals the better your chance will be for making new connections and stimulating old ones. Word of mouth via...

Music Business: Musician's earnings, heavy metal band, solo singer
heavy metal band, solo singer, album sales: It depends on the artist and the territory. For example if it is a Heavy Metal band them a large part of it s income is from touring. If it s a solo singer who has to put a band together e.g. George Michael then not a lot. It also depends in what country...

Music Business: Musicians and sudden fame, sudden fame, barry manilow
sudden fame, barry manilow, loving families: Very interesting that you selected Barry Manilow as someone who experienced sudden fame . Actually, Barry has been in show business a LONG time and worked his way up from the bath houses in New York ~ accompanying Bette Midler ( when she was on HER way up.).....

Music Business: management, how to get into the music industry, networking tips
how to get into the music industry, networking tips, music consultant: Hi Grace, Thanks for writing. Primarily, what I do, is offer people advice on how to get into the music industry to make connections for things like record deals, managers, agents, etc. I think your best bet for finding a manager is to network yourself...

Music Business: music, live performance, songwriters
live performance, songwriters, bmi: Hey James, Please provide me some more details so I may consider this question properly. For example: 1) What do you hope to achieve by having your music published? 2) Do you have a recording contract? 3) Is you music best directed at radio, film,...

Music Business: music industry/independent labels, billboard 200, independent labels
billboard 200, independent labels, independent label: Hi Suzanne, Thanks for writing. You re asking some great questions. I ll start right off with your first question. There really is a lot of compromise that goes on on both sides. But it s also important to keep in mind that A&R people study and know how...

Music Business: music publishing, fairy godmother, clock struck midnight
fairy godmother, clock struck midnight, max signs: Hello Erin, Thanks for submitting your question here. Although Music Publishing deals are not my area of expertise, I ve gone through enough of them personally to provide some insight to your question I hope. Reversion of copyright is relevant to the...

Music Business: music publishing, classic rock group, local radio stations
classic rock group, local radio stations, demo cd: Go to www.sloaneandco.com and go to the music industry section which has all the info you need. When it asks for the user name and password just leave it blank and click on the OK button and it will let you in. If you still have further questions feel free...

Music Business: music songs...selling them, target companies, marketing music
target companies, marketing music, carol lee: I wouldn t target companies. I would target a popular artist that works with major labels who you think will do your song justice. They will already have the in that you need to get noticed by the large companies, or other artists as well. It s a lot easier...

Music Business: Need help with Projections for Business Plan, straight line depreciation, record distributor
straight line depreciation, record distributor, radio reviews: 1) Are we talking singles or albums and in which country? Usually 10,000 albums for an unknown band with good distribution and reasonable marketing - in your home country and licence overseas sales. This figure will really be as long as a piece of string...

Music Business: Niche Marketing, steel drum band, steel drum music
steel drum band, steel drum music, caribbean soca: Hey, Kris--- Just a thought, you didn t graduate from Northern Illinois University, did you? It s one of the few colleges that sponsors a steel drum band... When you talk about 2-3% of sales to the market , that could mean a lot of things---is it the...

Music Business: NYC, indie labels, peter willis
indie labels, peter willis, letters of introduction: Hello Bhavesh, Sorry I can t recommend any agencies such as you requested in NYC or anywhere else for that matter. Jobs such as internships etc. come by word of mouth and in most cases, from inside sources. Landing an A/R job right outta the gate is...

Music Business: Performance, kathie nicolet, professional pianist
kathie nicolet, professional pianist, solo pianist: Hello, Miguel! Thanks for your questions ~! It will be difficult to answer them in a few lines in that you have asked quite alot without realizing it I m sure! My playing schedule is 6 days a week. We professionals laugh and always say our playing/performing...

Music Business: PROMOTING A SINGER, dean martin impersonator, legal liabilities
dean martin impersonator, legal liabilities, dean martin: I cannot comment on if it s a good idea, but it is easy to set up. Firstly as a manager you should get a commission on any bookings that you get. This is different from making a CD. This is really as though you were a record company as from the sound of it...

Music Business: Press kit, luck david, music influences
luck david, music influences, band style: CD with say 3 tracks, pictures, press cuttings and notes on the band (style of music, influences, names of members,ages where they from etc) Go to www.sloaneandco.com and go the music industry section and you will find all the info you need there. Good...

Music Business: performing, cocktail pianists, cocktail pianist
cocktail pianists, cocktail pianist, jazz cocktail: Hello, David ~ Thanks for your question, although you have many within one! How long have you been performing, professionally? If you are only offering classical music, your appeal to the cocktail crowd will be minimal. Sorry. You can t promote yourself...

Music Business: publishing and record deal, industries history, new frontier
industries history, new frontier, precarious position: Hey Peter, Thanks for the follow-up question. Getting your record to the top online is difficult because there is no top online. Billboard magazine until now, has served as the barometer for tops but there is no Internet based publication that...

Music Business: recording, mini disc player, record label info
mini disc player, record label info, homerecording: Miriam, A home recording can be made with something as simple as a mini-disc player and a microphone. More home recording info is at http://homerecording.about.com. To make a professional recording, she can either hire a studio to record her, or get...

Music Business: Side artist Payment, american federation of musicians, famous singer
american federation of musicians, famous singer, seven songs: Hey Adam, Depends. Are you doing this recording for a record label? If so, any and all musicians/vocalists will be paid as per the AFM (American Federation of Musicians) scale. Some musicians may demand more than scale. For example, scale plus one half,...

Music Business: Getting Started, fine entertainment, musical goals
fine entertainment, musical goals, theater groups: I am sorry to hear that you are having difficulties getting gigs ~ but you didn t state how you are attempting to find them. Do you show up in person to speak with someone, personally? Do you tell them you are only 15? We had one gentleman on staff at Nordstrom...

Music Business: Just Getting Started, small music, current band
small music, current band, music label: I think I would use 10,000 units. P{lan for your home sales coming in over 12 months on a monthly basis with nil in the 1st month, 30% in the 2nd month, 40% 3rd and then the balance spred n decreasing amounts over the next 9 months. Overseas licence income...

Music Business: selling songs, lengthy contracts, publishing companies
lengthy contracts, publishing companies, extra income: The only way to earn from songs you write but do not record is to do a deal with a publisher. They may if they like your work ask to sign you as a writer ( not a recording artist), but it s not unusual to just do a deal on a song by song basis or for a number...

Music Business: singer, carol lee, record labels
carol lee, record labels, musical notation: I m sure you ve heard it before and you ll probably hear it for the rest of your career, but it s an extremely competitive business. Do whatever you can to separate yourself from the rest! Not just with promotion but everything! I couldn t even scratch...

Music Business: song titles in a book, good advertising, compensation payments
good advertising, compensation payments, hit songs: Hello Jim and, thanks for your posting your question here. I ll just take a moment to clarify the question I believe you re asking here. If I m understanding you correctly, you will be including inferences in your book to published material but not including...

Music Business: how to get my songs published, rewards and recognition, financial rewards
rewards and recognition, financial rewards, famous musicians: Sorry to take so long responding. I had some trouble with the allexperts website last week. Publishing is just making the music available to the public which you can do yourself. The trick is in distribution, and finding the right behind the scenes people...

Music Business: taking the next step, ramen noodles, time musician
ramen noodles, time musician, regional scene: Sounds like you ve got your feet close to the ground at least. If you re looking for a good agent...that s key. They are so used to working with crackpot wannabes that a band with some idea of what they re going for and a good radio ready sound is a welcome,...

Music Business: touring, music tour, silly question
music tour, silly question, music industry: Lots of artist do not tour. Touring is important though as it is a great promotional tool. If you don t want to do a full blown music tour then think about doing TV, local radio and press tour All tours do until you are a broken act is lose you money ( which...

Music Business: I want to be a singer/ R&B, technical skill level, local musicians
technical skill level, local musicians, carol lee: Hi Joyce, That s a pretty general question for such a big request. There s a LOT of work involved in becoming famous. I can t hook you up, but I may be able to help you get hooked up. I would need a lot more information about how much you ve done so far...

Music Business: how to?, couple of mates, indie labels
couple of mates, indie labels, key travel: To be honest with you it is a tricky process of networking from here out. Getting your name out is at the top of the list of what to do now. Play gigs, build a huge fan base, do interviews with the paper, expand your playing ground. This is the stage at...

Music / Sound Editing: Windows Media Player, ethernet wire, lengthy response
ethernet wire, lengthy response, windows media player: Hello, Thank you for writing. I can provide some steps that might help though there are likely some details about your computer set-up that I don t know about that could still prevent the player from properly functioning. Here are a few steps you...

Music / Sound Editing: Mpeg4 to MP3, file converters, mac os x
file converters, mac os x, cd rippers: Linux/Unix-based systems have excellent applications for the purpose of converting files between formats. You can still use many of them if you are running Windows. If you are running Mac they will automatically work in their natural environment (Mac OS X...

Music / Sound Editing: lowering the music from dvds, home entertainment system, audio normalization
home entertainment system, audio normalization, audio filters: Yes, if your entertainment center is computer-based you can use a normalization feature, which is commonly part of the multimedia software; or, if you are using traditional set-up without a computer, there are devices that are designed specifically for audio...

Music / Sound Editing: Downloading youtube and putting it on CD
Search online for software that is designed for converting the audio from a YouTube video to MP3 format. You will find that several applications exist, many function directly within the web browser. You may opt to install a web browser add-on that simply downloads...