security

Weekdays between two days

• by John-Crass

• SQLServerCentral.com

• Topic

I had found some elegant code posted here to calculate the number of days minus weekends between two given dates. And, I cannot locate it now. Can someone post it if they a script to do it or point to the right area?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2002-03-22

1 reads

Client install created an instance

• by raghu_nandan1

• MSDN Communities

• Topic

Hi, I was installing SQLServer 2000 on my work station (OS WIndows 2000), and wanted to install only the client without creating an instance of SQLServer on my local machine, I could do that in SQLServer 7.0 on NT 4.0 machine, can I do it now or has it changed ? While installation, it gave […]

2002-03-21

Locale ID and Unicode problems

• by stimpyjcat

• SearchSQLServer

• Topic

Hi, I have inherited a SQL Server that now requires one of the databases to be moved from it to a new server. The problem is that this process really needs to be done using a backup & restore*, when I try to restore it to the new server I'm getting the annoying message that […]

2002-03-20

263 reads

Simple backup DB questions

• by Barkingdog

• SimpleTalk

• Topic

When I copy a database to another server I want to be sure that I have copied all the data in the original database. 1. I can copy the MDF/LDF files (Sql 7+) to a new server and be sure that all the data in the database and trans logs is copied. Is this correct? […]

2002-03-19

run a trace using profiler on a database

• by koonpark

• Other

• Topic

Does anyone know how to run a trace just against one database instead against a server?? This is SQL server 7/2000 that we are talking about. Thanks in advance. regards, Park

2002-03-18

2 reads

Time Out error in SQL reports

• by NinjaWolfen

• Intelligent Enterprise

• Topic

Please, someone help me I'm working with VB SQL server 7.0 and crystal Reports doing a SQL internal report from VB with the crystal designer ocx but in design time it makes an error: Microsoft OLE DB provider for SQL Server: wait Time finished. this happends when i insert an SQL Query into the crystal […]

2002-03-18

Failure to fire trigger

• by drew_walker

• MSDN Communities

• Topic

I have created a trigger on one of my data tables to execute a DTS job eg: EXECUTE msdb.dbo.sp_start_job @job_name= 'Output_Data' If I run this from the SQL Query Analyser it actually works, but when I put it into an INSERT trigger there doesn't seem to be any output ???

2002-03-18

3 reads

Stored procedure debugging from VB

• by rajayan

• SQLServerCentral.com

• Topic

Hi All, I am facing a few problems for debugging a stored procedure from VB using T-SQL Debugger. I am debugging against a default instance of sql server 2000, not named instance. I am able to debug with sql server 7.0 but not with sql 2000. On doing a 'execute' for ADOCOMMAND, I am getting […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2002-03-16

1 reads

Extracting most recent entry

• by akumok

• SQLServerCentral.com

• Topic

Hi, I have a table StatusLog (LogID, Status, StatusDate) which store history of statuses for each LogID. For example, LogID = 1 will have 2 statuses "Requested" and "Send" (2 records), LogID = 2 can have 3, "Requested", "Send" and "Shipped" (3 records). Ofcourse StatusDate stores corresponded date. I need to find the way to […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2002-03-04

1 reads

Some Questions for you to answer.

• by harrywwh

• JumpStartTV

• Topic

#1. Can people make a living on DBA, Achitect, engineer, etc? #2. What are the fundamentals of Database?(mainly SQL, sometime people don't know what the heck this is but still they got the job and flowing around) #3. What is the most popular SQL server? Is it Oracle, Sybase, Inres, IBM, MYSQL or something else? […]

2002-03-01

3 reads