Search results for query: *

I am trying to set up 2005 RS for the first time and am able to successfully login to the site when using Firefox but when I try using IE I get the error message that I am not authorized to view the page, I have this issue across multiple versions of IE. Your thoughts? Thanks so much! P

I need to loop thru all databases on an instance of SQL Server, If tblOrder exists in the database I want to extract the number of rows bases on the datecreated field into another table. Does anybody have a recommendation on how to handle? Thanks!

Do I need to have windows 2003 Enterprise Edition to install SQL Server 2005 Enterprise Edition?

Could someone confirm for me if I need to have Enterprise Edition to implement table partitioning in SQL 2005? Thanks

George your solution was perfect! Thanks for everybody's help!

I am having difficultly working the logic out for this - I have this table: P S D StoreA Widget1 1 1 1 StoreB Widget1 3 5 2 StoreC Widget1 2 3 3 StoreD Widget1 2 2 4 StoreA Widget2 3 3 1 StoreB Widget2 2 3 2 StoreC Widget2 2 3 3 StoreD Widget2 1 2 4 StoreA Widget3...

Could you clarify what you mean by viewer application? Do you mean the Crystal XI viewer? Thanks!

Thanks Ken! Makes total sense and better yet works!

I have just started a project where the Crystal reports are not embedded in the project and we do not have Crystal Enterprise. Does anybody have suggestions as to how we pass parameters to the reports? Do We need to build an interface in C# that passes the parameters to the reports or if we...

I am trying to set my margins to zero in page set up in Crystal XI R2 but it keeps defaulting back to 0.166. Anybody have a work around for this? Thanks!

I am trying to identify what logins are currently browsing my development server, could somebody help me with which tool I should be using to accomplish this? Thanks!

Thanks Biglebowski!

I am trying to bulk insert a table that is 40 gb. I believe it would be in my best interest to adjust the size of the database to this size before inserting the data, does anybody have an opinion on this? Also, how much time will it take to grow a db from 1 gig to 40 gb. Thanks so much!

What rights do I need to provide to a nonadministrative login to use profiler? Thanks!

My transaction logs are being utilized by SQL Server even though the recovery mode is Simple...... I was creating an index at the time and running SPs as well. How does that happen? Thanks!

Makes sense, will the locks stay in place until the full update is complete? It's been running for several hours

I have a programmer who has created a massive temporary table that inserts into another massive table with no commits (80 gigs). Currently, he has over 30,000 locks on tempdb, any idea what causes this or if it might be a problem with SQL SERVER and not the code?

Yes I just used the DTS wizard to copy the data over

The tlogs are on the same drive

It took the DTS wizard 6 hours to move a table with 3 million records from one db to another on one box, but only takes me approximately 10 minutes to transfer the same data inside the same database. Any thoughts as to what I should do to fix this? Thanks