Im currently working with a DTS-package used for importing a Excelsheet into SQL-server.
I have a "Microsoft Excel 97-2000" as source and a "Microsoft OLE DB" as destination.
A "Transformation Data Task" is used to shuffle the data.
The package works ok as long as the path for the Excelsheet doesn't exceed 128 characters! Then it gets truncated at 128 characters and of course the data task can't find the file......
I can browse to my excelsheet, and when I look at the path it's ok. But when I close the package and then opens it again the path is truncated at 128 characters. Grrrr.
Is this a set limit in SQL Server or is it something I can mail the databaseadministrator about tomorrow?
Hi, all:I'd heard that the upper row limit in SQL of 6080 bytes may have beenincreased with SP3.Can anyone confirm/deny this? Is this still a 'carved-in-stone' uppercap?Thanks,DW.
I am not sure about the architecture of the Issue Tracker and hence not sure if it applies here. But I will post in any case and wait for users on this forums comments as well.
===========Earlier post================== This question is regarding the architecture of TimeEntry. In some programs it builds an arrayList for Master-detail type of relationship and when user is ready to save it by clicking 'submit' it build a variable with pipe delimited fields. This is then passed to a sql query.
This to me does not seem to be an efficient manner. Because the max character is 1500 chars as parameter to SQL query.
I was wondering if instead I could store it as an XML and then use the XML to import in to SQL.
Any ideas is greatly appreciated, I am running in to problems where my variable construct does increase to more than 1500 chars. Any thoughts are much appreciated in this regards.
When trying to install Business Contact Manager (BCM) for Outlook 2007, the setup failed and I was refered to a log file in my Local Settings/Temp folder. The log actually says that Business Contact Manager was installed sucessfully! BCM is supposed to install SQL Express 2005 as an instance or as instance if SQL Express is already installed. There is an MSSMLBIZ instance in Services..
Who can I send the Log File to for analysis and the fix feedback?
When I first went into Computer Management and clicked on Services and Applications in the left panel, the error message appeared "Snap-in failed to intialize. Name: SQL Server Configuration Manager CLSID:{CA9F8727-31DF-41D2-975C-887D84903967} This message diappeared when I clicked on Services and Applications again. Under Services, there are 3 SQL services - one is an application that was uninstalled 3-4 weeks ago and I disabled this service. The other 2 are: SQL Server (MSSMLBIZ) and the other one is SQL Server (SQLEXPRESS) When I tried to start either of the last 2, the message appeared: Services "Could not start the SQL Server (MSSMLBIZ) service on Local Computer. Error 3: The system cannot find the path specified. Under Program Files/Microsoft SQL Server/MSSGL.1 folder is mostly empty. So, it seems like the Path in the Registry is not valid and that nothing is being installed in the MSSQL.1 folder. If so, how do I fix this?
How do I get the BCM SQL instance to install and run properly? what do the messages in Services mean and how do I resolve these.
After updating TempDB path to a wrong path (without file name only folder name) the service is not starting. How can i sovle this and start the service
In my application I must store over 16000 character in a sql table field . When I split into more than 1 field it gives "unclosed quotation mark" message. How can I store over 16000 characters to sql table field (only one field) with language specific characters?
Hi everybody, I would like to know if there is any property in sql2000 database to separate lowercase characters from uppercase characters. I mean not to take the values ��child�� and ��Child�� as to be the same. We are transferring our ingres database into sqlserver. In ingres we have these values but we consider them as different values. Can we have it in sqlserver too?
When creating a database, SQL Server 6.5 seems to have a 2 gig limit. What I mean is that if the device chosen is over 2 gigs SQL Server displays the size of the device as anegative number. This prevents me from being able to expand the database when I need to. Can anyone tell me why this is so, and if there`s anyway around it??
we all know mysql: select * from table limit ?1, ?2
equals
sqlserver: SELECT TOP ?2 * FROM table WHERE (IDENTITYCOL NOT IN (SELECT TOP ?1 IDENTITYCOL FROM table order by IDENTITYCOL)) order by IDENTITYCOL
but the below SQL in mysql,how to convert?I enmesh........... select pageid,pagename,pageaddr,pageauditflag,pageartaudi tflag,startplaytime from pageinfo where entryid= ?1 and startplaytime= ?2 limit ?3, ?4
hi,I have a question.Maybe You know the equivalent to command LIMIT from MySQLI couldn`t find something like this in MS SQLPSI try to display 10 records begining form e.g. 4 sort by idsomething like: "SELECT * FROM table WHERE name=... LIMIT 4, 10 ORDER BY id"in MySQLthanx,Urban
I recently read up and found an msdn forum post that said the 4gb limit only applied to data files not log files.
However recently i had an error on a sql express database saying that the log file was full, the database log file was set to auto grow and there was plenty of space left.
So i am guessing the 4gb limit applies to any database file mdf or ldf, is this correct ?
Sorry if this is not the correct forum... I am using the FOR XML PATH feature of SQL Server 2005 (Amazing!!) Is it possible to return multiple rows? For example:SELECT 'Field1' AS 'Element1/@Field1'FROM TableFOR XML PATH('Repeating') Say the above SELECT returns 5 records, I want it to return 5 rows of xml in my ASP.NET application. So in this case each of the 5 rows would contain:<Repeating><Element Field1="Field1"></Element> <Repeating>Instead of returning 1 row with all the xml together.
When using sp_xml_preparedocument @hdoc OUTPUT, @doc I see code everywhere with huge xml text embedded in some store procedures. Can the SELECT XXX FROM XXX FOR XML PATH('') syntax be used instead to produce the second parameter @doc (xmltext) for sp_xml_preparedocument ?
Im trying to reference a ExcelFilePath connection properties using a UNC path, however it doesnt seem to like it, when i use a mapped drive everything works fine.
I have the fields in my table: ID, Title, Description, Price, ImageData, Active I only want it to be possible to have two records at any time with Active=Yes. Active is a Bit, Yes/No, field. Any help is appreciated. Chuck
hi,i have a union statement that works like a charm:SELECT [Name], [EventID] AS [ItemID], [TourID], [Date], NULL AS [StartDate], [Date] AS [SortDate], [Type] FROM [Events] WHERE [TourID] IS NULL AND AccessLevel <= @AuthenticationLevel
UNION
SELECT [Name], [TourID] AS [ItemID], [TourID], NULL AS [Date], [StartDate], [StartDate] AS [SortDate], '2' AS [Type] FROM [Tours] WHERE AccessLevel <= @AuthenticationLevel
ORDER BY [SortDate] this statement selects all the records i want from both tables, and orders the entire new table by sort date.what i want to do is to add a limitation on the number of records. i have tried using both LIMIT and TOP commands, but i can't get it working. both of the below statements give me a syntax error saying "Incorrect syntax near the keyword 'ORDER'"first try:SELECT * FROM (<same_statement_as_above>) ORDER BY [SortDate] LIMIT 2second try:SELECT TOP 2 * FROM (<same_statement_as_above>) ORDER BY [SortDate]what am i doing wrong, and how do i achieve what i want?i am working with mssql server 2005 (express locally, and standard on my hosting service). thanks for your help!
I have an application with a DAL that has an interface with SQL Server. The application has 400 users that open the web forms. My question is: Is there a limit of the parallel connections that can be opened? Or the IIS is managing all the access to the DB? Should I worry about the performance Or it's normal behaviour for ASP.NET applications?
SQL takes all CPU resource on some of the intensive queries. Is any way to make sure there is something left for other tasks to be processed? Let's say limit SQL to use no more than 80% of CPU.
There is at present (as we accidently found) limitation of MSSQL to return per row maximally 8060 bytes. Message like this comes: "Cannot create a row of size 8279 which is greater than the allowable maximum of 8060". My questions are : - Is there any way how to pass it? If I split into more tables (as I have it now) and ask for result where these tables are connected over any ID the result is the same. If I use stored procedures it seems to be ok. Any other idea? - Will be this ok in SQL server 2005?
I have an application that uses a small SQL Server database. What I need is to prevent the access of an amount of users to the database. At the beginning I want to limit the access only for 2 users but I want to be able in the future to grant the access to more.
