Using the Microsoft SQL Server Protocols Forum

Referencing images on a hard drive from reporting services 2005

Wed, 24 Sep 2008 00:23:52 Z

1. I have picture images on hard drive(s) simular to the following, the images are not stored in the database only a reference. The images will always be on the same PC running sql server.
c:\cyclops\2008\08\29\imag1.jpg
e:\test\2007\07\02\image2.jpg

2. I have a field in the sql 2005 database that stores the location of each image as shown above.
3. I have created the following sql to return the image location from the database (Select ReportImage from ReportImage).
4. I have used a table with an image item within a body cell and set the folowing properties for the image item using reporting services 2005:
Source = External
Value = =Fields!ReportImage.Value
MIMEType = image/jpeg

4. When I run the report in preview mode I get the following error:

[rsUnsupportedProtocol] The image ‘image5’ has the URL “C:\Documents and Settings\steveha\My Documents\My Pictures\vcimage.bmp” as one of its properties. URLs in reports must begin with one of the following prefixes: http://, https://, ftp://, file:, mailto:, or news:.

5. So my question is how do you display images within a report where the images are on a hard drive and not in the database or on a web page? Thousands of these images exist and there size can be upto 200K.

BizTalk Server capacity

Mon, 14 Sep 2009 10:13:02 Z

Hi,
I want some pointers to the max capacity limits of BizTalk server. Like max number of databases, hosts , host instances, max size of databases.
Can someone guide me about this ?

Thanks in advance,
Sachin Pol

How to reset the Identity Value if any value deleted in mid or atlast.

Thu, 10 Sep 2009 08:13:09 Z

AdventureWorks
GO
/* Create a table with one identity column */
CREATE TABLE TableID (ID INT IDENTITY(1,1), Col VARCHAR(10))
GO
/* Insert 10 records with first value */
INSERT INTO TableID (Col)
VALUES ('First')
GO 10
/* Check the records in table */
SELECT *
FROM TableID
GO
/* Delete last few records */
DELETE
FROM TableID
WHERE ID IN (8,9,10)
GO
/* Check the records in table */
SELECT *
FROM TableID
GO
/* Get current Max Value and reseed table */
DECLARE @MaxID INT
SELECT @MaxID = MAX(ID)
FROM TableID
DBCC CHECKIDENT('TableID', RESEED, @MaxID)
GO
/* Insert 10 records with second value */
INSERT INTO TableID (Col)
VALUES ('Second')
GO 5
/* Check the records in table */
SELECT *
FROM TableID
GO
/* Clean Database */
DROP TABLE TableID
GO

CREATE TABLE TableID (ID INT IDENTITY(1,1), Col VARCHAR(10))
GO
/* Insert 10 records with first value */
INSERT INTO TableID (Col)
VALUES (’First’)
GO 10
/* Check the records in table */
SELECT *
FROM TableID
GO
/* Delete records from middle and bottom both*/
DELETE
FROM TableID
WHERE ID IN (4,7,11,12)
Go
/* Check the records in table */
SELECT *
FROM TableID
GO
/*
Now check the missing identity values
To Do so we will create a memory table with a sequential number,
from 1 to the ident_current value and join that to the live table.
*/
Declare @rows Int
Declare @numberOfRowsToInsert Int

declare @seq table (
seq int not null primary key
)
/* Get current Max Value and reseed table */
SELECT @rows = MAX(ID) FROM TableID
DBCC CHECKIDENT(’TableID’, RESEED, @rows)
set @rows = (select Ident_Current(’TableID’)) + 5
/* Insert values into Memory table */
declare @i int
set @i = 1
while @i <= @rows
begin
insert @seq values( @i )
set @i = @i + 1
end
/* Now set the Identity Insert On, so that we can insert any number */
Set Identity_Insert TableID On

INSERT INTO TableID(Id,col) Select seq,’Third’
From @seq left outer join TableID T on seq = T.ID
Where T.ID Is Null

Set Identity_Insert TableID OFF
/* Check the records in table */
SELECT *
FROM TableID
GO
/* Clean Database */
DROP TABLE TableID
GO

Ravishankar Maduri MCTS,MCPD,MCP

Error when installing replication on a Vista x64 machine

Mon, 29 Jun 2009 09:56:25 Z

When I use Replication.Distributor.Install from an app on a Vista x64 machine I get the following error: Unable to create Distribution database:
-2147207391 - [Mirosoft][ODBC SQL Server Driver][SQL Server]Could not execute "C:\Program Files ^(x86^)\Microsoft SQL Server\80\Tools\binn\osql" -E -S"VistaX64\SL" -I60 -t60 -d"distribution" -b -i"C:\Program Files ^(x86^)\Microsoft SQL Server\MSSQL$SL\install\instdist.sql" -o"C:\Program Files ^(x86^)\Microsoft SQL Server\MSSQL$SL\install\instdist.out"

As far as I can tell there is a problem with the path (^). I am using MSDE 2000.

Kind Regards
Eric Cann

When will Microsoft release the binary specs for SQL Server database files?

Fri, 22 May 2009 20:08:41 Z

I need to be able to access these files on Unix / Linux and possibly mainframe based computer systems. Read access is all that is required. I need official Microsoft documentation or as an alternative routines written in C++ that can be used to compile on a Unix platform and access the MDB files. Installing Microsoft products or utilities is not an option unless they run on a Unix and Linux based system. The content of these files is most likely medical records but is not limited to that information. 3rd party reverse engineered information is not acceptable or suitable. Accuracy and completeness of information is critical.

Protocol Violation

Tue, 12 May 2009 00:44:11 Z

Hi There,

While making a HTTPRequest inside CLR Stored proc. I am getting a protocol violation inside the SQL Server Stored Procedure.

Unfortunately I cant use unsafeheaders=true tag. Could you please help me in getting around this issue?

Any help would be greatly appreciated

Thanks,
Nitin

I don't know if this is the correct forum...

Sun, 15 Mar 2009 01:45:37 Z

...but I'm new to using SQL in C# and I need to know how to do a couple of things:

1) How do I create a SQL database?
2) Once I've created it, how do I add tables and columns to it?
3) Once I've added the table and columns how do I insert data into the tables and columns?

I've done some reading of the documentation and it looks like I need to create a SqlConnection object and pass it a bunch of strings, but I can't figure out what each of the strings mean, or if the database needs to already exist before I create the SqlConnection command.

If this is the wrong forum to post this question, then please point me to the correct one. I have a project that is due by Monday, and if I don't complete it, then I'm probably going to get fired- so somebody, please, please help me!
Thanks,
--Jeremy

Table Design

Thu, 05 Feb 2009 22:00:30 Z

Hi Guys!

I have to create a table in SQL Server 2000 with the structure like:

St_ID St_Name 1 2 3 4 5...... 31

1 Jom P

2 John P

3 Kemp A

This table will store the student’s roll calls on daily basis ‘A’ is for absent and 'P' for present and 1, 2, 3, 4 ….. 31 are the days on which roll call will be marked

My question: is it possible to create a table in this fashion so it only records their attendance daily??? Because its structure is alot different from normal scenario that is i'm concentrating on columns rather than rows… i want to enter data into the columns only… i have nothing to do with St_ID and St_Name but each time i have to enter data for days (1, 2, 3, 4… 31) column.

Kindly, inform me if i have posted the thread in the wrong Place... and kindly direct me where should i post... need help coz i'm new to forums

Thanks beforehand

Yours Truly,

Ned

message format request for 1434

Sun, 08 Feb 2009 19:39:46 Z

the 9 SQL open specifications are a very small part of the whole proprietary SQL landscape
- even more so if you realise that 3 belong to MS Office and have no SQL content !

my current interest is to discover the formats of request and response to 1434 poll (to SQL Browser)
- ie UDP broadcast out and UDP reply from [unhidden] instances

FYI the reason is that I am frustrated by the SMO (and hence SQLCMD -Lc) lists that are atrocious to identify instances
- typically the server name is shown (eg MYSVR) and not the instances (MYSVR\BKUPEXEC, MYSVR\MSSERVER [default], etc)

By using Network Monitor (plaudit to MS for making available to non-SMS audience) I can see responses include protocol+port, version etc [even without a login to the instance(s)], but a formal definition would be appreciated

I had hoped that SQL2008 would be better at surfacing such riches, but without this I propose to write to network API to request and handle responses.

As this is one of the few (I only found another ONE!) targetted to this forum, hopefully MS will address this request properly and quickly

TIA
Dick

free download microsoft windows xp professional service pack (sp) 2

Tue, 03 Feb 2009 21:18:01 Z

WHAT`S THE BEST STEPS IN DOWNLOADING, TRYOUT VERSION

Too whom it`s concern

LogFile Class

Tue, 03 Feb 2009 00:22:42 Z

I'm workin with System::IO::Log::FileRecordSequence class and System::IO::Log::LogRecord class in this way:

System::IO::Log::FileRecordSequence ^ fLog = gcnew System::IO::Log::FileRecordSequence("C:\Program Files\MicroSoft SQL Server\MSSQL\data\AdvisorTest_Log.LDF");

for each (System::IO::Log::LogRecord ^ reg in fLog->ReadLogRecords(fLog->BaseSequenceNumber, System::IO::Log::LogRecordEnumeratorType::Next)
{
...
}

Can somebody help me???????

Thanks.

mike

how o fetch specific data from table

Tue, 20 Jan 2009 10:54:43 Z

hi all

here i hv a table
id         name           age....
1           anu              12
2           anu              13
34         radha        23
12            anu            10

like this i have so many records of same name anu in my table which have unique id ,,,
but my task is to fetch the 3rd anus record without knowing id or age
how can i fetch tha perticular row's data
pls help its urgent//

why do we split one table to two table?please help

Wed, 31 Dec 2008 07:47:53 Z

hi guys,
suppose you have a Hospital database.in here i have one table by name of Doctors which has two columns:DocID,DocName
and one table by name of Patients which has 3 columns:PatientID,PatientNAme,DocID

my question is why couldn't we have one table which has 3 columns like this:
PatientID,PatientName,DocName

why do we split this table to two seperate table.do we do this because we dont want to waste memory.i mean do we do this because we dont want to repeat for example DocAli for example for 2000 patient.and instead we want to use code of DocAli.is this for memory maintaing.??????

Brainstorm your Brain and find solution,if no result stuck to Brainstormer.

Updating maintenance Plan in SQL 2005 gives unhandled exception

Mon, 29 Dec 2008 05:38:47 Z

Steps :

1. Created Maintenance Plan through wizard.
2. Modified it, i.e. Added "Maintenance Cleanup Task"
In this
Connection Combo Box Value :- Local Server Connction.
Radio button :- Backup Files

Search Folder and delete file based on extension:
While clicking on Browse (...) button for Folder dialogue box, following unhandled exception occured:==

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
Microsoft.SqlServer.Management.Smo.EnumeratorException: Failed to retrieve data for this request. ---> Microsoft.SqlServer.Management.Common.ConnectionFailureException: Failed to connect to server . ---> System.Data.SqlClient.SqlException: Login failed for user 'sa'.
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at Microsoft.SqlServer.Management.Common.ConnectionManager.InternalConnect(WindowsIdentity impersonatedIdentity)
   at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()
   --- End of inner exception stack trace ---
   at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()
   at Microsoft.SqlServer.Management.Smo.ExecuteSql.Connect()
   at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm)
   at Microsoft.SqlServer.Management.Smo.ExecuteSql.ExecuteWithResults(StringCollection query, Object con, StatementBuilder sb)
   at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb)
   at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType)
   at Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult result)
   at Microsoft.SqlServer.Management.Smo.SqlObjectBase.GetData(EnumResult erParent)
   at Microsoft.SqlServer.Management.Smo.Environment.GetData()
   at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci)
   at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request)
   at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request)
   --- End of inner exception stack trace ---
   at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request)
   at Microsoft.SqlServer.Management.SqlMgmt.BrowseFolder.FillDrives()
   at Microsoft.SqlServer.Management.SqlMgmt.BrowseFolder.Init()
   at Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintTaskFileCleanUpControl.buttonSelectFolder_Click(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
AppIDPackage
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/AppIDPackage.DLL
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
Microsoft.SqlServer.SqlTools.VSIntegration
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlTools.VSIntegration.DLL
----------------------------------------
Microsoft.VisualStudio.Shell.Interop
    Assembly Version: 7.1.40304.0
    Win32 Version: 7.0.4054
    CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll
----------------------------------------
Microsoft.VisualStudio.OLE.Interop
    Assembly Version: 7.1.40304.0
    Win32 Version: 7.0.4054
    CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
Microsoft.SqlServer.SqlTDiagM
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlTDiagM/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SqlTDiagM.dll
----------------------------------------
Microsoft.DataWarehouse.SQM
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.SQM.DLL
----------------------------------------
Microsoft.SqlServer.Instapi
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll
----------------------------------------
EnvDTE
    Assembly Version: 8.0.0.0
    Win32 Version: 8.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC/EnvDTE/8.0.0.0__b03f5f7f11d50a3a/EnvDTE.dll
----------------------------------------
SqlWorkbench.Interfaces
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlWorkbench.Interfaces.DLL
----------------------------------------
Microsoft.NetEnterpriseServers.ExceptionMessageBox
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.NetEnterpriseServers.ExceptionMessageBox/9.0.242.0__89845dcd8080cc91/Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll
----------------------------------------
ObjectExplorer
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL
----------------------------------------
ConnectionDlg
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ConnectionDlg.DLL
----------------------------------------
Microsoft.SqlServer.CustomControls
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.2047.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.CustomControls/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.CustomControls.dll
----------------------------------------
Accessibility
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
SqlMgmt
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlMgmt.DLL
----------------------------------------
Microsoft.SqlServer.RegSvrEnum
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.2047.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.RegSvrEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.RegSvrEnum.dll
----------------------------------------
System.Data
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
Microsoft.SqlServer.ConnectionInfo
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.ConnectionInfo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.ConnectionInfo.dll
----------------------------------------
System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Microsoft.SqlServer.SmoEnum
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.2047.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SmoEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SmoEnum.dll
----------------------------------------
System.Configuration
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Transactions
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
Microsoft.SqlServer.Smo
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.2047.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Smo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Smo.dll
----------------------------------------
Microsoft.SqlServer.SqlEnum
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.2047.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SqlEnum.dll
----------------------------------------
Microsoft.SqlServer.BatchParser
    Assembly Version: 9.0.242.0
    Win32 Version: 2005.090.2047.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/Microsoft.SqlServer.BatchParser/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.BatchParser.dll
----------------------------------------
msvcm80
    Assembly Version: 8.0.50727.3053
    Win32 Version: 8.00.50727.3053
    CodeBase: file:///C:/WINDOWS/WinSxS/x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.3053_x-ww_B80FA8CA/msvcm80.dll
----------------------------------------
System.Management
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll
----------------------------------------
ObjectExplorerReplication
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ObjectExplorerReplication.DLL
----------------------------------------
Microsoft.ReportViewer.WinForms
    Assembly Version: 8.0.0.0
    Win32 Version: 8.0.50727.42
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.ReportViewer.WinForms/8.0.0.0__b03f5f7f11d50a3a/Microsoft.ReportViewer.WinForms.dll
----------------------------------------
Microsoft.SqlServer.SString
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SString/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SString.dll
----------------------------------------
SQLEditors
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SQLEditors.DLL
----------------------------------------
Microsoft.VisualStudio.TextManager.Interop
    Assembly Version: 7.1.40304.0
    Win32 Version: 7.0.4054
    CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.TextManager.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.TextManager.Interop.dll
----------------------------------------
Microsoft.DataTransformationServices.Interfaces
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataTransformationServices.Interfaces.DLL
----------------------------------------
Microsoft.DataTransformationServices.VsIntegration
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataTransformationServices.VsIntegration.DLL
----------------------------------------
Microsoft.DataWarehouse.VsIntegration
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.VsIntegration.DLL
----------------------------------------
Microsoft.VisualStudio.Shell
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Shell/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.dll
----------------------------------------
Microsoft.VisualStudio.Shell.Interop.8.0
    Assembly Version: 8.0.0.0
    Win32 Version: 8.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop.8.0/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.8.0.dll
----------------------------------------
Microsoft.SqlServer.ManagedDTS
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.ManagedDTS/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.ManagedDTS.dll
----------------------------------------
Microsoft.SqlServer.DTSRuntimeWrap
    Assembly Version: 9.0.242.0
    Win32 Version: 9.0.242.0
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.DTSRuntimeWrap/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.DTSRuntimeWrap.dll
----------------------------------------
CustomMarshalers
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/CustomMarshalers/2.0.0.0__b03f5f7f11d50a3a/CustomMarshalers.dll
----------------------------------------
Microsoft.DataWarehouse
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.DLL
----------------------------------------
Microsoft.DataWarehouse.Interfaces
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.2047.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.DataWarehouse.Interfaces/9.0.242.0__89845dcd8080cc91/Microsoft.DataWarehouse.Interfaces.dll
----------------------------------------
Microsoft.DataTransformationServices.Design
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataTransformationServices.Design.DLL
----------------------------------------
Microsoft.AnalysisServices.Project
    Assembly Version: 9.0.242.0
    Win32 Version: 2005.090.1399.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.AnalysisServices.Project.DLL
----------------------------------------
Microsoft.VisualStudio.Designer.Interfaces
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.573
    CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Designer.Interfaces/1.0.5000.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Designer.Interfaces.dll
----------------------------------------
Microsoft.VisualStudio.Design
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Design/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Design.dll
----------------------------------------
System.Design
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll
----------------------------------------
Microsoft.VisualStudio.Shell.Design
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Shell.Design/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Design.dll
----------------------------------------
Microsoft.AnalysisServices
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.2047.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.AnalysisServices/9.0.242.0__89845dcd8080cc91/Microsoft.AnalysisServices.dll
----------------------------------------
Microsoft.DataTransformationServices.Controls
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.DataTransformationServices.Controls/9.0.242.0__89845dcd8080cc91/Microsoft.DataTransformationServices.Controls.dll
----------------------------------------
Microsoft.SqlServer.DTSPipelineWrap
    Assembly Version: 9.0.242.0
    Win32 Version: 9.0.242.0
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.DTSPipelineWrap/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.DTSPipelineWrap.dll
----------------------------------------
Microsoft.AnalysisServices.Controls
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.AnalysisServices.Controls.DLL
----------------------------------------
Microsoft.SqlServer.Dts.Design
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Dts.Design/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Dts.Design.dll
----------------------------------------
Microsoft.SqlServer.MaintenancePlanTasksUI
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.MaintenancePlanTasksUI/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.MaintenancePlanTasksUI.dll
----------------------------------------
Microsoft.VisualStudio
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 built by: RTM
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.dll
----------------------------------------
System.Drawing.Design
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing.Design/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.Design.dll
----------------------------------------
Microsoft.SqlServer.MaintenancePlanTasks
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.MaintenancePlanTasks/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.MaintenancePlanTasks.dll
----------------------------------------
Microsoft.SqlServer.SQLTask
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/Microsoft.SqlServer.SQLTask/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SQLTask.dll
----------------------------------------
msddsp
    Assembly Version: 8.0.0.0
    Win32 Version: 8.0.0.0
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/msddsp/8.0.0.0__b03f5f7f11d50a3a/msddsp.dll
----------------------------------------
Microsoft.DataWarehouse.Layout
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.Layout.DLL
----------------------------------------
stdole
    Assembly Version: 7.0.3300.0
    Win32 Version: 7.00.9466
    CodeBase: file:///C:/WINDOWS/assembly/GAC/stdole/7.0.3300.0__b03f5f7f11d50a3a/stdole.dll
----------------------------------------
msddslmp
    Assembly Version: 8.0.0.0
    Win32 Version: 8.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/msddslmp/8.0.0.0__b03f5f7f11d50a3a/msddslmp.dll
----------------------------------------
DdsShapesLib
    Assembly Version: 9.0.242.0
    Win32 Version: 9.0.242.0
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/DdsShapesLib.DLL
----------------------------------------
VSLangProj
    Assembly Version: 7.0.3300.0
    Win32 Version: 7.00.9466
    CodeBase: file:///C:/WINDOWS/assembly/GAC/VSLangProj/7.0.3300.0__b03f5f7f11d50a3a/VSLangProj.dll
----------------------------------------
Microsoft.SqlServer.Management.MaintenancePlanWizard
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.MaintenancePlanWizard.DLL
----------------------------------------
Microsoft.SqlServer.WizardFramework
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.WizardFramework/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.WizardFramework.dll
----------------------------------------
Microsoft.SqlServer.GridControl
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.GridControl/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.GridControl.dll
----------------------------------------
Microsoft.SqlServer.msxml6_interop
    Assembly Version: 6.0.0.0
    Win32 Version: 6.0.0.0
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.msxml6_interop/6.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.msxml6_interop.dll
----------------------------------------
Microsoft.VisualStudio.Debugger.Interop
    Assembly Version: 8.0.1.0
    Win32 Version: 8.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Debugger.Interop/8.0.1.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Debugger.Interop.dll
----------------------------------------
Interop.VisioGraph_2_100
    Assembly Version: 9.0.242.0
    Win32 Version: 9.0.242.0
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Interop.VisioGraph_2_100.DLL
----------------------------------------
Microsoft.SqlServer.DtsMsg
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.DtsMsg/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.DtsMsg.dll
----------------------------------------
System.Web
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll
----------------------------------------
Microsoft.SqlServer.DlgGrid
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.DlgGrid/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.DlgGrid.dll
----------------------------------------
Microsoft.SqlServer.DataStorage
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.DataStorage/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.DataStorage.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

Multiple SQL Server Instances display in ODBC Server drop down

Fri, 31 Oct 2008 17:08:54 Z

I've encountered this problem a few times and don't seem to know why it's happening. Basically when you configure and ODBC connection to either a SQL Server 2000 or 2005 instance when you go to specify a server name that server name appears twice in the selection box. One will not work where as the other one will. Any ideas on this problem?

Connect sql database to visual studio error

Mon, 22 Dec 2008 02:54:45 Z

I have a problem by connecting sql server to visual studio. It always say that i cannot find my username. I using window authentication. How can I overcome this problem?

Thanks!

SQL Server Express for commerical use

Thu, 11 Dec 2008 06:21:30 Z

My client having Sql Server 2005 with license, Now they want 25 users to use as client machine in their network using the Sql server express edition free use in the client machine.

Can anyone help in the issue??

Thanks in advance.

with regards,
C. Venkatesan.

n/a

Wed, 12 Nov 2008 20:54:25 Z

n/a

PDA database questions

Wed, 12 Nov 2008 19:30:35 Z

I am developing a small database for a PDA using VS 2008.
I am using a Data Grid to display the values in the database, one is date and one is currency
I have the following :
TestDataTable(Which contains columns, Date, Provider, Amount Paid)
Herer are my 2 questions:

1). how do i format the "Amount Paid" column at runtime so when the user views the data it is formatted as currency????

2). I have generated data forms to edit, new and modify the data in the database(Test1.sdf)
I have a save button when the user selects it how do i save the changes made to the data base????????

ANy help would be apprecitated

m2m

Thanks

Cannot open database "AdventureWorks" requested by the login. The login failed. received in web service

Tue, 11 Nov 2008 17:53:21 Z

I have downloaded SQL Server 2005 Express addition and I am trying to connect to the Adventure Works database via a web service written in c# using VS2005. I can connect to the database through VS2005 and I know it is using my windows account.

The confusion I am having is how you find out what ASPNET account is being used to access the webservice.

I Thought it was the same as the windows account, but on reading it uses the ANONYMOUS users...I believe, but how do you check this?
Also how do you set the ASPNET account to have read write permissions on the ADVENTUREWORKS database?

The database and webservice reside on the same machine.

I have used the following code to try and connect to the database

public string GetVendorList()

{

SqlConnection sqlConn;

XmlReader rdr;

string ret = "";

try

{

//Open connection to SQL Express

string connString = @"server=.\sqlexpress;Integrated Security=SSPI;initial catalog=AdventureWorks";

sqlConn = new SqlConnection(connString);

sqlConn.Open();

//Return XML data the FOR XML AUTO clause

string sqlString = "SELECT VendorId, AccountNumber, Name, CreditRating " +

"FROM Purchasing.Vendor " +

"WHERE ActiveFlag = 1 " +

"ORDER BY Name " +

"FOR XML AUTO ";

SqlCommand command = new SqlCommand(sqlString, sqlConn);

//Execute SQL query and return XML to XmlReader

rdr = command.ExecuteXmlReader();

rdr.Read();

while (rdr.ReadState != ReadState.EndOfFile)

{

ret += rdr.ReadOuterXml();

}

//Add a root element

ret = "<vendors> " + ret + "</vendors>";

sqlConn.Close();

rdr.Close();

}

catch (Exception ex)

{

throw new Exception(ex.Message);

}

return ret;

}

I keep getting the following error on the sqlConn.Open();
"Cannot open database "AdventureWorks" requested by the login. The login failed."

I have tried to set the sa user in SQL Server Management Studio Express to public but do not really know what I am doing. I have searched the web for 4 days now and cannot find any info for a step by step check in SQL Server Management Studio Express.

Any help would be great as I am a beginner to C# and to SQL Server Express.

Thanks.

IIS to SQL authentication

Mon, 27 Oct 2008 19:55:45 Z

Hi,

We have a Internal Web App with a Sql back end. We want to be able to authenticate each user, that accesses the web site, to Sql. So in other words we dont want the Web site to use a Service account or a hard coded login in the code to connect to SQL.

Any ideas?

CC

Clayton

Performance Issues - ran DBCC Perf (waitstats)

Tue, 28 Oct 2008 16:31:58 Z

Hi,

I have a slow performing database server and am in a process to get to the root cause of it. My front end is MS Access using Active X scripts to connect to the SQL Server 2000. Meantime I have ran DBCC Perf (waitstats) as found in MSDN and have a hard time to interprit the results. These are my results from the query. Your help is greatly appreciated. Thanks.

MISCELLANEOUS 3091 0 0
LCK_M_SCH_S 0 0 0
LCK_M_SCH_M 4 2093094 0
LCK_M_S 31 3355794 0
LCK_M_U 0 0 0
LCK_M_X 0 0 0
LCK_M_IS 71 3219717 0
LCK_M_IU 0 0 0
LCK_M_IX 1 266 0
LCK_M_SIU 0 0 0
LCK_M_SIX 0 0 0
LCK_M_UIX 0 0 0
LCK_M_BU 0 0 0
LCK_M_RS_S 0 0 0
LCK_M_RS_U 0 0 0
LCK_M_RIn_NL 0 0 0
LCK_M_RIn_S 0 0 0
LCK_M_RIn_U 0 0 0
LCK_M_RIn_X 0 0 0
LCK_M_RX_S 0 0 0
LCK_M_RX_U 0 0 0
LCK_M_RX_X 0 0 0
SLEEP 1831478 1.754027E+09 1.747461E+09
IO_COMPLETION 6018 20773 0
ASYNC_IO_COMPLETION 287 782 0
RESOURCE_SEMAPHORE 0 0 0
DTC 0 0 0
OLEDB 1.749501E+07 2.186584E+09 2.988575E+08
FAILPOINT 0 0 0
RESOURCE_QUEUE 3473702 2.759905E+08 1.696084E+09
ASYNC_DISKPOOL_LOCK 4922 0 0
UMS_THREAD 0 0 0
PIPELINE_INDEX_STAT 0 0 0
PIPELINE_LOG 0 0 0
PIPELINE_VLM 0 0 0
WRITELOG 1588594 6211059 44069
PSS_CHILD 0 0 0
EXCHANGE 222 79 15
XCB 0 0 0
DBTABLE 1 6063 0
EC 0 0 0
TEMPOBJ 0 0 0
XACTLOCKINFO 0 0 0
LOGMGR 0 0 0
CMEMTHREAD 6831 142 127
CXPACKET 297985 6989033 45611
PAGESUPP 6524 465 78
SHUTDOWN 0 0 0
WAITFOR 0 0 0
CURSOR 0 0 0
EXECSYNC 2 0 0
LATCH_NL 0 0 0
LATCH_KP 0 0 0
LATCH_SH 19 15000 0
LATCH_UP 2 0 0
LATCH_EX 5519302 706545 79562
LATCH_DT 0 0 0
PAGELATCH_NL 0 0 0
PAGELATCH_KP 0 0 0
PAGELATCH_SH 6806 468 0
PAGELATCH_UP 84417 768 408
PAGELATCH_EX 4732 7599 93
PAGELATCH_DT 0 0 0
PAGEIOLATCH_NL 0 0 0
PAGEIOLATCH_KP 0 0 0
PAGEIOLATCH_SH 186606 400507 577
PAGEIOLATCH_UP 16115 135191 124
PAGEIOLATCH_EX 5804 43703 16
PAGEIOLATCH_DT 0 0 0
TRAN_MARK_NL 0 0 0
TRAN_MARK_KP 0 0 0
TRAN_MARK_SH 0 0 0
TRAN_MARK_UP 0 0 0
TRAN_MARK_EX 0 0 0
TRAN_MARK_DT 0 0 0
NETWORKIO 1177345 1.059683E+09 0
Total 3.171592E+07 5.299492E+09 3.742573E+09

Access queries/SQL -- Multiple search

Fri, 07 Nov 2008 01:56:32 Z

Hi

I am trying to create a query / SQL that will find duplicate rows that have any 2 of the 6 fields matching.

ie: Row 1 = 1, 2, 3, 4, 5, 6
Row 2 = 2, 3, 10, 11, 12, 13

The query should find 2, 3 as duplicates even though they aren't in the same fields.... so long as they match, that's all that matters.

Thanks for your help

Sample quickstart code

Wed, 22 Oct 2008 07:51:58 Z

Hello

I am very new to this, and want to start exploring how to use these protocols. I ran through the PDF documents at http://go.microsoft.com/fwlink/?LinkId=120223 but what I am looking for is some quickstart code...

I know the documentation will be very helpful from the point of view of details and design, but for a start I am really looking for some code samples, or "quickie" code.

Ok, I am not looking for SQL Server protocols in particular, but for that matter any "quickstart" code for any of these Microsoft open protocols, which will give me a headstart!!

Can someone please point me in that direction?

Thanks a lot!!
Advait Supnekar

why this happend?

Sun, 26 Oct 2008 08:14:32 Z

hi all,

guys I used a table in SQL Server which has a dataType of Char not NChar.

and i store unicode characters in this field.when i ported my database to the host .all of the data in this field turned to "?" sign.what is the problem?

Brainstorm your Brain and find solution,if no result stuck to Brainstormer.

Downgrading from SQL Server 2008 to 2005

Thu, 16 Oct 2008 03:42:55 Z

I have installed TFS 2008 along with SQL Server 2008. I need to be utilize SQL Server 2005 on this same machine for the build process. Is it possible to downgrade the SQL Server version to 2005 or would I just be better off starting from scratch?

I believe there are some incompatibilities between the two versions of SQL Server that would make it impossible to run both side by side but I may be wrong about that. Any guidance would be appreciated.

Technical documentation links don't resolve in Adobe Reader 9

Mon, 20 Oct 2008 19:48:42 Z

This is a change introduced by Adobe, which has altered the default setting for view mode in Adobe Reader 9. In order to access links, users need to change their settings so that the document is not in view mode. In Adobe Reader 9, go to the Edit menu and click Preferences. In the Categories list, click Documents. Under PDF/A View Mode, change the selection from Only for PDF/A documents to Never, and click OK.

Additional details on changing the setting can be located via the Adobe help site: http://help.adobe.com/en_US/Acrobat/9.0/Standard/WS3E0E8467-B787-4020-A1D3-6BC762A42DF2.w.html

Using SqlServer2008

Sat, 18 Oct 2008 07:35:14 Z

Hi,
whenever i try to use catalogs with FREETEXT in sqlserver2008 I get error as:

SQL Server encountered error 0x80070422 while communicating with full-text filter daemon host (FDHost) process. Make sure that the FDHost process is running. To re-start the FDHost process, run the sp_fulltext_service 'restart_all_fdhosts' command or restart the SQL Server instance.

Please provide the solution to resolve it.

SQL Server - comma separated values into a single column

Tue, 14 Oct 2008 14:53:00 Z

Hi,

I'm using a stored proc to return multiple rows from a table.
I need to store this list of values as comma separated values in a single column .
I do not wish to iterate through the rows to generate a comma separated value.
Could you suggest an alternate option to do the same.

Thanks,
Monideepa

Creating TRIGGERS

Tue, 14 Oct 2008 05:10:25 Z

Hi,

I want to create a trigger which would drop a database when a row of another database is deleted. I am using MySQL database. Currently i am using the trigger as given below. But its not working.

DELIMITER $$
CREATE TRIGGER deletePData
AFTER DELETE ON `ProjectDB`.`Project_Name_Table`
FOR EACH ROW BEGIN
DELETE DATABASE OLD.Project_Name_Column;
END;
$$

plz someone give me a solution.

Solution for SQL Server will also be OK

Thanks & Regards
Akhil.N.P

Akhil.N.P

how to add a patern to all data in a table

Sun, 12 Oct 2008 11:17:15 Z

hello,
i want to rename all data in a table from whatever to whatever_new (add _new to all entries) with one command

how?

Dimitris Koutsoukos

Date problem

Fri, 10 Oct 2008 01:15:48 Z

I'm trying to use System.DateTime and this works when checking it in MsgBox(DateValue(Now)) looks as it should like this "10.10.2008 02.55.00", but an error that is showing is "Syntaksfeil i dato i spørreuttrykket #12.10.2008 02:55:00#" and pop up in this code:

Con.Execute("update contacts set DT=#" & dt & "# where RecordNo=" & CInt(ListView1.Items(0).Text), ADODB.CommandTypeEnum.adCmdText + ADODB.ExecuteOptionEnum.adExecuteNoRecords)

*****************

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click

Call initWeekDays()

Dim i, intIndex As Integer

Dim dt As System.DateTime

'dt = "#13 09 2007 21:22:23#"

dt.ToString("dd/MM/yyyy")

Dim ci As New CultureInfo("nn-NO")

Thread.CurrentThread.CurrentCulture = New CultureInfo("nn-NO")

Console.WriteLine(dt.ToString("d", ci))

dt.ToLocalTime()

'dt = DateTime.Now

MsgBox(DateValue(Now))

For i = 0 To ListView1.Items.Count - 1

intIndex = Array.IndexOf(RLRno, CInt(ListView1.Items(0).Text))

If Not intIndex = -1 Then

If CBool(RLArray(intIndex, 5)) = True Then 'daily

dt = CDate(RLArray(intIndex, 1))

dt = DateValue(Now) & " " & TimeValue(dt)

dt = DateAdd(DateInterval.Day, 2, dt)

'MessageBox.Show("daily : " & dt)

End If

If CBool(RLArray(intIndex, 6)) = True Then 'weekly

dt = CDate(RLArray(intIndex, 1))

dt = CDate(weekDays(dt.DayOfWeek) & "/" & Month(Now) & "/" & Year(Now) & " " & TimeValue(dt))

dt = DateAdd(DateInterval.Weekday, 7, dt)

'MessageBox.Show("weekly : " & CStr(dt))

End If

If CBool(RLArray(intIndex, 7)) = True Then 'monthly

dt = CDate(RLArray(intIndex, 1))

dt = CDate(Day(dt) & "/" & Month(dt) & "/" & Year(Now) & " " & TimeValue(dt))

dt = DateAdd(DateInterval.Month, 1, dt)

'MessageBox.Show("monthly : " & dt)

End If

If CBool(RLArray(intIndex, 8)) = True Then 'yearly

dt = CDate(RLArray(intIndex, 1))

dt = CDate(Day(dt) & "/" & Month(dt) & "/" & Year(Now)) '& " " & TimeValue(dt))

dt = DateAdd(DateInterval.Year, 1, dt)

'MessageBox.Show("yearly : " & dt)

End If

Con.Execute("update contacts set DT=#" & dt & "# where RecordNo=" & CInt(ListView1.Items(0).Text), _

ADODB.CommandTypeEnum.adCmdText + ADODB.ExecuteOptionEnum.adExecuteNoRecords)

Call InitReminderList() : Call showReminders()

End Sub

Visual Studio 2008 Microsoft Visual Basic 2008 Owner

Connect to ms SQL with PHP

Thu, 09 Oct 2008 11:19:22 Z

hi ,
I have 2 servers one of them is web server other is database server...
my database server ip is 10.0.0.1
I want to connect from web server to database...
I wrote these
$username="admin";
$password="1234";
$Server_Name="10.0.0.1:1433";
$cs = mssql_connect ( $Server_Name,$username,$password)
or die ( 'Can not connect to server' );
but I could not connect
it says that

Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: 10.0.0.1:1433 in C:\xampp\htdocs\deneme\connect_db.php on line 18
Can not connect to server

where do I made a mistake??...

please help me...

ASP.Net 2005 with SQL Server 2000

Wed, 08 Oct 2008 08:34:28 Z

I use ASP.Net 2005 with SQL Server 2000, when i run my web page http://localhost/mywebpage occur an error:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

But when i run it from Visual Studio .Net 2005 with http://localhost:1022/mywebpage , it's ok

Please help me!!

is TDS specification going to be released ?

Tue, 19 Aug 2008 14:13:22 Z

Is MS planning to release TDS for SQL 2008 ?

?

Mon, 29 Sep 2008 11:59:36 Z

rebuilding a sqlexpress 2008 database

Thu, 25 Sep 2008 08:10:26 Z

i changed the collation for sqlexpress 2008 and now have to rebuild the db. i have a command that uses the setup.exe. i only have SQLEXPR_x86_ENU installation file which i got off the microsoft site. how do i rebuild now???

thanks
helloise

Round and Convert $ fields.

Tue, 23 Sep 2008 20:35:05 Z

The statement and question is as follows:

I need to convert a number such as 208135.832367 to be represented as $ 208,136. So I need to CONVERT ROUND. So far I have created the following statement that converts the field so it looks like this $ 208,135.83. The statement is:

'$' + CONVERT(varchar(25), CONVERT(money, dbo.MSP_EpmTask_UserView.TaskBaseline0Cost, 1)) AS TaskBaselineCost,

I am seeking for advice as to the best (or only) way to do the rounding and have a 0 decimal.

Any assistance will be greatly appreciated.

Thanks in advance

Geo

SQLServerException thown from getGeneratedKeys

Wed, 24 Sep 2008 18:02:03 Z

I am trying to use SQL Server 2008 with Java JDBC and I have trouble auto generate a key for a new inserted row. Every time I am getting this:

com.microsoft.sqlserver.jdbc.SQLServerException: The statement must be executed before any results can be obtained.

I tried with both MS drivers 1.2 and 2.0 and got the same result. Same code works fine with SQL Server 2005 and JDBC driver 1.1.

Does anybody know what this issue is or what I am doing wrong?

Thanks,
Oleg

how to find that a column exist in the table from the query

Mon, 22 Sep 2008 04:22:17 Z

how to find that a column exist in the table from the Sql query in Sql2005?

kunal