Search results for query: *

Yep, that works. But I discovered it doesn't. USE isn't recognized inside the loop because USE Master was defined first for this thread. Putting the functions inside the loop in a string and executing it spawns another thread where USE @database works. Thanks!!

I am trying to set up a procedure to take care of truncating and shrinking the t-logs of all the user db's on my server. I keep getting a syntax error on the "USE @database" line. what the heck am I missing??? USE Master DECLARE @fileName varchar(50) DECLARE @database varchar (100) DECLARE...

Thought I posted this yesterday but don't see it.... New to RS and have a report with two detail lines that I need to keep together rather than splitting over pages. I can do it in Crystal Reports but can't seem to find where it's done in RS.

MrDenny, You might be confused. I have no problem establishing a remote connection to either machine in the cluster.

HOLY CRAP I'm going out of my tree! HELP! I have a copy of the database running in a test environment, server running SQL2K5, db in 7 compatibility. I can create the full text catalog as normal and it populates just fine on it's own. No, disk space on production server is not an issue. But I...

Both instances above come up negative. Error log appears clean (with respect to running the Full text catalog) and the builtin/administrators is part of the instance.

For some reason our full text catalog won't seem to repopulate. The database is SQL2K running in SQL7 compatibility mode on a cluster. One table in the catalog. Remote to the primary machine in the cluster is the only way to stop and start Full Text search. In EM on cluster machine, I can...

Never mind. Got it!

Is is possible? So far, we're figuring not having not met with success....

Just to clarify, all check boxes are checked and the "No Authentication Required" is the only radio button?

Yes, understood. one server running Win2k in a clustered environment, one Win2k3 x64 ed.

Have set up a DTC relationship between a server running SQL2k and one running SQL2k5, in trying to fire off a trigger to update the 2k5 database, get the following: "New transaction cannot enlist in the specified transaction coordinator" The db firing the trigger is actually running in SQL7...

mrdenny, Understood. Problem is, there isn't just one account that could fire the trigger. Could be any user logged into the system under their individual local account?

Source db is on a SQL 2k platform, running in SQL 7.0 compatibility mode. Destination is a SQL 2k5 db. Source db does not use Window authentication (I didn't set it up) but the app it backs up handles it with local logins. Destination db also has it's own local logins (nope, didn't set that...

CR 8.5 (I'm stuck with it at the moment) I am either stoopid or simply having a brain cramp. But I'll be darned if I can figure out how to simply, include records where a parameter value might be null? In this report, I have two parameter elements, one a number and the other a letter. In my...

We have a CR11 report that prints its details in a numerical order, grouped by a string value. At the end of each group, we need to create a page number index but the index itself is grouped differently. So the data looks like: {Group Header:} Committee A Bill 1 A Cow bill Bill 2 Another...

HAHAHAAHAHAHAHAAHHAHAAHHA :) One more question. Is there some facility for column headings that aren't page headers? My problem is, I have a Report Header on the first page (hence the name Report Header) but when exported to Word, the page header (that holds my column headings currently)...

Thanks! Thats what I was looking for (albeit in the WRONG places!)

I have a need to produce a report in a "two column" layout, much like the pages of a magazine. Each "column" with contain a number of data elements. Want the layout to be "typical" where it starts in the upper left, goes down the left hand side of the page and then, at the bottom, starts again...

But I am not sure those messages you list are the same. They both seem to imply that the registration was successful but in my case they aren't even getting registered.