As you may or may not read in another thread I created...I am having trouble implementing the drill down..I actually have it implemented and it works great in the ReportDesigner preview pane...but when I deploy to the ReportServer and page just reloads itself when I click on the (-) for drill into.Any ideas?
2004-05-20
bcp data out, then bcp into temptable using -F, -L parameters.
2004-04-05
First, that's NOT a large database. I've restored a 200+ GB database (yes, that's GIGABYTE).Next, how did you do the restore? Can you post your script?It looks like you may have used WITH NORECOVERY which will leave the database in LOADING state awaiting other backup files.WITH NORECOVERY is used when you have to also restore […]
2004-03-30
Brian,These are SQL Server users. As I said, after giving them db_datawriter role some of them assume it right away, but for some other I have to go into "Permissions" and manually click on each object to grant access.By the way, if you assign db_datawriter role to a user and then go to the User Properties - […]
2004-03-30
Not knowing what your specific needs are for standards I suggest look at this thread for a common theme answer. http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=108092#bm108121 If not usefull can you be a bit more descriptive on your plans and what you are looking for?
2004-03-26
Hmmm... Well here is a quick sample SP I just wrote that should help you with the variable usage. USE pubs GO -- First check to see if the sproc exists and if so drop it. IF EXISTS(SELECT * FROM sysobjects WHERE id = object_id('MySampleSproc')) DROP PROCEDURE MySampleSproc GO /*--------------------------------------------------------------------------------------- Name: MySampleSprocDescription: sample procedure for […]
2004-03-24
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-03-22
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-03-22
Can forum participants tell me if the following would possibly have an adverse impact:a. an OS backup in progress which was temporarily reading the event file.b. a virus checker which might have been reading the event logc. a remote reader of the server's event logd. an OS search type function which was scanning the event log for […]
2004-03-19
1 reads
You can do 10 fetches. But this will generate 10 result sets ... :create procedure aa @rowset integer as begin SET NOCOUNT ON DECLARE @pos integer, @co int DECLARE cPartners SCROLL CURSOR FOR SELECT * FROM partners OPEN cPartners set @pos = @rowset * 10 set @co = 0 goto FETCHNEXT while @co < […]
2004-03-18
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers