APS

Technical Article

RE: sp_ExecuteSql permission chaining

  • Reply

No, not in SQL Server 2000 (there is help on the way in SQL Server 2005). When you run dynamic SQL in SQL Server 2000, it executes that code in a separate batch from the first. That means new security checks and ownership chaining is not continued from the calling stored procedure. You could create […]

2004-08-12

Technical Article

compute by [altered date] ???

  • Topic

Hi,Using SQL2K, can anyone make this work ? Whenever I try to compute by an altered date I get stuck...What I want is this: (this works)use northwind go select OrderDate, CustomerID, count(*) from dbo.Orders group by OrderDate, CustomerID order by OrderDate, CustomerID compute sum(count(*)) by OrderDateBUT using an converted date such as the following: (this fails)use […]

2004-08-10

2 reads

Technical Article

Recovery Scenarios

  • Topic

Greetings,Does anyone have some illustrations of recovery scenarios when media failure, and server crashes suddenly occur? My other scenario question is how does SQL Server handle torn pages in a database if media failure or server crashes occur whether you have torn pages detection on or off? TAtlanta, Ga

2004-08-04

1 reads

Technical Article

How to create a Data Dictionary in SQL

  • Topic

I want to create a Data Dictionary in SQL Server 2000(concept taken from Oracle, but with a little variation) and in that I want to capture all the table names, DB name , last updated on , last updated (by) Login, Rows before update , Rows after update. This I want to build for one server, […]

2004-08-04

2 reads

Technical Article

Viewing print statement output from JDBC

  • Topic

 HiIf you put helpful debugging print statements in your TSQL how do you get to see them when you execute the stored procedure from something other than Query Analyzer e.g. from a JAva program.I think they might be appearing on a console somewhere? If so how can you see that remotely?ThanksSean

2004-07-29

389 reads

Technical Article

RE: Delete taking too long

  • Reply

If you are absolutely positive that the records that you are about to delete don't have an related records in other tables then, as part of the delete process, try dropping the constraint before you do the delete then re-enable the constraint afterwards.

2004-07-29

Blogs

Daily Coping 30 Nov 2022

By

Today’s coping tip is to learn a new skill from a friend or share...

Encrypting Your SQL Data Should be Your Default Option

By

Cyber-attacks and data breaches seem to be perpetually on the rise. Every week we...

Power BI Embedded: Using Row-Level Security for Multilingual Reports

By

Making multilingual reports in Power BI requires a lot of different elements. Translations can...

Read the latest Blogs

Forums

How to apply rates in a time column

By pedroccamara

Hello all I have this selected column : convert(TT.horas, Time) AS TimeTT, this column...

Designing Database from a piece of paper

By ciss1

Greetings experts, Hopefully, this is the forum for my question. I am trying to...

Sum up different dates

By pelusch

Hi guys To the table below - I want to sum up the amount...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers