Forum Replies Created
Viewing 15 posts - 37,366 through 37,380 (of 39,511 total)
-
RE: How to create an update SP without Dynamic SQL?
Not pretty, but I'd create several stored procedures to handle the cases. Then use a master stored procedure to accept the parameters and then "call" the appropriate sp(s) for that...
-
RE: count(*)
count(*) usually pulls the count from sysindexes. There were problems with this being accurate in SQL 65 (possible 70). I think in 2000, this is accurate.
Steve Jones
-
RE: Fatal Error 605
Perhaps some data item is causing QA to drop the connection. Is this a specific table or all tables/servers? Is it the same amount of rows each time?
Steve Jones
-
RE: Fatal Error 605
Perhaps some data item is causing QA to drop the connection. Is this a specific table or all tables/servers? Is it the same amount of rows each time?
Steve Jones
-
RE: How to shrink a lagre log file
If the log file doesn't shrink (after following both posts above), there is a script in the library here that will help.
Steve Jones
-
RE: Restoring backup, can't get into EM
Can you connect via isql? Or Query Analyzer?
EM uses more than one connection and if you are single user mode, you cannot use this.
Steve Jones
-
RE: help - i think somebody is 'hacking' our server
And please follow up here. I (and others) are curious to find out what is happening.
Steve Jones
-
RE: Remote DR site suggestions
I agree a log would be the outage window, but keep in mind if you are out for longer than the window for a transaction log, you will need to...
-
RE: working with extents
Clustered index stores the data in the order of the index (physically). Nice for columns used in range queries (like dates). Only one per table as you can only store...
-
RE: Want to create a Cross Tab view using Pivot Table
Not easy. You'd have to build a SQL join for each column you need. USually this is done with dynamic SQL as
select emp.emp-code, b.time as b.date, c.time as c.date
...
-
RE: xp-sendmail to send HTML text
You can in T-SQL, but it's an ugly mail message you have to build. I too wish MS had included this.
Send it to sqlwish@microsoft.com
Steve Jones
-
RE: Windows Auth vs SQL Server account...
When you use Windows Auth, the windows credentials (essentially a token) are passed to SQL Server, which then verifies this with a DC.
First, it's a security risk across the Internet...
-
RE: Permissions on nested stored procs
Antares is correct. When you execute certain stored procedures (system ones) permissions are rechecked for security purposes. I think the solution proposed above is a great one.
Steve Jones
Viewing 15 posts - 37,366 through 37,380 (of 39,511 total)