Forum Replies Created
Viewing 15 posts - 35,911 through 35,925 (of 39,720 total)
-
RE: SQL Server and other applications
Also keep in mind that putting multiple apps gives the vendors the opportunity to point fingers at each other and slow your support.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002...
-
RE: Retrieving Images from SQL server & resizing
The retrieval is like any other image data, you get it. To get the size, your client needs to understand that this is image data so you need to somehow...
-
RE: How Can I find who drop a database
I don't think there is a way to know this after the fact. Possibly Log Explorer from Lumigent could get this info.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 -...
-
RE: SQL Server Product
Nothing I know of, but shouldn't be too hard to script.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Error: 7102 - SQL2000
Not sure. haven't seen it, but I might be tempted to burn a call to PSS if I had a contract.
Steve Jones
-
RE: DRI permission for a function
Delarative Referential Integrity. Means you have FK reference permissions needed.
Steve Jones
-
RE: Upgrading SQL7 to SQL2000
Haven't done it in awhile, but should be pretty smooth. Course I've got to do one next week, so if anything happens, post it here.
Steve Jones
-
RE: Never mind...
-
RE: SQL Server and other applications
It happens, I know it's happened to me. All you can do is document and voice your concerns as a CYA and deal with it the best you can.
Let us...
-
RE: Max Memory recommendation?
SQL will leave memory for the OS, but the deallocation and reallocation can be (relatively) slow sometimes. If you have concerns or issues, you should set it.
Hard to determine exactly...
-
RE: 4 Excel Columns into one
I think that you want to setup the transform as anm ActiveX task and then use the CHR() function in the VB Script.
Steve Jones
-
RE: Connecting to dBs with different userid and pwd
I'd use roles, transfer the permission to the role and grant to both users.
Steve Jones
-
RE: Data dictionary
This is always a little kludge and I haven't seen any great ways to do it. Embarkadero's ER/Studio would do some as would one of FMS Software's products. Not sure...
-
RE: Given a date Find the Stored Procedures Updated
The alter statement will not update a date, but it will update the base_schema_ver. You'd have to know the previous versions, but this goes up by 16 with each ALTER.
Steve...
-
RE: Table Order!
Frank is correct. There is no benefit to the order of the tables in the statement. This is different from Oracle I believe.
The optimizer considers the request and may reorder...
Viewing 15 posts - 35,911 through 35,925 (of 39,720 total)