Data Flow Design Discussion
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!
2005-02-08
training
RE: Permissions for full-text indexing
Gary, Yes, you are correct. Your user must have the server administrator permission level to admister Full-text Search, even though he has the DBO permission level. Specificly, see SQL Server 2000 BOL title "sp_fulltext_catalog" - "Only members of the sysadmin fixed server role and the db_owner (or higher) fixed database roles can execute sp_fulltext_catalog" as […]
2005-01-26
RE: Listening over multiple IP''''s
It will listen on both connections and route accordingly. I don't think you want to bridge the connections and route traffic between them. I used to have 3 networks connected (3 NICs) on one of our boxes. 1 for the web server traffic, 1 for DBA/developer traffic from the office and 1 dedicated to backup […]
2005-01-25
User''s NT Login as a Parameter in a SRS Report
Does anyone know of a way to use the user's NT login that authenticates with SRS as a parameter in a SRS report. I need to pass the user's login (domain\jdoe) to the report to cross reference that with a table that will provide a parameter for the department value in a report.
2005-01-24
Data Import Automation
OK,I'm a real newbie to MS SQL Server but I'm trying to make the transition from the MS Access way of doing things to a more SQL Server driven model.I have a MS Access routine that will use the Dir() command to loop through a directory and grab every file with a specified extension and […]
2004-09-03
2 reads
RE: Question of the Day for 03 Sep 2004
Exactly. The question should read "over 2 billion objects". The thing the documentation doesn't indicate is whether or not that includes the system objects. I guess when you are talking about billions, a couple hundred don't matter. Just curious though.http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
2004-09-03
Question of the Day for 24 Sep 2004
Comments posted to this topic are about the Question of the Day for 24 Sep 2004 posted at http://qa.sqlservercentral.com/testcenter/qod.asp?QuestionID=343.
2004-08-23
Question of the Day for 23 Sep 2004
Comments posted to this topic are about the Question of the Day for 23 Sep 2004 posted at http://qa.sqlservercentral.com/testcenter/qod.asp?QuestionID=342.
2004-08-23
1 reads
RE: How to combine these 2 Select Statements
Hi,To test a script I might need a table, Creating myself time consumes.Pls export couple of records from each tables you use in the query into EXCEL and zip it and fwd to me. So I can help you outRgds- Ahmed
2004-08-19
RE: problem in creating a package in oracle 8.i
Use show errors package in sqlplus to check the errorShow errors also works for procedure etcYou would also need to reference the package in your insert i.e. package_name.object_name - the package is external - treat it as a container
2004-08-19
1 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers