I have installed SQL Server 2005 on Windows Server 2003 Standard SP1. THe SAMPLES folder within the C:/Program Files/Microsoft SQL Server/90 folder is missing. I installed SQL Server 2005 SP2 thinking that this might create the SAMPLES folder, but it didn't get created.
Please let me know what should I do to create it. Thanks in advance.
C:Program FilesMicrosoft SQL Server90DTS folder missing. Why is this folder missing on my XP machine. I installed DTS backward compatibility components, SQL SP1 and Hot fixes. Im installing it on a non-server. Is this the reason?
View 1 Replies View RelatedI'm learning how to use audits in SQL Server 2014, but when I opened the Security folder there was no Audits folder inside. I did a bit of research and I found out that auditing is a feature in all editions of SQL Server 2012 onwards so I should have the Audits folder in order to create a new audit. There doesn't seem to be many posts like this online because the only posts I found about missing audit folders were about SQL Server 2008 (which doesn't include auditing in the standard version).
View 8 Replies View RelatedI've seen a few threads on this which seem to suppose the problem is on Express edition rather than Standard edition. Not so here.
This is definitely Standard edition, SP3 as seen by running
SELECT CONVERT(char(20), SERVERPROPERTY('Edition'))
SELECT CONVERT(char(20), SERVERPROPERTY('ProductLevel'))
In SSMS
Under the Management folder there is no "Maintenance Plans" folder.
There IS a "Maintenance Plans" folder under the Legacy Folder.
I have another instance which is Standard and SP1 which looks just fine.
I have inherited a SSRS setup and am trying to do some clean up. Problem is I cannot see the Data Sources Folder. I am setup as SA and SU on both the RS Server and SQL Server. When I go check the catalog in SQL db it does truly exist as well as a number of data sources in the folder that reports are currently using. How can I see this folder?
View 7 Replies View RelatedI have windows 2003 reporting services 2005 that has been working fine. Now all of a sudden when I go to http://localhost/reports I am unable to assign security to folders(the link is hidden) the New data source button is hidden, the new folder button is hidden, upload folder and report builder are also hidden. I am logged in as aministrator.
Also when I connect to reporting services through SQL Mgmt Studio I have the same issue, there are no options for permissions only a general option.
I'm sure it's a permissions issue but what do i do to resolve?
Thx
I'm working through the SSIS tutorial, and am on lesson 2.
This says
"Double-click Foreach File in Folder to reopen the Foreach Loop Editor.
Click Collection.
On the Collection page, select Foreach File Enumerator."
The drop down only contains
foreach ado enumerator
foreach ado.net schema_rowset.enumerator
foreach from variable.enumerator
foreach nodelist.enumerator
foreach smo.enumerator
How do I get the "foreach file in folder" to appear in the drop down list?
Gary
I dont alot about sql server 2005(Express edition). For debugging purposes i want to copy the whole app_data folder(.mdf & .log files) on the production server to another folder on the same machine(or sometimes to a network folder). So when i copy and try to paste this App_data folder to a new location, i get this error message
"cannot copy ASPNETDB: it is being used by another person or program. close any programs that might be using the file and try again."
After reading the above message, i close visual web developer, stop the website in IIS and stop the SQLExpress service on the server and try again but still get the same message.
So how can i make sure that all the programs accessing these database files are closed such that i'm able able to copy them to a different location.
I know a WMI event watcher can be used to watch for a new file being added to a folder. However, I need to check for new folders being added to an existing folder. I haven't been able to find a post on doing this. Is there a way in WQL to check for a new folder being added instead of a new file? I've used SQL for years, but am new to SSIS.
View 2 Replies View Related
Ok,
I have a network folder called A
I have a SharePoint (2007) Document Library site called B. Web Client is enabled on the server and B is mapped as a Drive (let's call it Y for this discussion)
I want to move documents in A to B. Easy enough, right? Not so....
I first started by creating a batch file that issues a COPY \A \Y /Y at the command prompt. Viola! Worked Great!
I then moved that command to a SQL Agent job as a CMDExec statement (exact same statement) and attempted to run it.....CRASH! It found the files in A but then said "The system cannot find the path specified"
Ok, so I tried it in SSIS. CRASH! Checked the error log. Same thing...
So I then checked the account under which the SQl Agent was running (special domain account for all our SQL Servers). Thinking it might mater I changed it to run under my name (I'm in Domain admin). I also ensured I had permissions to the SPS 2007 library as well. (I did).
Ran again! CRASH! Same error....
So, I created a batch file , placed thec ommand in the batch file and ran that from the command prompt! Viola! Worked Great.
So, I was thinking of how ingenious I was as I pasted my C:RootCopy.bat into my SQL Agent job. With a big grin on my face I right clicked and picked "Start Job at step".......CRASH! Same error.
Does anyone have any ideas on this ???????????????
Thanks,
Stephen
I have a set of folders with the following structure:
MainFolder
1999
SpreadsheetA.xls
SpreadsheetB.xls
SpreadsheetC.xls
2000
SpreadsheetA.xls
SpreadsheetB.xls
SpreadsheetC.xls
etc.
Is there a way that I can use the foreach loop container to loop the sub folders? My plan was to get the folder name and path into a variable, use this to build the connection string for each file in this folder, carry out the upload for that folder, then move onto the next folder and do the same thing, but I cannot see a way to do this.
Thanks,
Sam
Are there any really good pocket pc database samples that I can get access to using VB?
View 1 Replies View RelatedHello,
I am a total beginner to SQL and I'm unable to load the samples. I downloaded the .msi file and installed it but I don't know where to go from here.
Am I importing one of the samples in SQL or do I open them in Visual Basic?
The samples folder has several sub-folders with no executable so I don't know where to begin.
Can someone point me in the right direction?
thanks in advance.
Chris
Does anybody know where I can download the samples ? What I mean is not the Northwind or pubs database but samples that are usually installed in "C:Program FilesMicrosoft SQL Server90Samples" directory; I am missing them.
Thanks
I am having problem with moving a file from one folder to another folder. Here is the detailed scenario:
I want to move a input.csv file from shared input folder to shared archive folder. i am using the below code to do this.
declare @inpath varchar(100)
SET @inpath = 'move "\abcdefINPUTinput*.csv" "\abcdefARCHIVEarchive.csv"'
EXEC @filestatus = master..xp_cmdshell @inpath
but the problem was it was cutting the input.csv file from INPUT folder but not pasting it in the ARCHIVE folder.
I really appreciate if anyone can help me to solve this or anyone can tell some workarounds.
Thanks,
Hi guys,
I am about 1 day old when it comes to undertanding stored procedures so I'm at your mercy for a kick start once again :)
For my next trick I shall be attempting to create a stored procedure that will accept a whole bunch of paramaters but will not work until one paramater is tested against the database. I have no idea how to do "If/then/else" style code in a stored procedure even though I was reading up on Drop_Procedure.
I want to pass in nickname, fullname, address but if nickname already exists then return appropriate error otherwise return success symbol (maybe new rowid or num records affected).
If Not exists nickname in MyTable then
Insert nickname, fullname, address
Return Success
else
return error "Nick name already exists"
End if
The second part my problem is how do I handle this in ASP.NET? I can call a stored procedure with paramaters and collect the return value but how do I deal with errors?
Any tips on sites for Sql Server as good as www.ASP.net would also help me out.
Thank you.
Ray Brennan.
Dublin, Ireland.
I still can not get the samples databases installed. I am tring to following step 3 from
Ten Things
You Need To Know To Get Started with SQL Server 2005 Sampleswhich is
3 €“ To install the samples and sample databases
from the SQL Server 2005 Setup, you need to click the Advanced button on the Components to Install page, then expand
Books Online and Samples and select Samples. This only installs the
Samples MSI on your machine. To complete the installation, you need to
run the Samples MSI. You can do this from the Start menu: click All
Programs, click Microsoft SQL Server 2005, click Documentation and Tutorials,
click Samples, and then click Microsoft SQL Server 2005 Samples.
By copying the SQLEXPR.EXE to the directory containing the SQL .exe I can get to "SQL Server 2005 Express Setup" (note it is not SQL Server 2005 Setup) using CHANGE from ADD/REMOVE programs; however, there is no Advanced button so I can't complete step three.
All the databases and tuturials seem to be in the right directories. I have explored SSME and the config utility and do not see anyway to do this using them.
Has anyone installed and used the sample databases?
Thanks,
R
I am trying to run the Readme_HelloWorld sample on the SQL server 2005 Books online. But don't know where I can get the setup.sql, SendMessage.sql, ReceiveMessage.sql scripts.
I followed two examples on the blog, but they did not work at all. Here are the scripts:
/* example 1 */
create database TestSB
go
use TestSB
go
create queue TxQ
create queue RxQ
create message type Msg
create contract MsgContract(Msg SENT BY ANY)
create service TxSve on Queue TxQ
Create service RxSve on Queue RxQ
declare @h uniqueidentifier
begin dialog conversation @h
from service TxSve to Service 'RxSve'
on contract MsgContract;
send on conversation @h Message type Msg ('<hello>World</hello>')
end conversation @h with CLEANUP;
select *
from RxQ
/* example 2 */
use testsb
go
create message type HelloMessage
validation = NONE
go
/** 2. create contract **/
create contract HelloContract
(HelloMessage SENT by initiator)
/** 3. create queue **/
create queue SenderQueue
create queue ReceiverQueue
/** 4. create service **/
create service sender
on queue SenderQueue
create service receiver
on queue ReceiverQueue(HelloContract)
declare @handle uniqueidentifier
declare @message nvarchar(100)
begin
begin transaction;
begin dialog conversation @handle
from service sender
to service 'receiver'
on contract HelloContract
set @message = N'Hello, World';
send on conversation @handle
message type HelloMessage(@message)
end conversation @handle
commit transaction
end
go
Receive convert(nvarchar(max), message_body) as message1
from ReceiverQueue
select convert(nvarchar(max), message_body) as message1
from ReceiverQueue
select *
from SenderQueue
select *
from Receiverqueue
Any assistance or WORKING samples are greatly appreciated.
My current query has the following fields.:
Analyte, Sample, Result, MDL, SRL
The query results currently look like this.
Benzene, 01, 3.50, 2.00, 2.1
Benzene, 02, 2.34, 1.99, 2.1
Benzene, 03, 5.34, 1.99, 2.1
Carbon, 01, 4.20, 2.00, 1.1
Chloroform, 02, 3.1, 2.09, 1.8
Chloroform, 03, 9.1, 7.09, 1.8
Carbon, 03, 5.20, 1.00, 2.1
Chloroform, 01, 6.1, 2.09, 1.8
Ultimately, the above query will need to be exported to Excel using VB and I looked at pivot tables, but no result will allow me to generate a query in the following fashion.
Analyte, Sample1, Result, MDL SRL Sample2,Result, MDL SRL Sample3,Result, MDL SRL
Benzene, 01, 3.50, 2.00, 2.1 02, 2.34, 1.99, 2.1 03, 5.34, 1.99, 2.1
Carbon, 01, 4.20, 2.00, 1.1 03, 5.20, 1.00, 2.1
Chloroform 01, 6.1, 2.09, 1.8 02, 3.1, 2.09, 1.8 03, 9.1, 7.09, 1.8
The analyte needs to be listed only once, and if there are results, they will need to be displayed from left to right since the analyte will be listed just on a row, the number of samples go from left to right. Please note, I have no way of knowing how many samples will be listed it could be 3 or 20. Thanks kindly for your help on this, I have worked on it for a week already and looked at doing it from VB, but that got more complicated than it needs to be.
Hi every body!
I'm doing a topic about "Merge raplication". But i can't find a sample script in : C:Microsoft SQL Server80ToolsDevtoolsSamplessqlrepldeflt_sp
If anybody has it, please sent it to me! Please!
Thanks a lot!
My enail: vinhphuocptit@gmail.com
Hi All,
I have installed SQL 2005, but there is not a,
Integration Services Samples.
The SQL 2005 manuals says:
"By default, the Integration Services samples are installed onto the local hard disk drive in the following folder: C:Program FilesMicrosoft SQL Server90Samples"
But there is not "Samples" dir inder C:Program FilesMicrosoft SQL Server90
Where I could get the samples ?
Sergiy
the book "microsoft sql server 2005 integration services" by kirk haselden claims you can download examples and source code at www.samspublishing.com
er no
what happens is this
go to the site
look for the 'downloads' link
see there isn't one
search for authors
h etc.... lose a few minutes of your life
find the book
yay
it forces you to sign up for an account in order to get the samples - outrageous
prepare for endless spam from sams
sign up
click on download samples
find the configedit folder
load into vs
run it
it doesn't work!!
thanks
Warning 1 The referenced component 'SourceLibrary' could not be found.
Warning 2 The referenced component 'SourceGrid2' could not be found.
Error 3 Unable to find source file 'K:MASSoftware and ToolsSamplesSSISKirk Haselden bookSamplesSRCUtilitiesConfigEditConfigurationsEditorinDebugConfigurationsEditor.exe' for assembly 'ConfigurationsEditor.exe', located in '[TARGETDIR]' K:MASSoftware and ToolsSamplesSSISKirk Haselden bookSamplesSRCUtilitiesConfigEditSetupConfigEditSetupConfigEdit.vdproj SetupConfigEdit
Error 4 The type or namespace name 'SourceGrid2' could not be found (are you missing a using directive or an assembly reference?) K:MASSoftware and ToolsSamplesSSISKirk Haselden bookSamplesSRCUtilitiesConfigEditConfigEditControlConfigEdit.cs 9 7 ConfigEdit
Error 5 The type or namespace name 'SourceGrid2' could not be found (are you missing a using directive or an assembly reference?) K:MASSoftware and ToolsSamplesSSISKirk Haselden bookSamplesSRCUtilitiesConfigEditConfigEditControlConfigEdit.cs 10 7 ConfigEdit
Error 6 The type or namespace name 'SourceGrid2' could not be found (are you missing a using directive or an assembly reference?) K:MASSoftware and ToolsSamplesSSISKirk Haselden bookSamplesSRCUtilitiesConfigEditConfigEditControlConfigEdit.cs 87 40 ConfigEdit
Error 7 The type or namespace name 'SourceGrid2' could not be found (are you missing a using directive or an assembly reference?) K:MASSoftware and ToolsSamplesSSISKirk Haselden bookSamplesSRCUtilitiesConfigEditConfigEditControlConfigEdit.cs 11 15 ConfigEdit
Error 8 The type or namespace name 'SourceGrid2' could not be found (are you missing a using directive or an assembly reference?) K:MASSoftware and ToolsSamplesSSISKirk Haselden bookSamplesSRCUtilitiesConfigEditConfigEditControlConfigEdit.cs 24 17 ConfigEdit
Error 9 The type or namespace name 'SourceGrid2' could not be found (are you missing a using directive or an assembly reference?) K:MASSoftware and ToolsSamplesSSISKirk Haselden bookSamplesSRCUtilitiesConfigEditConfigEditControlConfigEdit.cs 25 11 ConfigEdit
Error 10 The type or namespace name 'SourceGrid2' could not be found (are you missing a using directive or an assembly reference?) K:MASSoftware and ToolsSamplesSSISKirk Haselden bookSamplesSRCUtilitiesConfigEditConfigEditControlConfigEdit.Designer.cs 318 17 ConfigEdit
Error 11 Metadata file 'K:MASSoftware and ToolsSamplesSSISKirk Haselden bookSamplesSRCUtilitiesConfigEditConfigEditControlinDebugConfigEdit.dll' could not be found ConfigurationsEditor
Warning 12 Could not resolve this reference. Could not locate the assembly "SourceGrid2". Check to make sure the assembly exists on disk. If this reference is required by your code, you may get compilation errors. ConfigEdit
Warning 13 Could not resolve this reference. Could not locate the assembly "SourceLibrary". Check to make sure the assembly exists on disk. If this reference is required by your code, you may get compilation errors. ConfigEdit
one could argue that ssis should have a config editor supplied with it, instead of having to go into notepad
Hi,
I'm looking for the sample application : IBuySpy Delivery Sample Application (SQL Server Compact). But I could not find this sample file anywhere.
The only sample which is available in my local directory below is Northwind.sdf file
C:Program FilesMicrosoft SQL Server Compact Editionv3.5Samples
The link in the Book Online is pointing to this URL below :
http://www.microsoft.com/downloads/details.aspx?FamilyID=1ff0529a-eb1f-4044-b4b7-40b00710f7b7&displaylang=en
Can anyone help me on this?
Thanks,
I have installed the documentation and samples and the management studio for sql 2005 express edition, but when trying to work through the samples, I get this error message, for some reason I can't include the Adventure works db. Whatn I'm I not doing right? Please can someone help!
1> SELECT name from sys.databases
2> Go
name
--------------------------------------------------------------------------------
------------------------------------------------
master
tempdb
model
msdb
1> CREATE DATABASE [AdventureWorks] ON
2> (AdventureWorks = N'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData
< AdventureWorks>.mdf' ),
3> (AdventureWorks = N'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData
< AdventureWorks>.ldf' )
4> FOR ATTACH ;
5> GO
Msg 153, Level 15, State 1, Server YOUR-V7OY5L24PGSQLEXPRESS, Line 2
Invalid usage of the option AdventureWorks in the CREATE/ALTER DATABASE statemen
t.
1> USE [master]
2> GO
Changed database context to 'master'.
1> CREATE DATABASE [AdventureWorks] ON
2> (AdventureWorks = N'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData
< AdventureWorks>.mdf' ),
3> (AdventureWorks = N'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData
< AdventureWorks>.ldf' )
4> FOR ATTACH ;
5> GO
Msg 153, Level 15, State 1, Server YOUR-V7OY5L24PGSQLEXPRESS, Line 2
Invalid usage of the option AdventureWorks in the CREATE/ALTER DATABASE statemen
t.
1> select name from sys.databases
2> go
name
--------------------------------------------------------------------------------
------------------------------------------------
master
tempdb
model
msdb
(4 rows affected)
1>
There are five msi files listed for downloading.
SqlServerSamples.msi
AdventureWorksDB.msi
AdventureWorksDBCI.msi
AdventureWorksBI.msi
AdventureWorksBICI.msi
What are the AdventureWorksDBCI.ms and AdventureWorksBICI.msi used for? I try to run it, but it return the message "Another version of this product is already installed" and ask me remove the old version of this product. Anybody know what I should remove?
Thanks,
I would like to have more info on UserInstances concept of SQLExpress 2005.
Can i find any code samples for this feature in MSDN.
I have tried using the following links..
http://msdn2.microsoft.com/en-us/library/ms143401(SQL.90).aspx
http://msdn2.microsoft.com/en-us/library/ms143684(SQL.90).aspx
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sqlexpuserinst.asp
http://msdn2.microsoft.com/en-us/library/ms254504.aspx
http://msdn2.microsoft.com/en-us/library/ms165690(SQL.90).aspx
http://msdn2.microsoft.com/en-us/library/ms143446(SQL.90).aspx
any other links will be helpful for me in this regard.
Thanks,
Vaishu
Hi,I have installed the Sql server 2005 standerd edition to my computer
but i cant find this folder to view report service authentication samples ?
C:Program FilesMicrosoft SQL Server90Samples ?
but i can see C:Program FilesMicrosoft SQL Server90 folder !
any idea ?
sujithf
Edited by SomeNewKid. Please post code between <code> and </code> tags.
Right now i'm just trying to get the page to update SQL, but its not working no errors or anything but still not updating?!?!
Any ideas? Thanks in advance
Ben
<%
Dim cnnSimple ' ADO connection
Dim rstSimple ' ADO recordset
Set cnnSimple = Server.CreateObject("ADODB.Connection")
cnnSimple.Open Blah Blah Blah
Set rstSimple = cnnSimple.Execute("SELECT * FROM WK_DATA WHERE WEEK_NUM = 2")
%>
<input name="Submit" type="button" value="Add">
<%
If Request.Form("Submit") = "Add" Then
cnnSimple.Execute("UPDATE WK_DATA SET PRICE = (PRICE + 1) WHERE WEEK_NUM = 2")
rstSimple.update
End If
cnnSimple.Close
Set cnnSimple = Nothing
%>
Hi,
Do anybody have sample packages of how to use Import Column Transformation?
I couldn't make any sample package by going through the information present in the Microsoft site.
Can anybody help me out?
Thanks,
Sreekanth Ammisetty
ok, I've installed sql server, run the install samples and database, but when I go into SQL Server, the database and samples are not there. How do I connect the two?
thx,
Kat
Hi,
Can someone tell me where I can download the "SQL Server 2005 BI Metadata Samples toolkit"? Seems the old ulr doesn't work right now.
Thanks in advance.
Mike
Hi all
I am working as Production DBA (SLA based),I want Project matrix samples
Could you some body help me by sending Project matrix.
Any advice or Sample appreciated
Downloaded the file for the Adventure Works DB Sample. Which folder do I need to install it in to have show up in SQL Server Express 2005??
View 5 Replies View Related