Hi folks,
I get this error message when I try to run my personal web page starter kit (Ctrl + F5) which has come straight out of the box:
Personal Web Developer Kit SQL Error
Getting started with SQL Server
-
- Previous
- 1
- Server Agent Jobs: Script job as create to file... Thanks Derek, I have reviewed the system tables containing the jobs as well and reviewed the stored procedures that actually create jobs, and truth be told I could probably manually hammer out my own proc to accomplish what I need. I was hoping there was a way to see exactly what is executed when the task is ran via Management Studio as to save myself some work I just seems like a waste of time to write a stored proc to do what can be done via the user interface... CC - Tag: Personal Web Developer Kit SQL Error
- 2
- comparing two fields I usually use a not in clause I m pretty sure this will work..you can concat the two columns thus, select convert(varchar(10),a . block_code)+convert(varchar(10),a.second_code), <anything else you want to select> from BLKPTS_ADDXY a where convert(varchar(10),a . block_code)+convert(varchar(10) ,a.second_code) not in ( select convert(varchar(10),s . block_code)+convert(varchar(10) ,s.second_code) from allblkzips as s ) This will probably run faster than the query you are using which tries to run a where condition in an inner query with a field in the outer query, comparable with a for followed by another v/s a nested for loop in procedural programming. Tag: Personal Web Developer Kit SQL Error
- 3
- Transaction Question Thanks. That did it. We use the double quotes in our code so that the string that EXEC executes can have single quotes. It is neccessary for the type of scripts we write. Doubling up the single quotes does not work in the way we do it. JD Waleska, GA Tag: Personal Web Developer Kit SQL Error
- 4
- Cannot connect to 2000 from 2005 via linked server Close.... but not right... Box 1 -- Windows 2003 SP1, SQL 2005 SP1 (inst2) and SQL 2000 SP3 (inst1) Box 2 -- Windows 2003 SP1, SQL 2000 SP3 (inst3) So inst2 has a linked server to inst1 and inst3. It can talk to inst1 with no problem but gets the error posted above when talking to inst3. Inst3 can talk to inst1 and inst2 with no issues. also inst1 can talk to inst3 with no issues. It does it every day so I know it has nothing to do with the physical servers (hopefully). Tag: Personal Web Developer Kit SQL Error
- 5
- Cube processes OK but no rows appear in the browser That was it, I deleted the calculate in the process of adding calulated members. Thank You for your help. Tag: Personal Web Developer Kit SQL Error
- 6
- Is there Limitations to Importing data to SQL Server Express That is NOT correct -SQL Server Express is not JUST "an evaluation copy" SQL Server Express is a full featured product, albeit without some of the features included with the paid versions. SQL Server Express is limited to a database size of 4GB; it could hold one table that held almost 4GB of data. You may find importing data to be a bit easier using the DTSWizard. You 'should' be able to find a copy here: (assumes your SQL Server installation used [ Drive C: ]. C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe Tag: Personal Web Developer Kit SQL Error
- 7
- Multi-database Multi-server I guess I should also point out that I am wondering if RS offers some sort of "enhanced" ability to consolodate the data from all of these databases. I need to get aggregates from all of these databases and doing joins across 1000+ just won't work. So short of having to create a single reporting database - is there a better way to get this info If for example I have these 1000 databases that are all identical with regards to schema (one database per client) and in each of the databases is a sales detail table. Now I want to be able to query across all of the databases (or a subset if I so desire) and find out how many sales of a particular item took place on a particular day. I also need this to be real-time (or at least within the last few seconds). Is this a common issue I would think so but in searching the net and forums I haven't found a effective solution... Tag: Personal Web Developer Kit SQL Error
- 8
- DB does not autogrow Hi William, the best practice for data files isn't to use the Growth in Percent, but rather the Growth in Megabytes, and select a value that will work for your database. For example, small databases might set the Growth in Megabytes to 1 Gig, where very large databases may set it to 5 Gigs or more. The reason for this is that the default percent growth (10%) for a 60 Gig database will be 6 Gigs ¨C a large uncontrolled jump at any one time. Setting it to 1 Gig or 2 Gigs will create auto growths in a much more controlled manner. To size your transaction log files you should do the following: 1-Shrink the log as much as possible. 2-Dump every 10-15 minutes. 3-Monitor its growth over a week - nothing the maximum size. 4-Lastly, dump the log, shrink it one more time to the minimum size and then manually size it for this observed maximum size. Note: Use Performance Monitor to monitor the performance objects SQL Server Databases ( Log Growths, Percent log Used, and Data File Size). Regards, Tarek Ghazali SQL Server MVP http://www.sqlmvp.com Tag: Personal Web Developer Kit SQL Error
- 9
- Want Text box font to be inherited from list I want to set properties such as font family, font size, etc as high as possble in the report. Is it possible to have textbox fonts inherited from a container like a list, or report Currently it seems I need to set fonts on every textbox. Similarly, when I use report designer to put a textbox on a report, the textbox decides the Font is Normal, Arial, 10pt, Normal. Where is this setting stored Tag: Personal Web Developer Kit SQL Error
- 10
- new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software re: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software From my desktop the report accessing an Oracle 9i db with no problem. I've deployed other reports accesing sql server with no problem. Now I deploy the report and try to access my Oracle source and get: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater On the server in question, I know they've installed the oracle client. I can access the db from sql plus with no problem. As the user that I access ssrs credentials, i remote login and am able to write to oracle home.. C:\oracle\ora10g\NETWORK\ADMIN i've confirmed my database is in tnsnames and it works from sqlplus. Tag: Personal Web Developer Kit SQL Error
- 11
- copying tables DTS vs SSIS - speed!!! sorry for my ignorance, but is this an SSIS property and if yes where can I find it Thanks Tag: Personal Web Developer Kit SQL Error
- 12
- using historical attributes with SCD transform on a table with a PK Phil: What about date fields such as an Effective Start Date and and Effective End Date to capture the valid timespan for a record Tag: Personal Web Developer Kit SQL Error
- 13
- How to validate the parameter values? Pre-defining the values will be helpful in case of numeric or string values. What if i want to compare date values. For example: given date is less than or equal to today's date... I think, this is also not possible!!! The RS Engine validates the date based on the format only. The validations are not possible. Some alternative should be thought-of by microsoft... as validations are very necessary. Tag: Personal Web Developer Kit SQL Error
- 14
- How do I go about placing photographs in SQL? I found an image data-type. thanks... Tag: Personal Web Developer Kit SQL Error
- 15
- Average of children hi, ok i'll try to explain it this way: i have two measures a_price (a_price is equal price*capacity) and capacity. lets say my hiearchy looks like this: 1. level Country (highest level) 2. level county 3. level city 4. level hotel i'm looking at total of 3 months. now i used calculated member A_PRICE/CAPACITY and defined a_price and capacity as averageofchildren when asked to define aggregation function. everything works fine. i have 3 hotels in one month, wwhen i look at the level of the city i get avg total of those 3 hotels but not that it summed them and devided them by 3. so this works in enterprise edition, but what to do in standard edition ok i defined measures now as sums (standard edition) and i need to calculate a_price/capacity. i have no special mdx script, i need to define next: sum on the lowest level, and on the next higher level average function if i use is it clearer now Tag: Personal Web Developer Kit SQL Error
- 16
- Query Time Limit? If you are referring to having the ability to control any one specific query -that is not possible. QUERY_GOVERNOR_COST_LIMIT effects ALL queries executed on the server. It prevents a query from executing IF the estimated time exceeds the limit. Say the QUERY_GOVERNOR_COST_LIMIT was 120 seconds, the estimated plan was 119 seconds -the query would then execute EVEN if the resulting time required exceeded 120 seconds. As far as I am aware, there is no way to have an executing query abort at some predetemined elapsed time value. Of course, from an application, it might be possible to spawn a thread that executed a query against SQL Server, and then the parent thread could abort the executing thread after a predetermined time. But that could be messy... Tag: Personal Web Developer Kit SQL Error
- 1
- Next
- 1
- SQL Server - using a cursor to find and sum login/logout times Thanks mastros, that works very well. I couldnt get my head around the join. on a slightly different note, i have always used temp tables as opposed to table variables. what are the advantages of doing it this way Thanks, Jon Tag: Personal Web Developer Kit SQL Error
- 2
- Query performance problems with join on UDF-based computed column oj, Thanks for the suggestions. I tried changing the UDF to use schema binding, but it didn't seem to effect the query plan at all. Persisting the computed column isn't a possibility here, as its value changes over time. Tag: Personal Web Developer Kit SQL Error
- 3
- Pointers to the best documentation on star joins and the optimiser Peter, Also check out this discussion of index design for star schemas: http://blogs.msdn.com/bi_systems/pages/164502.aspx . Also, general advice about statistics and indexed views applies: http://www.microsoft.com/technet/prodtechnol/sql/2005/impprfiv.mspx http://www.microsoft.com/technet/prodtechnol/sql/2005/qrystats.mspx If you use partitioning, it's usually best to put an explicit date filter predicate on the partitioning column of the fact table, rather than rely only on filtering the fact table on date via a join with the date dimension. That way the optimizer can eliminate partitions at compile time. Finally, if you are getting poor plans due to bad cardinality estimates, consider splitting your query up -- filter the dimensions into temp tables, then join the temp tables to the fact table in a final query to produce the result. Another useful trick that sometimes helps is to replace the joins on the fact table with IN-lists, e.g. select ..., sum(measure) from Fact F where F.dim_key1 in (1, 7, 11, ... 22) and F.dim_key2 in (10990, 9887, ...) group by .... This sometimes lets the optimizer get better estimates for the selectivity of the filters induced by the joins with dimension tables. Query hints, join hints, and index hints can also be used to tune your plan. Eric Tag: Personal Web Developer Kit SQL Error
- 4
- Multiple Select statements + Stored Procedure Ideally I want all data displayed in one DataGridView. Each SELECT Query returns the exact same Columns but differing data. Tag: Personal Web Developer Kit SQL Error
- 5
- hidden views When you choose to Generate script for the database objects, then it should have that value to drop the object before creating it, follow as suggested. Tag: Personal Web Developer Kit SQL Error
- 6
- Login Failed for <domain name>\<Machine Name> We have service credentials as web identity sign-on. And we are using IIS 5.1 so app pool does not mean the same as what you were talking about and there is no IIS_WPG that I know of with 5.1. We cannot go to IIS 6.0 as that would make us install software that would be incompatible with the rest of our system. Sorry the IIS version would have been helpful if I would have given that earlier. What we think is the case at this time, is that the profile of the user is screwed up and is somehow thinking the username is actually the machine name at this time. We're looking into it from that angle but would appreciate any other suggestions. Tag: Personal Web Developer Kit SQL Error
- 7
- adding client server aliases I will make the suggestion. Thanks! Tag: Personal Web Developer Kit SQL Error
- 8
- Profiler trace bind variables Sorry, I guess I am confusing you a little In order to give my colleagues a complete answer, I'm now trying to answer a question if SQL Profiler could be possibly used as an alternative auditing solution at extreme conditions, without considering the performance or system resource cost, etc. Your suggestions and comments on Profiler not a good solution for auditing is completely accepted without any reservation. My sample code looks like the followings, and I started all options under T-SQL. In Profiler, I only see the update statement being logged as "update xx set col2 = 'CCCC' where col1 = @xxx" If the actual values of @xxx can not be logged in trace file, it means I would not be able to figure out which row exactly being updated, perticularly, in more complicated algorithms. If my observation is true, then I can reach to a conclusion that SQL Profile can not be used as an alternative auditing tool in any condition 'cause it doesn't give us the completed information about value changes, even if we'd like to suffer on performance in an extreme condition. However, I am not 100% sure if I missed anything in SQL Profiler that could somehow show the values of bind variable. Again, very sorry for asking so many questions :-) Here are what I tested, Given a table xx (col1 int, col2 varchar(20), I have code: DECLARE @xxx AS INT; DECLARE C CURSOR FAST_FORWARD FOR SELECT col1 FROM dbo.xx; OPEN C FETCH NEXT FROM C INTO @xxx WHILE @@fetch_status = 0 BEGIN -- Process data here update xx set col2 = 'CCCC' where col1 = @xxx; FETCH NEXT FROM C INTO @xxx; update xx set col2 = 'CCCC' where col1 = @xxx; END CLOSE C; DEALLOCATE C; Tag: Personal Web Developer Kit SQL Error
- 9
- aspnet_wp.exe crashing intermittently I have an application which is providing printing facility using a custom hardware interface device. Whenever a print is required user punches in his ID number into the hardware device, and hence an underlying application gets the event and it calls a managed DLL, which inturn calls the Reporting services webservice on the same server. Problem starts after some days (typically after 2 -3 days), when the server response becomes slow and the aspnet_wp.exe restarts every now and then and after this sequence of happening, finally it crashes with some event in application in event log which reads: The server was unable to allocate from the system nonpaged pool because the pool was empty. Also many times the applications log file reads : There is an error in XML document (1, 948). I think this error starts when the aspnet_wp.exe is restarting, but I am not sure. The server operating system is Windows 2000 SP-4, MS SQL Server 2000 Standard Edition SP-4, MS Reporting Services 2000 Standard SP-2 with .Net Framework v1.1 The Server is running many applications apart from the ones listed above and there is a moderate usage of TCP/IP sockets for communicating with certain hardware devices. Please help me out! Tag: Personal Web Developer Kit SQL Error
- 10
- Problem for Calling A Stored Procedure, Please help. Hi, HutTsai: thanks for ur reply, as u mentioned about dataset, did you mean in SQL or on the other server side and for the ' exec sp_executesql ', it was only for excuting the dynamic@sql to get those values that i need to calculate in set @Total = @balance / @A + @freetotal. Thanks Tag: Personal Web Developer Kit SQL Error
- 11
- Data Type Range As Adam alluded, an error will occur WHEN there is an attempt to add a 256th row to the table (since the tinyint ranges from 0 to 255, and the IDENTITY column started at 1). This code will help demonstrate the consequences: Code Snippet SET NOCOUNT ON DECLARE @MyTable table ( RowId tinyint IDENTITY, Name varchar(20) ) DECLARE @Counter int SET @Counter = 1 WHILE @Counter <= 260 BEGIN PRINT @Counter INSERT INTO @MyTable VALUES ( @Counter ) SET @Counter = ( @Counter + 1 ) END Tag: Personal Web Developer Kit SQL Error
- 12
- A CLR SVF works on my DB instance but not on the other one As Jens says, you probably should debuf the function - however I don't believe you can use SqlPipe in the function as it is a UDF. But, are you getting any errors, or is it just the wrong data coming back If it is wrong data, what collation and default regional settings does the remote server have Niels Tag: Personal Web Developer Kit SQL Error
- 13
- Scheduled Profiler Scheduling server traces is what you would want to do as Janos posted. Rather than trying to set up all of the statements and events yourself, it's much easier to just use Profiler to create the script file. Create the trace you want in Profiler and then go to the menu to File, Export and then select Script Trace Definition. This will create the server trace file that you can schedule in SQL Agent. You can then open these files in profiler, import them into a table for analysis, etc. It's the same file format that Profiler uses. -Sue Tag: Personal Web Developer Kit SQL Error
- 14
- I can't get SQL Server 2005 Enterprise Edition working Hi, Thanks fo your reply. But the question is that I want to install Microsoft SQL Server 2005 Enterprise Edition on My notebook which has Microsoft Windows Vista Business. I tried installing Microsoft SQL 2000 Server on my machine and it works fine while it is specified on Microsoft Website that Microsoft SQL 2000 Server is not supported on Microsoft Windows Vista ( Of Any Edition ). I installed SQL 2000 Server on my notebook when I got frustrated installing SQL Server 2005 Enterprise Edition on my notebook. I am really frustrated, i should have not gone for windows vista, let the Windows Vista features go to hell. I am not able configue .NET 1.1 or .NET 2.0 on my notebook. I wish there was some magic which can fix all these issues. Hope to read you soon... Regards, Syed Abbas Naqvi Sr. Software Developer. Tag: Personal Web Developer Kit SQL Error
- 15
- Default Constraint on columns Pros and Cons? Thanks for your reply. In the case of gender though wouldn't an empty field or an U for unknown be simpler for programs to process than NULL would Darin Clark Tag: Personal Web Developer Kit SQL Error
- 16
- Exporting reports to PDF hii you can do it on the same page of the rivew of the ssrs in visual studio.there is one botton, just before the font size ,caled export .just check there .you can export to any format you want.those are tiff format,webarchiev format,pdf and excel format thanks and regards mahasweta Tag: Personal Web Developer Kit SQL Error
- 1
- Previous
Re: Personal Web Developer Kit SQL Error
Arnie Rowland
In the default installation, SQL Server installs with very tight security.
Please refer to these articles for help in setting the correct configuration parameters.
Configuration -Configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/default.aspx scid=kb;EN-US;914277
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx
Configuration -Connect to SQL Express from "downlevel clients"
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx
Configuration -Connect to SQL Express and ¡®Stay Connected¡¯
http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html
Configuration - Guideline for Connectivity Question Posting
http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=362498&SiteID=1
Re: Personal Web Developer Kit SQL Error
heebiej
I don't seem to have SQL Server 2005 installed (it's not in the start menu, nor in Program Files). Do you think this is the problem Do I need to install it, and if so, where from
I don't seem to have SQL Server 2005 installed (it's not in the start menu, nor in Program Files). Do you think this is the problem Do I need to install it, and if so, where from
Re: Personal Web Developer Kit SQL Error
Caddre
heebiej wrote:
I don't seem to have SQL Server 2005 installed (it's not in the start menu, nor in Program Files). Do you think this is the problem Do I need to install it, and if so, where from
That could be a problem after you install it you still need to use the surface area configuration tool to enable browser services and allow remote and local connection then enable both TCP/IP and Named Pipes. Try the link below to download SQL Server Express with Advanced features, one more thing there are many user improved version of this kit you may want to check the forum for this kit at the Asp.net forums. Hope this helps.
http://msdn.microsoft.com/vstudio/express/sql/download/advanced/default.aspx