|
More site info...
SQL Server 2005 | Forum profile
|
|
Forum profile page for SQL Server 2005 on http://www.eggheadcafe.com.
This report page is the aggregated overview from a single forum: SQL Server 2005, located on the Message Board at http://www.eggheadcafe.com.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "SQL Server 2005" on the Message Board at http://www.eggheadcafe.com is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on SQL Server 2005:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
13
|
65
|
208
|
|
Post:
|
44
|
230
|
705
|
|
|
SQL Server 2005 Posting activity graph:
|
Top authors during last week:
user's latest post:
Dynamic SQL : Database is...
Published (2009-01-07 01:53:00)
http://www.mydatabasesupport.com/forums/sqlserver-programming/188284-error-database-core-already-open-can-only-have-one-user-time.html https://forums.symantec.com/syment/board/message?board.id=115&thread.id=21495 http://p2p.wrox.com/access/8261-attempted-open-database-already-open.html
user's latest post:
SSRS-Exporting the image with...
Published (2009-01-08 07:50:00)
to get rendered but when export to excel. and in Rectangle --> Properties --> unter Visiblity tab --> Click kon show option. Hope this helps!
user's latest post:
Dynamic SQL : Database is...
Published (2009-01-07 06:10:00)
Could you post the exact error message, with message header and all? Also, which version of SQL Server are you using? Could try to compose a script that demonstrates the issue? Such a script would create databases, tables etc that are needed to reproduce the error message. An example to work from is below, although that script completes without errors. CREATE DATABASE DB1 CREATE DATABASE DB2 go USE DB1 go CREATE TABLE nisse(a int NOT NULL)...
user's latest post:
cannot resote the databse
Published (2009-01-01 03:12:00)
If the backup file is also Valid, then can you try performing the restoration using T- SQL commands intead of GUI, (a) RESTORE FILELISTONLY FROM DISK='D:\YourBackupfilename.bak' GO (b) RESTORE DATABASE NewDatabaseName FROM DISK='D:\YourBackupfilename.bak' WITH MOVE'LOgiclaName of the SOurceDatafile' TO...
user's latest post:
resore the SQl2005 Database into...
Published (2009-01-02 08:43:00)
To fully restore a SQL 2005 DB in SQL 2000 is to follow 3 steps: Script and recreate the objects without foreign keys Transfer the data Recreate the foreign keys.
user's latest post:
resore the SQl2005 Database into...
Published (2009-01-02 05:50:00)
http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/46e3ecf9-6eab-4aa0-9453-11e7269efb6e/ http://www.dbforums.com/showthread.php?t=1621105 http://www.dreamincode.net/forums/showtopic47963.htm http://support.microsoft.com/kb/833710 http://www.windows-tech.info/15/a8f91d482eeb062e.php
user's latest post:
views or Queries
Published (2009-01-02 04:00:00)
Security l Query Simplification 2 Allows Different Perspective 3 Schema Transparency / Location Transparency 4 Schema Consistency 5 Allows work-around for SQL limitations Security • to provide an additional level of table security by restricting access to a predetermined set of rows and/or columns of a table CREATE VIEW emp_sal_hist_v AS SELECT ratehist.employee, ratehist.beg_date, ratehist.pay_rate FROM ratehist, employee WHERE...
user's latest post:
SSRS-Exporting the image with...
Published (2009-01-08 08:14:00)
I found following option under the visibility tab of rectangle Visible Hidden Expression Checkbox for Toggling I don't find any "kon show" option I had selected "visible" Thanks Bhushan
user's latest post:
Dynamic SQL : Database is...
Published (2009-01-07 04:24:00)
This didn't solve my problem.I think my problem is due to dynamic sql because when i am executing same script but not dynamically then i don't get any error.In dynamic SQL,I am getting this error not at any particular table but i am getting this error at random on any of the table names. Please suggest some work around.
|
|
|
|
Latest active threads on SQL Server 2005::
Started 22 hours, 52 minutes ago (2009-01-08 10:35:00)
by ahmad khan
Hi I have quite similar problem as being discussed in these forums regarding calculating minutes from starttime and stoptime. I am engineering student , i need to compute number of processes executed in given interval say for example 5 minutes. Consider the following process alpha starts at 13:10:09(starttime) and its duration is 240 seconds . I found out it end time by simply using dateadd ...
Started 1 day, 4 hours ago (2009-01-08 04:30:00)
by parth bera
Our team is going to develop a ERP for a hospital. It has to be able to run on LAN with one server (MSSQL Server 2005). And we want to develop a small website for patients to find doctors and make appointments. So, I want to know if it is possible to connect to the same database using a website (ASP.NET using C#). We are not buying a private IP for the server as it is ...
Started 1 day, 2 hours ago (2009-01-08 07:24:00)
by Bhushan Laddad
Hi All, In my ssrs report i have a gif image which has conditional visibility. When I export the report to Excel , the image doesn't appear in the excel report even though it is visible in actual report. I had set the Data Output Tab to "Yes" of rectangle in which the image placed, but it didn't get worked. Pls I need urgent help for this. Thanks Bhushan
Started 1 day, 8 hours ago (2009-01-08 00:59:00)
by Vasanthakumar D
Hi, you should have the sysobjects, systables like tables created by server automaticllay, when new db is created. Becuase these table are necessary and maintaing the metadata of your tables, views, and other db objects. you can create a new db with someother name and copy the old user created tables of old dB to new database. and migrate data to your new db. and change the name of the ...
Started 2 days, 8 hours ago (2009-01-07 01:01:00)
by kavita agarwal
Hi, my requirement is to put a database in single user mode and perform some operation on it.I am using dynamic query to perform those operations.After making database in single user mode,it's giving error message "Database 'DBName'is already open and can only have one user at a time". Sample code is as follows which i am executing on DB1.This code is executing in loop for different table...
Started 2 days, 4 hours ago (2009-01-07 05:21:00)
by C_A P
This problem occurs because of memory utilization after you install SQL Server 2005 SP2. When you use SMO to generate SQL scripts, the task uses lots of memory. When the operating system cannot provide sufficient memory, you experience this problem. RESOLUTION The fix for this issue was first released in Cumulative Update 5. For more infor... loadTOCNode(1, '...
Started 2 days, 4 hours ago (2009-01-07 05:15:00)
by sri sri
Hi, Try the following query select sum (A.hrs), A.col_all from ( select hrs , col_owner as col_all from <tablename> group by col_owner union select hrs , col_tenant as col_all from <tablename> group by col_tenant) A group by a.col_all
Started 2 days, 9 hours ago (2009-01-07 00:00:00)
by Ketan Mer
http://social. msdn.microsoft.com/forums/en-US/sqlr eportingservices/thread/1a49d883-238c-4a29-aa05-a7 6a5e8ce4f0/
Started 5 days, 21 hours ago (2009-01-03 12:12:00)
by srilu k
Hi, I have a requirement that- Using sql server 2005, I should be able to connect to Exchange server and retrieve mails from Inbox into the database. Can anyone help me regarding this or give your suggestions? Thank You.
Started 1 week ago (2009-01-02 04:58:00)
by vamsi n
My object is resstore the SQL 2005 Databse into SQL 2000 MY database is existed in SQL2005,DB name is --'MyOLD_DB', i followed the following steps to restore the DB from SQL2005 to SQL2000( SP3): in sql2005 : 1. ALTER DATABASE MyOLD_DB SET SINGLE_USER 2. EXEC sp_dbcmptlevel MyOLD_DB, 80; 3. ALTER DATABASE MyOLD_DB SET MULTI_USER after these steps i took the Backup with the name...
|
|
Hot threads for last week on SQL Server 2005::
Started 1 week, 1 day ago (2009-01-01 01:18:00)
by jagadeep suggula
hello guys i had recently installed SQL SERVER 2005 enterprise edition on my server. my server already had sql server 2000, after the installation i found that my database is not restoring and the wonder i observed is the version in 2005 is showing as 8.0....... which actually must be 9.0....... what would be the reason for the error i am getting, can i run both 2000 and 2005 versions on the ...
Started 1 week ago (2009-01-02 04:58:00)
by vamsi n
My object is resstore the SQL 2005 Databse into SQL 2000 MY database is existed in SQL2005,DB name is --'MyOLD_DB', i followed the following steps to restore the DB from SQL2005 to SQL2000( SP3): in sql2005 : 1. ALTER DATABASE MyOLD_DB SET SINGLE_USER 2. EXEC sp_dbcmptlevel MyOLD_DB, 80; 3. ALTER DATABASE MyOLD_DB SET MULTI_USER after these steps i took the Backup with the name...
Started 1 week, 1 day ago (2009-01-01 03:46:00)
by Mohammed Abdul Azeem
Hi, will anybody please provide me 10 reasons to opt for Views over Queries. Performance is the main concern. Regards
Started 2 days, 8 hours ago (2009-01-07 01:01:00)
by kavita agarwal
Hi, my requirement is to put a database in single user mode and perform some operation on it.I am using dynamic query to perform those operations.After making database in single user mode,it's giving error message "Database 'DBName'is already open and can only have one user at a time". Sample code is as follows which i am executing on DB1.This code is executing in loop for different table...
Started 1 day, 4 hours ago (2009-01-08 04:30:00)
by parth bera
Our team is going to develop a ERP for a hospital. It has to be able to run on LAN with one server (MSSQL Server 2005). And we want to develop a small website for patients to find doctors and make appointments. So, I want to know if it is possible to connect to the same database using a website (ASP.NET using C#). We are not buying a private IP for the server as it is ...
Started 1 day, 2 hours ago (2009-01-08 07:24:00)
by Bhushan Laddad
Hi All, In my ssrs report i have a gif image which has conditional visibility. When I export the report to Excel , the image doesn't appear in the excel report even though it is visible in actual report. I had set the Data Output Tab to "Yes" of rectangle in which the image placed, but it didn't get worked. Pls I need urgent help for this. Thanks Bhushan
Started 1 week, 1 day ago (2008-12-31 09:31:00)
by xa D
Started 5 days, 21 hours ago (2009-01-03 12:12:00)
by srilu k
Hi, I have a requirement that- Using sql server 2005, I should be able to connect to Exchange server and retrieve mails from Inbox into the database. Can anyone help me regarding this or give your suggestions? Thank You.
Started 2 days, 9 hours ago (2009-01-07 00:00:00)
by Ketan Mer
http://social. msdn.microsoft.com/forums/en-US/sqlr eportingservices/thread/1a49d883-238c-4a29-aa05-a7 6a5e8ce4f0/ | |
Size: 1,042 bytes
