Basic Help Understanding How SQL Server Works
Aug 4, 2005
I've been using databases for twenty years now and have just started using SQL Server 2000. I've used dbase III+, FoxPro and FileMaker Pro mostly and have a pretty good generally knowledge of databases. However, I'm constantly scratching my head over a few SQL Server foundational issues and would appreciate some help.
Probably the biggest question is this:
In FileMaker Pro (and FoxPro if I remember correctly), I would set the relationship once and then never have to think about it much again. Then I could create virtual tables and sub forms which contained data from several tables and view/update them with ease. However, in SQL Server I've noticed that while I can define the relationships in a database diagram, every query has to recreate the joines. If I try to use a view I can only update one table at a time which seesm whacky to me. So what on earth is the point of having relationships if you have to redefine them with each query? I've read that referrential integrity is the reason but that only baffles me further as I don't understand the point. Sure I get cascading deletes but there has to be more to the feature than that.
Also, when I want to insert data in multiple related tables I'm used to utilizing the existing relationship, mentioning the primary key once and then simply filling in the data. It seems in SQL Server that I have to also insert on the foreign key. This doesn't make sense as the database should know which record I'm talking about in the foreign key table(s) as they're related. Again though, I'm not only recreating the relationship in the insert but I'm also having to specify the foreign key. I guess it just makes me wonder why it's not simply checking the relationships which already exist.
So I'm a bit baffled and any help would be most appreciated.
Thanks in advance!
Kelly
View 7 Replies
ADVERTISEMENT
Jul 9, 2007
I'm having a mental block here and would like to get things straight. All this while trying to learn and deploy SSB.
I belive my scenario is perfect for this solution. So I'm asking for your help. Simply I have the following process:
1. A record is inserted into a table.
2. Take this transaction and convert to XML file
3. Send XML version to web service where it is processed and the result is returned.
4. take the result and insert as into a different table (from the first).
My requirement to this process is that each step updates a status indicator in the original table. Second, since communication to the web service is not reliable, the message should retry until service is restored. Or failing that, after a timeout, should be in a state that can be restarted. And, lastly, the process sohuld be restartale in the event of failure.
I'm confident that the tasks and requirements are pretty simple and straighforward. But I'm not sure of the implementation.
1. Created initial record table.
2. Created SQL statement that converts single row to XML document
3. Created CLR Stored procedure that takes an XML and submits to Web Service and collects response.
So I think the question are;
1. Do I create two conversations? One for each direction of the message. ('to' the web svc and 'from' the web svc)
2. Do I create an intermediate table that feeds a queuefor the return message.
3. Where do I place the logic to update the Status flag? At the beginning of the next step? or the end of the executing step?
4. How do I ensure that a transaction is not lost from the time sent to the web service to the receipt of the response?
I'm using 'Pro SQL Server 2005' by Thomas Rizzo as a reference. Are there any better references? Most google responses seem to point to articles reiterating the base concepts. Would the 'Pro Sql 2005 Service Broker' book provide answers to my questions?
View 2 Replies
View Related
Jul 26, 2004
I've got a popular problem so i get a message that server acces denied! ..
But that what is different in my error.... When i use same setting same database and connection string (on MSDE server) there is no problem...
On SQL server i have got windwos authentication but i added all accounts as ASPNET and SA.... and when i try to connect by
RETTO - name of my server
server=RETTO;uid=sa;pwd=password;database=db1;
or by
Integrated Security=SSPIserver=RETTO;uid=RETTOASPNET;database=db1;
I CAN BROWSE RECORDS THERE ARE NO PROBLEMS WITH CONNECTION!!! but when i try to update or iinsert or delete something in database there becomame this error that access denied or server does not exist!!!
PLEASE HELP I'm FIGHTING WITH THAT FOR OVER 5 DAYS!!!
I MADE FOR MY ACCOUNTS (SA, ASPNET) ALL THINGS ALLOWED AS EXECUTING stored procedures.. OR ACCESING datatables with insert delete and update query WHERE IS THE PROBLEM!!!??
View 3 Replies
View Related
Jun 20, 2007
I'm having a strange problem with this but I know (and admit) that the problem is on my PC and nowhere else. My firewall was causing a problem because I was unable to PING the database server, switching this off gets a successful PING immediately. The most useful utility to date is running netstat -an in the command window. This illustrates all the connections that are live and ports that are being listed to. I can establish a connection both by running
telnet sql5.hostinguk.net 1433 and
sqlcmd -S sql5.hostinguk.net -U username -P password
See below:
Active Connections
Proto Local Address Foreign Address State
TCP 0.0.0.0:25 0.0.0.0:0 LISTENING
TCP 0.0.0.0:80 0.0.0.0:0 LISTENING
TCP 0.0.0.0:135 0.0.0.0:0 LISTENING
TCP 0.0.0.0:443 0.0.0.0:0 LISTENING
TCP 0.0.0.0:445 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1026 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1433 0.0.0.0:0 LISTENING
TCP 81.105.102.47:1134 217.194.210.169:1433 ESTABLISHED
TCP 81.105.102.47:1135 217.194.210.169:1433 ESTABLISHED
TCP 127.0.0.1:1031 0.0.0.0:0 LISTENING
TCP 127.0.0.1:5354 0.0.0.0:0 LISTENING
TCP 127.0.0.1:51114 0.0.0.0:0 LISTENING
TCP 127.0.0.1:51201 0.0.0.0:0 LISTENING
TCP 127.0.0.1:51202 0.0.0.0:0 LISTENING
TCP 127.0.0.1:51203 0.0.0.0:0 LISTENING
TCP 127.0.0.1:51204 0.0.0.0:0 LISTENING
TCP 127.0.0.1:51206 0.0.0.0:0 LISTENING
UDP 0.0.0.0:445 *:*
UDP 0.0.0.0:500 *:*
UDP 0.0.0.0:1025 *:*
UDP 0.0.0.0:1030 *:*
UDP 0.0.0.0:3456 *:*
UDP 0.0.0.0:4500 *:*
UDP 81.105.102.47:123 *:*
UDP 81.105.102.47:1900 *:*
UDP 81.105.102.47:5353 *:*
UDP 127.0.0.1:123 *:*
UDP 127.0.0.1:1086 *:*
UDP 127.0.0.1:1900 *:*
Both these utilities show as establishing a connection in netstat so I am able to connect the database server every time, this worked throughout yesterday and has continued this morning.
The problem is when I attempt to use SQL Server Management Studio. When I attempt to connect to tcp:sql5.hostinguk.net, 1433 nothing shows in netstat at all. There is an option to encrypt the connection in the connection properties tab in management studio, when I enable this I do get an entry in netstat -an, see below:
TCP 81.105.102.47:1138 217.194.210.169:1433 TIME_WAIT
TCP 81.105.102.47:1139 217.194.210.169:1433 TIME_WAIT
TCP 81.105.102.47:1140 217.194.210.169:1433 TIME_WAIT
Amost as if it's trying the different ports but you get this time_wait thing. The error message is more meaningful and hopefull because I get:
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) (.Net SqlClient Data Provider)
I would expect this as the DNS has not been advised to encrypt the conection.
This is much better than the : Login failed for user 'COX10289'. (.Net SqlClient Data Provider) that I get, irrespective of whether I enter a password or not.
This is on a XP machine trying to connect to the remote webhosting company via the internet.
I can ping the server
I have enabled shared memory and tcp/ip in protocols, named pipes and via are disabled
I do not have any aliases set up
No I do not force encryption
I wonder if you have any further suggestions to this problem?
View 7 Replies
View Related
May 11, 2007
Hello,
I've been using SSIS for a while and think I get the gist of how it works (and it works nicely!).
However, because of the configuration on my machine I am constantly moving the dtsx files around (long story). Sometimes I make a full image backup and then later restore those SSIS packages.
The problem is that even if I copy the dtsx files to a different directory and then copy them back (without making any changes) I get a 'Cannot Aquire Connection' message. Other times I get errors that have to do with the encryption of the individual package. For those, I just reset the package to save with a password, save it, and then reopen it and can resave it again with the userkey encryption. This one occured when I move the packages from one machine to another.
Is there a best (or at least good) way to save packages with the sensitive data that won't force me to reconfigure it each time I move a package around? Or have to enter passwords each time?
Also, what is the advantage of saving the files in SQL Server? I assume you are not actually saving the files, just the data about them. I just don't understand it enough to even ask an intelligent question about it.
Thank you for the help.
-Gumbatman
View 1 Replies
View Related
Jul 7, 2015
I have two calls to stored procedures that in an SSIS package fails silently. They are simply not executed in production but works fine in test, nothing happens and the sql server agent reports that everything has gone just fine.
In test they have 1 server with db A and B. No issue here.
In prod they have 2 servers with db A and B. On server 1 sql server agent executes a job that includes an SSIS package that on server 2 runs a couple of sp's. That user is db owner on server 2 db B and yet nothing happens. The sp's are not executed.
If I in prod run the job manually then it works, but not when run with the sql server agent account that as said is even db owner.
View 2 Replies
View Related
May 18, 1999
Hi,
I'm new to SQL server so I hope somebody is willing to lend a hand...
I installed the server without a problem, and the service is showing as running OK.
However, when I open SQL enterprise manager, no server names can be selected.
But, when i go in via DOS and enter
SELECT @@SERVERNAME
GO
I get the correct name back - "andrewp"
I don't understand how I cannot connect to the server via Enterprise Manager...
I'm running on NT4.0 Workstation, SQL server 6.5, if that makes a difference.
Thanks for any help you can give,
Andy
View 2 Replies
View Related
Jan 3, 2004
Hi experts I am new to SQL Server and have got to do a project using VB & SQL Server. right now i got to prepare case study document wherein i got to mention the pros & cons of using VB+sql server... kindly help me. Thanks in advance.
View 1 Replies
View Related
Oct 23, 2006
Hi, I have no idea about SQL Server.my first question is,SQL server usually mean "MS" sql server. right?Also, my second question is,I made a webpage with PHP to connect My SQL.However, if i want to change from My sql to MS sql server, then how cani change the webpage? can I do it with PHP or should I totally changeit to ASP? If I have to change it, the format could be similar ortotally different?Thank you.
View 4 Replies
View Related
Nov 7, 2007
A series of articles examining some basic concepts in Sql Server.Basic Anatomy of Sql Server, part IWhat is a stored procedure?http://beyondsql.blogspot.com/2007/...ver-part-i.htmlBasic Anatomy of Sql Server, part IIThe unit test as part of the database.http://beyondsql.blogspot.com/2007/...er-part-ii.htmlBasic Anatomy of Sql Server, part IIIWhat does deferred name resolution really mean?http://beyondsql.blogspot.com/2007/...r-part-iii.html
View 1 Replies
View Related
Jul 20, 2005
After creating database in SQL Server , it generates .mdf , .ndfdatafiles .Generally if we get those datafiles then we can create the databasewith tables/data on another machine by using those datafiles.I want to know, if we can we protect this? I don't want another userto take those files and create database on another SQL Server. Isthere any option available in SQL server while creating database toprotect this file with password or any darn thing for protection thatwould not allow to create the database by using those file or anyworkaround.Thanks in advance for your help.
View 1 Replies
View Related
Dec 14, 2006
Hello,
I am having trouble just starting SQL Server 2005. When I try to use Management Studio, I do not see any server name. I just need to be able to start it up!
Thanks,
pagates
View 1 Replies
View Related
Jun 16, 2000
Does SQL Server 7.0 works with Windows2000 Pro?
We installed SQL 7.0 on Windows 2000 Professional and
cannot seems to find the server components of it.
Was wondering if anybody successfully installed SQL7.0
on Windows2000 Pro?
Pl. send an email.
TIA
DIN
dk@i1.net
View 1 Replies
View Related
Aug 7, 2001
Ok, this is in reference to the previous post about replicated server with difference.
I have a Case statement that checks for NULL values and works on one server and not the other. For example:
Select Case LineItems.Item When 'BILL' then Activities.InvoiceState When Null Then Activities.InvoiceState Else States.State End As Sate.
The second server is not recognizing the NULL in this statement. Any ideas??
Thanks alot for any help.
View 1 Replies
View Related
Jun 18, 2015
i like to know how CTE works in sql server. i need to understand the flow of CTE. here i am pasting one example of CTE which i need to understand how works
DECLARE @StartTime DATETIME, @EndTime DATETIME
SELECT @StartTime = '09:00:00'
SELECT @EndTime = '17:30:00'
;WITH interval_cte(StartTime, EndTime) AS
[code]....
1) when CTE is declared then why fields name is used ;WITH interval_cte(StartTime, EndTime) AS ? what is the use of these field name.i do not understand how this line works
SELECT EndTime, DATEADD(mi, 30, EndTime) FROM interval_cte
WHERE EndTime < @EndTime
it has no alias define DATEADD(mi, 30, EndTime) ?how end time is increasing in loop ?which line increase end time value ?
View 6 Replies
View Related
Jan 29, 2008
My site is hosted by Fasthosts(.co.uk), which means I cannot put an MS SQL database on my site: they don't support that sort of thing. I have to pay for a seperate SQL database on a seperate server (also hosted by fasthosts). They have given me an IP, a server name, a database name, login and password. They tell me that the server require SQL authentication. I have managed to contect to the database using MS VWD 2005 through the database explorer. I cannot however make changes to the database. I have therefore downloaded SQL Server Management Express. This is where I am stuck. I can't seem to get the software to find my database. One thing I have tried is i've set up a database on my system and then run replication. When I do this I get stuch at to the "enter the name of the computer running IIS" part of the wizard, I've tried entering in the IP of the server and the ip of my website. I have also tried connecting to the database direct (not using replication) but this fails when it tries, despite all the combinations of IP, server name and database name I try! Any ideas? Regards, Howard
View 5 Replies
View Related
Mar 11, 2004
I'm new to using SQL server and have a few setup questions.
I'm setting up a database for the company I work for. Should I setup a different database for each division in our company (e.g. accounting, project management, estimating, etc.), or should I use just one database? It seems like it would be easier to use one database so I only have to use one connection, but is this ideal? I want all the info from the different divisions to be used together, but at this point I'm confused as to how to connect different databases together, if I were to go this way.
Thanks for any input or ideas!
View 1 Replies
View Related
Nov 10, 2000
I'm wanting to start to understand SQL Server. I've got the Beta Version of MS SQL Server 2000 and was wondering whether I could install this on my Windows Me box and start developing? Is this wise, or should i not use the Beta version? Is there a time when the Beta version "runs out"?
Are there any good basic SQL web sites out there? I know all about Access developement and i know some SQL, but i know nothing about SQL server. Which is the best site for me?
Thanks.
View 1 Replies
View Related
Aug 3, 2001
is there any way to use Visual Basic and MSSQL without using ODBC?
please let me know.
View 1 Replies
View Related
May 18, 1999
Hi,
I'm new to SQL server so I hope somebody is willing to lend a hand...
I installed the server without a problem, and the service is showing as running OK.
However, when I open SQL enterprise manager, no server names can be selected.
But, when i go in via DOS and enter
SELECT @@SERVERNAME
GO
I get the correct name back - "andrewp"
I don't understand how I cannot connect to the server via Enterprise Manager...
I'm running on NT4.0 Workstation, SQL server 6.5, if that makes a difference.
Thanks for any help you can give,
Andy
View 2 Replies
View Related
Nov 26, 2005
I'm a long time user of SQL Server 2000 but no knowledge of 2005 Express.
View 5 Replies
View Related
Jan 19, 2005
Hi,
The following SQL is lifted from one of the Reporting Services / Adventureworks2000 sample reports. I'm a little slow / baffled on how the inner joins are working? Specifically the Inner Join Locale and Inner Join ProductModel. I'm used to seeing Inner Join SomTable On Something = Somthing but how these joins are working is lost on me. Can someone give a quick overview (or point me to a reference) so I can better understand.
Thanks!
SELECT ProductSubCategory.Name AS ProdSubCat, ProductModel.Name AS ProdModel, ProductCategory.Name AS ProdCat, ProductDescription.Description,
ProductPhoto.LargePhoto, Product.Name AS ProdName, Product.ProductNumber, Product.Color, Product.Size, Product.Weight, Product.DealerPrice,
Product.Style, Product.Class, Product.ListPrice
FROM ProductSubCategory
INNER JOIN Locale
INNER JOIN ProductDescriptionXLocale ON Locale.LocaleID = ProductDescriptionXLocale.LocaleID
INNER JOIN ProductDescription ON ProductDescriptionXLocale.ProductDescriptionID = ProductDescription.ProductDescriptionID
INNER JOIN ProductModel
INNER JOIN Product ON ProductModel.ProductModelID = Product.ProductModelID
INNER JOIN ProductModelXProductDescriptionXLocale ON ProductModel.ProductModelID = ProductModelXProductDescriptionXLocale.ProductModelID
ON ProductDescriptionXLocale.LocaleID = ProductModelXProductDescriptionXLocale.LocaleID AND
ProductDescriptionXLocale.ProductDescriptionID = ProductModelXProductDescriptionXLocale.ProductDescriptionID
ON ProductSubCategory.ProductSubCategoryID = Product.ProductSubCategoryID
INNER JOIN ProductCategory ON ProductSubCategory.ProductCategoryID = ProductCategory.ProductCategoryID
LEFT OUTER JOIN ProductPhoto ON Product.ProductPhotoID = ProductPhoto.ProductPhotoID
WHERE (Locale.LocaleID = 'EN')
Shawn
View 3 Replies
View Related
Jul 6, 2007
Hi there,
So, I have a Pivot component working just fine on our Dev server. You can put a datareader before and after it, and as expected, 2092 rows go in, 1890 rows come out, and they're pivoted just fine.
I deploy the package to our Live box, and it doesn't pivot the incoming dataset at all. The rows are just being passed straight through - it's as if the Pivot component is doing nothing. Put a datareader on, you can see 2092 in, 2092 out.
I know it's not the data - I reconfigured the connection manager to point to the dev dB, so it's using exactly the same source data set, and it still passes the rows straight through.
But here's the really wierd bit. If I modify the data source to just select 2 rows from the data source (which I know need pivoting on the pivot key), the component pivots them just fine. So I can see that technically, the component has been built correctly. It does what it is meant to do if I send through 2 rows, 4 rows, 8 rows. But when I send through 2092, it just passes them straight through.
Dev server:
Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
Feb 9 2007 22:47:07
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Live server:
Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
Feb 9 2007 22:47:07
Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Any ideas anyone?
View 5 Replies
View Related
Aug 26, 2007
I a bit confuse of the order of rendering a report in reporting server . the software that i used previously do in following order
1. document header -- exec once at start of report
2. page header -- exec every new page
3. group header
4. body
5. group footer
6. page footer
7. document footer
in this software there no retriction that certain function can only be used at certain partand also there function to exec new page at any time I want. also each part has event for me to do programming . another different with reporting services is that once i set the paper type (ex. A1 or A3) ,unlike reporting service on design screen I get restrict on that size.
I hope someone can explain how actually reporting server render a page.
thks
rgds,
charles
View 1 Replies
View Related
May 8, 2007
Hi All,
I have a web serivce written in C++ and I'm trying to connect to a database. I'm using the same connection string that works from an aspx page written in C#. but when I copy it over to the C++ environment, I get:
System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
Note the username shows up as null in the error... My C++ looks like:
using namespace System:ata:qlClient;
String^ cs2 = "server=192.168.1.47;database=MyDB;integrated security=true;uid=myuser;pwd=mypassword";
SqlConnection^ myConnection = gcnew SqlConnection(cs2);
myConnection->Open();
Again, this works in C#. Interestingly, a sniffer shows a difference in an NT Authentication Packet as it's sent from my development machine to the database across the network. For the C# call, the NT Authentication packet has a username of "myuser" - from the connection string. It then gets acknowledged from the database. For the C++ call though, the username is sent as "ASPNET" - seemingly ignoring the username in the connection string. It's also rejected by the database in the next packet with the message above.
Any idea what's up with this? -- Curt
View 1 Replies
View Related
Aug 19, 2007
I just installed sql server 2005 and trying to pick it up before I start a new job as a developer using sql server 2005. The problem is that I have three instances installed, the one that works was installed prior to installing sql server 2005 when I installed System Architect a CASE tool which utilizes sql server for its encyclopedias.
My initial installed I used the default settings with the default instance and that does not work. I later ran set up again and installed another instance and that does not work. For some apparent reason the POKIN10SQL instance is over riding everything rendering every other instance non-functional.
When I try to connect to the one of the other instances, the error message is
"An error has occured while establishing a connection to the server. When connection to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL does not allow remote connections. (Provider Network Interface, error: 26 - Error locating Server/Instance Specified) (Microsoft SQL Server)"
I don't think the remote connection is the problem as I went into the properties settings and checked the connection settings and allow remote connections is checked.
In terms of locating the instance, I installed SQL Server as specified in the handbook ... with the default instance and then a named instance.
Something seems to be wrong with the POKIN10SQL instance which was installed with System Architect, I need System Architect so I need a work around rather then an uninstall.
Can someone help please?
View 3 Replies
View Related
Sep 26, 2006
I use the code below for updating data from a AS400 Liked server. I dont understend how the WHERE NOT EXISTS( sections work however usualy they do, in this case it does not andt I can't seem to find out why.
Does anyone see the error?
Thanks
--=========================================
--Create a local temporary table that hold
--all the data from the source table
--=========================================
SELECT * INTO #TEMP FROM dbo.LINK_LTTSTOC
--=========================================
--Remove table entries that are no longer
--needed or that have to be updated
--=========================================
DELETE FROM LTTSTOCK
WHERE NOT EXISTS( SELECT * FROM #TEMP
WHERE LTTSTOCK.WarehouseNo = LTWHLO
AND LTTSTOCK.Location = LTWHSL
AND LTTSTOCK.ItemNo = LTITNO
AND LTTSTOCK.NumberAvail = LTAVAL
)
--=========================================
--Insert data that is missing or that
--needed to be updated and was previously
--deleted
--=========================================
INSERT INTO dbo.LTTSTOCK(WarehouseNo,Location,ItemNo,NumberAvail,rowguid)
SELECT DISTINCT LTWHLO,LTWHSL,LTITNO,LTAVAL, NEWID()
FROM #TEMP
WHERE NOT EXISTS( SELECT * FROM LTTSTOCK
WHERE WarehouseNo = LTWHLO
AND Location = LTWHSL
AND ItemNo = LTITNO
AND NumberAvail = LTAVAL
)
--========================================
--Remove local temporary table.
--========================================
DROP TABLE #TEMP
View 2 Replies
View Related
Jan 26, 2008
Whenever I try to install SQLServer 2005SP2 (downloaded from Microsoft Page) there is always an error message.
A recently applied update, KB921896, failed to install..
I tried downloading all the types of setup for SQLServer 2005 (x86, x64, IA) and the same error occurs..
I am using WinXP SP2, what's behind this stupid errors? I really want to start using SQL Server because i am using VWD 2008 Express. Somebody help me for this please. I need complete details. Thank You very much..
View 1 Replies
View Related
May 3, 2006
How do I insert a record into a field where I want to display a unicode value.
The unciode # is: u2265 . It is for the greater than or equals sign.
I want to write in the field: sample [is greater than or equal to] test
Thanks
View 2 Replies
View Related
Oct 2, 2007
Hello!
I'm having trouble doing a basic permission, I need to prevent one user from seeing one column in a view, such as a students phone number. However, when I deny the user from seeing the column it denys the user from viewing the entire view. Can someone tell me the correct way to deny the user from just the one column.
Thanks in advance
Chris
View 2 Replies
View Related
Jul 20, 2005
We have forms written in Visual Basic 6.0. They were previouslywritten for an Access database which was moved to SQL Server 2000.Here's the connect string I used:ODBC;UID=visualbasic;PWD=password;SERVER=MPSQL;DRI VER={SQLSERVER};DATABASE=MPPhotoThe user visualbasic and the user logged in to the computer have fullrights to the database.When they open the form which is based on a view it is opened as readonly with an error 3027. The data control is not set to read only.The database file is not read only. All of the permissions are set toallow this user read, write and modify.Can anyone hep me?
View 3 Replies
View Related
Apr 17, 2008
Hi,
Does Microsoft SQL Server 2005 Reporting Services come standard with SQL Server 2005?
If so, where can I download it.
Thanks
View 5 Replies
View Related
Jan 17, 2006
I found the following article:
http://msdn.microsoft.com/vbrun/vbfusion/usingsqlexpress/
downloaded the files for it
ran the program and encounter an error about Error Locating Server
anyone tried using that code?
any ideas what I am missing?
thanks.
View 1 Replies
View Related
