|
More site info...
SQL Server Tools General | Forum profile
|
|
Forum profile page for SQL Server Tools General on http://technet.microsoft.com.
This report page is the aggregated overview from a single forum: SQL Server Tools General, located on the Message Board at http://technet.microsoft.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 Tools General" on the Message Board at http://technet.microsoft.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 Tools General:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
29
|
236
|
742
|
|
Post:
|
46
|
364
|
1,261
|
|
|
SQL Server Tools General Posting activity graph:
|
Top authors during last week:
user's latest post:
How To Clear Log files of all...
Published (2008-11-28 05:43:00)
Hello Prakash If the transacational log files are growing increasingly, then do the following operation for every operation. Backup Log Yourdatabasename With Truncate_Only Use Yourdatabasename DBCC ShrinkFile (logicalLogfilename,minimumsize) sp_helpfile will give you logical filename Check this for more info http://forums.microsoft.com/MSDN/showpost.aspx?postid=2523636&siteid=1 Thanks Sreekar Please mark...
Jens K. Suessmeyer - MSFT
3
user's latest post:
MS Access SQL connectivity...
Published (2008-11-29 09:23:00)
Well, can be several things. First make sure that you open the database exclusivly. Do you have a workgoup file applied to the access database ? BTW, are you using a linked server or with which method are you accessing the database ? Jens K. Suessmeyer http://blogs.msdn.com/JensS
user's latest post:
MSSQL2005 Generate Script...
Published (2008-11-28 10:03:00)
Hi Alok, You are right, it is due to I turn on "include if not exist clause". Thank you very much! Regards, JiQing
user's latest post:
StartResourceService: Failed to...
Published (2008-11-28 02:14:00)
Vidya thanks for your post... Its Active/Passive cluster... below is the content of sqlagent.out file 2008-11-23 20:41:07 - ? [393] Waiting for SQL Server to recover databases... 2008-11-23 20:41:18 - ? [100] Microsoft SQLServerAgent version 8.00.2039 (x86 unicode retail build) : Process ID 2008-11-23 20:41:18 - ? [100] Microsoft SQLServerAgent version 8.00.2039 (x86 unicode retail build) : Process ID 2724 2008-11-23 20:41:18 - ?...
user's latest post:
SQL Query Analyzer vs. isql -...
Published (2008-11-27 09:30:00)
1. Why did I get the error message when I used query analyze, but no error when I used isql? When you connect through query analyzer all your ansi defaults for your connection will be set to ON by default.. (Execute "DBCC USEROPTIONS" to know the values set to on) because of this ANSI_WARNINGS is also set to on hence you are getting this error message. When you connect through isql, all ansi defaults for your connection is...
user's latest post:
sql - TechNet Forums
Published (2008-11-26 06:15:00)
Have you tried using remote SSMS to connect your SQL Server?
user's latest post:
MSSQL2005 Generate Script...
Published (2008-11-26 13:28:00)
Hi, It seems your scripting option "include if not exist clause" is true. You can try scripting by setting this to false in Tools-> Scripting ->Object Scripting options->Include If not exist clause. Regards, Alok Parmesh Please remember to click 'Mark as Answer' on the post that helped you. Unmark if it provides no help
user's latest post:
Looking for some free available...
Published (2008-11-26 15:03:00)
I'm looking for some free available tool to track all SQL Server database operations executed from an application (it's an ASP.Net application) . It's like when I run the application, I can attach the application process to the Tool and the Tool can log all the database operations done by the application. This normally makes the troubleshoot something very fast, rather than looking at the some huge code. Thanks
|
|
|
|
Latest active threads on SQL Server Tools General::
Started 5 days, 12 hours ago (2008-11-29 04:47:00)
by PaulTomov
Hi, Please explain me how to solve my Acces database connectivity problem reported as: "The Microsoft database engine cannot open the file '(unknown)'. It is already open exclusively by another use or you need permission to view its data. [Microsoft][ Driverdriver Manager] Driver's SQLSetConnectAttr failed." I was trying to complete some SQL queries to an ...
Started 2 weeks, 4 days ago (2008-11-16 05:44:00)
by Naomi Nosonovsky
Hi everybody, I found two problems with SQL Server Express 2008 on Windows Vista Home Premium. 1. When I try to access Help, the mouse cursor becomes a circle which drags every second. 2. When I try to create a new stored procedure, the Ctrl + Shift + M menu does nothing. The dialog of inserting Author, Procedure Name, etc. does not appear. Has anyone else...
Started 6 days, 12 hours ago (2008-11-28 05:02:00)
by krishtech
Hi I have more than 100 database attaached in ms sql server . i want to clear all database .log file simultanesly. How can i do that with all databases. Thanks & Regards Prakash 9374021782 krish
Started 6 days, 7 hours ago (2008-11-28 10:29:00)
by UdiCho
p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt ;font-family:' Times New Roman';} @page Section1 {size:8.5in 11.0in;margin:1.0in 1.25in 1.0in 1.25in;} div.Section1 {page:Section1;} Hi I am trying to send Emails from sql server 2005 Management Studio. I have configured the database mail from wizard and I have ...
Started 1 week ago (2008-11-26 20:27:00)
by Grinn Daddy
I'm running dual monitors with the primary monitor on the left, and the other monitor on the right. I open Microsoft SQL Server Management Studio 2008 in the left monitor. When I right-click on the Object Explorer Details (in the left monitor) the right-click menu appears to the far-left of my right monitor. This is quite a neusance, and I was curious as to if this was a previously ...
Started 1 year, 3 months ago (2007-08-15 19:05:00)
by cborden
just wanted to confirm that this u_tables.sql solution worked for me as well, although the table was just empty, not deleted. In our case, it's an x64 Enterprise server that had been recently renamed. The problem might have been caused during the rename process where one of the system admins didn't run a script to correct the name in sysservers, but I'm not quite ...
Started 3 weeks, 6 days ago (2008-11-07 10:29:00)
by a.christov
Hi guys! I have a fresh installation of SQL 2008 x86 on Vista Business. When I try to attach a database I get the following exception: TITLE: Microsoft SQL Server Management Studio ------------------------------ Cannot show requested dialog. ------------------------------ ADDITIONAL INFORMATION: Cannot show requested dialog. (SqlMgmt) ------------------------------ Could ...
Started 1 week, 2 days ago (2008-11-25 09:19:00)
by jacques688
I do not know what tiggers this change. when i generate script in mssql2005,the script becomes dynamic statement instead of static statement: dynamic: EXEC dbo . sp_executesql @statement = N '/* CREATE procedure [dbo].[s_test] @inxml ntext as ' static: CREATE procedure [dbo] . [s_test] @inxml ntext as It is hard to read,how can I ...
Started 6 days, 20 hours ago (2008-11-27 21:10:00)
by Ifahad
Hi I have developed an application in .net, now i want to transfer the backend database to another machine. I have already installed the MS sql server on other machine. Is there any easy way so I dont have to create whole database on other machine manually.
Started 1 year, 2 months ago (2007-09-10 11:13:00)
by Welly Jotam
Dear all, We have problem with SQL Server Agent service running on Fail-Over Cluster at Windows Server 2003 R2 Enterprise Edition. Agent service won't started. These error founded in Event Viewer : System Event Log ================ Event Type: Error Event Source: ClusSvc Event Category: Failover Mgr Event ID: 1069 Date: 1/11/1990 Time: 5:48:55 PM User: N/A Computer: JSXDBET1 ...
|
|
Hot threads for last week on SQL Server Tools General::
Started 1 week, 1 day ago (2008-11-25 18:18:00)
by mb_raiders1
I am running SQL Server 2000 Standard Edition (Product Version 8.00.2039 SP4) on Windows 5.0 (2195). I have a maintenance plan that backs up the the database every night at 10:00 PM. It has failed several times in a row with the following messages written to the log: First Error Message: Source: spid 88 Message: BackupMedium::ReportIoError: write failure on backup device 'H...
Started 6 days, 12 hours ago (2008-11-28 05:02:00)
by krishtech
Hi I have more than 100 database attaached in ms sql server . i want to clear all database .log file simultanesly. How can i do that with all databases. Thanks & Regards Prakash 9374021782 krish
Started 1 week, 2 days ago (2008-11-25 09:19:00)
by jacques688
I do not know what tiggers this change. when i generate script in mssql2005,the script becomes dynamic statement instead of static statement: dynamic: EXEC dbo . sp_executesql @statement = N '/* CREATE procedure [dbo].[s_test] @inxml ntext as ' static: CREATE procedure [dbo] . [s_test] @inxml ntext as It is hard to read,how can I ...
Started 1 week ago (2008-11-26 20:27:00)
by Grinn Daddy
I'm running dual monitors with the primary monitor on the left, and the other monitor on the right. I open Microsoft SQL Server Management Studio 2008 in the left monitor. When I right-click on the Object Explorer Details (in the left monitor) the right-click menu appears to the far-left of my right monitor. This is quite a neusance, and I was curious as to if this was a previously ...
Started 6 days, 20 hours ago (2008-11-27 21:10:00)
by Ifahad
Hi I have developed an application in .net, now i want to transfer the backend database to another machine. I have already installed the MS sql server on other machine. Is there any easy way so I dont have to create whole database on other machine manually.
Started 1 year, 2 months ago (2007-09-10 11:13:00)
by Welly Jotam
Dear all, We have problem with SQL Server Agent service running on Fail-Over Cluster at Windows Server 2003 R2 Enterprise Edition. Agent service won't started. These error founded in Event Viewer : System Event Log ================ Event Type: Error Event Source: ClusSvc Event Category: Failover Mgr Event ID: 1069 Date: 1/11/1990 Time: 5:48:55 PM User: N/A Computer: JSXDBET1 ...
Started 1 week ago (2008-11-27 10:53:00)
by pradeep_TP
Hi All, Where do I post my question related to SQL management Studio. thanks.
sql - 2 new posts
Started 1 week, 2 days ago (2008-11-25 06:18:00)
by er.Sonia
hi all I am getting this problem when i connect to management studio. I have reinstalled the SQL Server many times but the problem is still persisting TITLE: Microsoft SQL Server Management Studio ------------------------------ Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.VisualStudio.OLE.Interop.IServiceProvid er'. This operation failed because the ...
Started 1 week, 1 day ago (2008-11-26 15:03:00)
by Vivek Natani
I'm looking for some free available tool to track all SQL Server database operations executed from an application (it's an ASP.Net application) . It's like when I run the application, I can attach the application process to the Tool and the Tool can log all the database operations done by the application. This normally makes the troubleshoot something very fast, rather than looking at the some... | |
Size: 960 bytes
