Apress pro t-sql 2005. so far it seems pretty good in clearing up a lot of things Ive been doing but wasnt really sure I understood the same way I understand for example, C#. It was the little things about the language that Ive never been realy clear on such as basic control flow statements. Anyone else read this book yet ?
View 2 RepliesWithin my script component I was having some difficulty getting nested Exceptions to bubble out of the script component logic. The symptom appears when you get an ex.message of "Object reference not set to an instance of an object." As soon as I removed the Finally section my message (or the actual Exception object) was properly passed to the caller.
I've only done minimal work with Try/Catch/Finally structures. Is this normal?
Thanks,
Jeff Tolman
E&M Electric
I am trying to make all reports on SSRS location specific. e.g I only people who work in certain locations will be able to view certain parameters.
I figured that I can do this using User!User.ID and an access control list. I have tested this by manually creating a sample ACL but I want to be able to automatically populate the list with data from AD.
I can find lots of stuff online that allowed me to extract information from AD but I cannot see a way of creating a full list which includes memberships.
e.g:-
USERNAME MEMBER OF
User1 location1
User1 location2
User1 location3
User2 location1
User2 location4
I am able to get users by specifying a group and getting memberships by specifying a user but I am not able to get a full list.
i have created a ADSI link server.
So where do I go from here/
SSMS doesn't seem to have anything like QA?
I spent the better part of today installing everything...read somewhere about using VS to write code for sprocs.
What does everyone else do?
Good morning (or afternoon, depending on your local).I've finally crossed over from Access to SQL Server. An interesting step fraught with surprises, syntax quirks and occasionally some exclamations of joy (just kidding).Anyway, here's my first question. I'm working on moving a currently functioning VB app from an Access backend to a SQL Server back end. In the process, I have been converting my app driven SQL calls to Server based stored procedures. Aside from a few issues (like SQL not liking concatenating string with the &), everything has worked out until this gem: SET NOCOUNT ONTRANSFORM Max(tE.EntryKey) AS Expr1 SELECT tE.ProjectKey FROM TS_tblWeeks tWINNER JOIN (TS_tblProjects tPINNER JOIN (TS_qryGroup tGINNER JOIN TS_tblEntry tE ON tG.GroupKey = tE.GroupKey) ON tP.ProjectKey = tE.ProjectKey) ON tW.WeekKey = tE.WeekKey WHERE (tE.WeekKey) = 1 And (tE.PersonKey) = 1GROUP BY tW.WeekKey, tE.ProjectKey, tP.ProjectSortORDER BY tW.WeekKey, tP.ProjectSort, tG.GroupKeyPIVOT tG.GroupKey;SQL server reports:Msg 102, Level 15, State 1, Line 1Incorrect syntax near 'tE'.Msg 156, Level 15, State 1, Line 13Incorrect syntax near the keyword 'PIVOT'.The highlighted lines are the TRANSFORM and PIVOT lines.The query works fine in Access, and works fine through ADO.NET as a supplied query. My intention is to make the two integers in the WHERE clause to be parameters supplied to the procedure.It's something simple, isn't it?Thanks!
View 14 Replies View RelatedHi all,
We have 2003 EE 64 bit & SQL 2005 EE 64 bit as well(service packs for windows & SQL pack 2 (9.030.42), now I have discovered this things with conversion of DTS to SSIS... We have set Oracle linked servers - they are working, at least we can see stuff, haven't tried to write on Oracle yet, sqlplus is also able to connect to oracle servers.. Our Oracle guy have installed 10.2.0.3 patch 10, but still no luck with SSIS...I'm not going to rename folders on production, like someone suggested it here...I checked path also, there was seems to be required folders included..I even tried to create SSIS on my PC and deployed it on 64 bit, using files method, without saving on SQL server - doesn't work, when it hit part with Oracle connection..And in connection string it looks like it use OLEDB..
I'm not excited about using OPENQuery etc, instead of SSIS.. It's just driving me nuts with this things...How Microsoft testing this stuff if bunch of people facing this issues and there's still no officiall fix or something like that..
I have a linked server setup in dev environment which is pointing to ORACLE server of a third-party. I m on sql server 2008 r2 and using BIDS 2008 for building an SSIS package which would pull data from oracle and do a look up in SQL server table to get a final extract. Now the query which pulls data from a single table from linked server is like the one below
select * from [oracle linked server ]..dbo.tablename a
left join mySQLSERVERtable b
on a.id=b.id
Note:I can execute this query on SSMS as the linked server is setup -[oracle linked server ] and I have sql oledb connection manager for dev environment already configured in my ssis package .
My questions are do I need to create a SSIS CONNECTION manager specifically for linked server in my ssis package ?
Are there any best practices which we follow when using linked servers in this context ? I am thinking will the join suffer performance issue and what kind of exceptions I need to write when the linked server connection is broken.
Hi Friends,
I have a question. At my home computer i downloaded and installed VWD. As usual it also installed Sqlexpress as part of the installation(i checked the option). Later on i downloaded Management studio separately so i am fine with my home computer as every thing is free.
But at work we decided to develop application using VS 2005 and Sqlserver 2005. So we bought and installed VS2005 professional edition at work and it also installed Sqlexpress during the installation as a defualt desktop engine. I am fine with that too. But i am not understing where do i get the Management studio? Is it some thing i could get it off the web for free or what? I am not sure we would have an option while installing the VS 2005 professional that also does install management studio and we need to check that option. I am not sure if we could get the management studion off the web for free and and evelop applications.
Please advise. Thanks -L
Please help. I'm completely new to SSIS, and I was hoping someone could point me in the right direction(s).
I am developing a winforms client app, and I need to be able to provide the user with the ability to import data in CSV format into our application's database.
I'd like to use SSIS if possible, as long as what I am trying to do isn't near impossible.
I'm thinking of a UI where the user can specify a flat file (CSV) to upload and be processed by an SSIS package on a remote database server.
This package will be responsible for validating the CSV file and inserting data into the database as appropriate.
Is there a way I can:
launch an SSIS package remotely, from a winforms app on the client machine that is not running SQL server (preferably asynchronously) -- and pass it some parameters, including the import file itself
(optionally) provide progress feedback to the client pc to let them know it is being processed
display a nice SSRS report on the client upon completion that tells them exactly what the success/failure of the import was (how many rows processed, which ones failed and why, etc)
Any helpful examples, links, etc would be most appreciated.
Thanks in advance!
Hello friends....
my question is as follows:
How do I send the data from the server side to the client side specifically in what format and what kind of connection do I use?
waiting for answers.....
Can anyone recommend a good book on DTS?
View 1 Replies View RelatedFor those of us struggling with DTS, you've probably all seen
Professional SQL Server 2000 DTS
Mark Chaffin, Brian Knight, and Todd Robinson
WROX
ISBN 1-861004-41-9
This is brand new:
Microsoft SQL Server 2000 DTS
Timothy Peterson
SAMS
ISBN 0-672-32011-8
I have both and they're both worth owning.
I also just found a reference to the following, but I haven't seen it so I count vouch for it. (I also wonder why I haven't stumbled across it previously...)
Professional SQL Server 7.0 Development Using SQL-DMO, SQL-NA and DTS
Frank Miller & Rachelle Reese
WROX
ISBN 1861002807
I read alot of Technical books on SQL and I have found that SQL for dummies is actually a pretty good book(nice reference)
View 1 Replies View RelatedI really like to pass my books on, for small price to anyone who could use them, since I no longer need 'em. I've got one , the SQL 2000 Administrator's Companion. Please take a look, I put it on ebay:
http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&category=36313&item=3593450436
Thanks
/rob
Ok, look. I could sit here and ask about 1,000 different queries that I would like to have. I'd much rather prefer to find it on my own however. Could someone please recommend a book that will tell me all I need to know about performing different kinds of queries? I have limited Mysql, JavaDB experience. A beginner compared to most of you. Thx in advance for any replies.
View 2 Replies View RelatedHi
Which is the best book to refer for SQL Server 2005
thanks
Hi to all, I ask to everybody which is the best book of the MS SQl Server 2000.I search in particulary a book complete and advanced.ThanksAlex Palermo
View 6 Replies View RelatedIt seems that there are only two books on SSIS
The Rational Guide to Scripting SQL Server 2005 - BETA preview
Professional SQL Server 2005 Integration Services by wrox
Has anyone read these or any other ones out there?
Any thoughts on which to get?
I am very new to SSIS.
Thanks
Hi,
Can you recommend a book on SSIS.
I am particularly interested in books which demonstrate a particular project from start to finish while going through chapters.
Thanks
Hi I tried to download the E-Book that is located on the benefits page, when i click to save it to hard drive it just sits and nevers start the process. What can I do to correct this matter. Thank you for you time and effort.
DKB
I'm looking for a good book to teach me the basics of SQL Server DBA - installing, daily routine tasks, basic best practices, etc. I'm a DBA newbie so I want beginning level.
View 4 Replies View RelatedCan you recommend a book on Integration services in sql server 2005?
Thanks
hello
i am just starting to learn sql and know the basics, but now im looking for a good book to learn some more. A book that covers stored procedure would be very useful. If possible a book with q and a would be very good because i feel this tests if u understand what was just explaned. but if there is a good book without this it is ok. All sugestions welcome
NubNub
I'm looking for a book or a couple of books to learn SQL (in general aswell as various versions from different vendors). A couple of books that would take me from beginner through advanced topics. Any good suggestions?
/ ludde@freebox.com
I have been using DTS somewhat, but I would like to read a good discussion (with cpmplex examples) of it.
Anyone found either a book on DTS or a good section in a book?
Thanks,
Judith
Any recommendations on a good SQL 7.0 Systems Admin book for future DBAs? Too many books at the store, so i'm wondering how i can narrow it down. I'm looking more for the Admin side rather than developer side type book. Thanks.
View 2 Replies View RelatedDoes anybody recomand me good book for sql server administrator and programmer?
View 1 Replies View RelatedHi All,
I am new to SQL Server but have been doing database programming since last 3 years. I recently attended MOC (Microsfot Official Curriculum) training on SQL Server and have started to use at my company. I am comfortable with SQL but want to dig deeper into T-SQL side. I searched on the Internet but not many good books available in that either they are ranked very low or are very old i.e. written around 1999/2000 or covers SQL Server 2000 as a whole. Can anybody suggest me any T-SQL book which was written recently and focuses purely or majorly on T-SQL?
Thanks to all for your time and advice in advance.
Regards:
Prathmesh
Can anyone recomend a really good text book on sql Server. Something that gives alot of useful code for real world apps. But also needs to easy to understand.
View 1 Replies View RelatedWhat would you recommend for a good MDX book ?
specifically, for syntax, data structures and sample code.
thx
C
I've been a SQL Server dba for 5 or 6 years now. With the upcoming release (eventually, I'm sure) of Yukon/SQL2005, I've read that it's important for DBA's to pick up one of the .NET languages - I've figured, I'll try to learn VB.NET - I've had a little exposure to it, and can usually figure out what's going on in VB code I've read - however, I seriously doubt I could write anything in it from scratch - I want to learn it in a bad way - can you all recommend any self-paced books that will walk me thru it? I've never had any formal training with it, don't know a class from a DLL....Thanks in advance for your help!!
View 3 Replies View RelatedHi
I am new to SQL2000 and also in RDBMS.
Pls suggesst the book which is helpful for me.
Thanks...
asm
Hi All
I have bought this book called " The complete reference guide to SQL'. I'm trying to read throught it etc, however it brings a cd with the sample db that is used through out the book, it mentions that you can load it and use it to practice..........however all the files are in .DAT format and I have no idea how to load it into SQL server 2000 :(
Can anyone help please ?
Thanks in advance