pls advise me. HELP pls...

on the 1st opening of my web page it uses the membership control of asp.net
for logging on. sometimes it takes time to logon and worse is, it will
encounter sql server error. that can be resolved by just restarting that
specific page and it will be alright, it will logon normally. this only issue happens only on the first opening of the logon page.

i have read a certain article and it says there that on the first time
you access the sql server, sometimes the sql server needs a little more
time communicating back and forth.

how can i make my log-on page wait a little longer till it communicates
or finishes communicating to the sql server?

im afraid that this may happen once i deploy my web project. i am
expecting over 100 users and they might save to the database all
together. will i encounter problem on this particular?

i am using ASP.NET 2.0 and SQLExpress for this project. pls advise me.
BIG THANKS.

Hi,

what sort of error do you get ? If you are getting a commandTimeout error you can set the commandTimeout property in your application a bit higher to achieve that the command can have a bit more time to execute.

HTH;, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Jens Suessmeyer wrote:

Hi,

what sort of error do you get ? If you are getting a commandTimeout error you can set the commandTimeout property in your application a bit higher to achieve that the command can have a bit more time to execute.

HTH;, Jens Suessmeyer.

http://www.sqlserver2005.de

thanks Jens. that is exactly what i need. thanks a lot man!
|||just a question....

my web project is using SQL Express2005 and ASP.NET and C#.
my web hosting company only have MSsql2000. would there beany conflict with regards to my database? im sorry if i sound dumb. im a newbie to this.
thanks
|||Hi,

if you hosting company only supports MSDE or MSSQL 2000, I would not use SQL Server Express as a basis of development. I would rather use 2000, because you won't have any problem transfering the database from your development pc to the hosting company.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de
|||i am only using one mdf file and my asp.net program just deals with the common add, edit, delete transactions. would these transactions differ from version to version of MSSQL?

honestly i did not think there would be a problem coz these transactions are very common. pls correct me if i am wrong.
|||No, you are sure right, but as of my experiences as a developer I would rather rely on the same system (even on the same SP level) than using a more sophisticated version of the database. But you are right that in case you don`t use any other stuff like doing standard DML there should be no problem.

HTH, Jens Suessmeyer.

http://www.sqlsever2005.de
--|||i just installed MSDE. i tried attaching my mdf file (created by SQL Express) to the MSDE but i got this error message:

"An error occured when attaching the database"

i attached that mdf file to the SQL Express and i encountered no problem at all. is this the problem you are talking abt Jens? do you think i will encounter the same problem with my hosting company?

thanks a lot for your time Jens.
|||SQL Express datafile have a different storage structure than the SQL2k files. YOu can't do that. If you want transfer the database to the SQL2k you have to do scripting of the objects to transfer the data to the prior SQL2k5 databases.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||can I implement the membership control (provided by ASP.NET) on MSDE? i can try migrating from SQLEXxpress to MSDE but im not sure if membership control works on that MSDE. sorry if i really sound dumb. im a newbie.
|||

Hi,

habe a look here:

http://aspnet.4guysfromrolla.com/articles/120705-1.aspx

"Use the ASP.NET SQL Server Registration Tool (aspnet_regsql.exe) command-line tool (use this tool to implement the schema in a SQL Server 2000 or 2005 database) "

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Please help! Suspended/Stalled Query

Hi,

I am having a problem with one package that attempts to do a join on two large tables. Within the data flow task control is the ole db source control which has the initial query that joins and filters the tables.

The total number of rows that should be returned are about 80-90million. Running this in debug mode shows the number of rows read/inserted into the ole db destination and it always hits the about the same number of records where it just stops/stalls/suspends around 75 million. I have read some possible solutions such as changing the max degrees of parrallelism but that has not worked.

I am currently using SQL Server 2005 64bit SP2 on a 64 bit platform. This is the only package that does anything like this and I am at my wit's end with this problem.

Please help!

Thanks,
Cheston

Can you share some more information about what's in your data flow? Sorts, aggregates, OLE DB Commands, etc...

Also, what happens when you run this without debugging?

|||

SELECT FCT_POST_MTHLY_FINANCE_REVENUE.POST_MTHLY_FINANCE_REVENUE_KEY, FCT_POST_MTHLY_FINANCE_REVENUE.SUBSCRIBER_KEY,
FCT_POST_MTHLY_FINANCE_REVENUE.MSF_REVENUE, FCT_POST_MTHLY_FINANCE_REVENUE.SAF_REVENUE,
FCT_POST_MTHLY_FINANCE_REVENUE.AIRTIME_REVENUE, FCT_POST_MTHLY_FINANCE_REVENUE.LD_INTL_REVENUE,
FCT_POST_MTHLY_FINANCE_REVENUE.LOAD_TS, FCT_POST_MTHLY_FINANCE_REVENUE.ROAMING_REVENUE,
FCT_POST_MTHLY_FINANCE_REVENUE.LD_CAN_REVENUE, FCT_POST_MTHLY_FINANCE_REVENUE.BILL_MONTH_KEY,
FCT_POST_MTHLY_FINANCE_REVENUE.DATA_ON_VOICE_REVENUE, FCT_POST_MTHLY_FINANCE_REVENUE.UPDATE_TS,
FCT_POST_MTHLY_FINANCE_REVENUE.OPTIONAL_REVENUE, FCT_POST_MTHLY_FINANCE_REVENUE.MISCELLANEOUS_REVENUE,
FCT_POST_MTHLY_FINANCE_REVENUE.SIF_REVENUE, FCT_POST_MTHLY_FINANCE_REVENUE.LD_US_REVENUE,
FCT_POST_MTHLY_FINANCE_REVENUE.CONSOLIDATED_REVENUE, FCT_POST_MTHLY_FINANCE_REVENUE.ARPU_TOTAL_REVENUE,
FCT_POST_MTHLY_FINANCE_REVENUE.UNCLASSIFIED_REVENUE
FROM FCT_POST_MTHLY_REVENUE_NEW RIGHT OUTER JOIN
FCT_POST_MTHLY_FINANCE_REVENUE ON
FCT_POST_MTHLY_REVENUE_NEW.BILL_MONTH_KEY = FCT_POST_MTHLY_FINANCE_REVENUE.BILL_MONTH_KEY AND
FCT_POST_MTHLY_REVENUE_NEW.SUBSCRIBER_KEY = FCT_POST_MTHLY_FINANCE_REVENUE.SUBSCRIBER_KEY
WHERE (FCT_POST_MTHLY_REVENUE_NEW.SUBSCRIBER_KEY IS NULL)

This is my query that I am trying to run. Actually all I am currently trying to do is a row count. It gets suspended there as well at the same number as when I was trying to direct the data into a table.

BTW, it stops exactly at 75, 627, 900

|||

So basically you have the OLE DB source and simply a row count transformation and it hangs? (Just the two components on the data flow?)

Have you made sure that your query isn't timing out, or network related? SQL Profiler can help here.

Also, I'm still curious to know what happens when you run this without debugging.

|||

Yes, there are only 2 components to the data flow.

I do not believe it the query timing out or network related but I will investigate into that. Also will try running it without debugging and seeing if it works.

|||

Audit Logout Microsoft SQL Server Management Studio 0 0 0 340000 3644 53 2007-03-10 17:55:21.153 2007-03-10 18:01:01.153
Audit Login -- network protocol: LPC
set quoted_identifier on
set arithabort off
set numeric_roundabort off
set ansi_warnings on
set ansi_padding on
set ansi_nulls on
set concat_null_yields_null on
set cursor_close_on_commit off
set implicit_transactions off
set language us_english
set dateformat mdy
set datefirst 7
set transaction isolation level read committed
Microsoft SQL Server Management Studio Administrator 3644 53 2007-03-10 18:01:01.153

Hey Phil,

I did the trace on the package with just the row count. The above is what keeps repeating once I hit the 75, 627, 900 records. I am unfamiliar with what this is, can you explain?

|||quick bump|||From what you describe it could be a deadlock situation.

Look at the Activity Monitor and see WHY it is stalled.