Lowell

Forum Replies Created

Viewing 15 posts - 13,096 through 13,110 (of 13,460 total)

RE: Alter table permissions

It might be that they are connecting via enterprise manager with their Windows credentials, but connecting via Query Analyzer with a SQL login;
in that situation the SQL login might have...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

April 19, 2006 at 6:01 am

#633025
RE: Foreign Key Reference

assuming you know the tablename and the PK value you wanted to test for (assuming a single column for the PK)
This also assumes that Foreign keys are created, and not...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

April 18, 2006 at 10:45 am

#632904
RE: Foreign Key Reference

not enough information, i think Ashok;
do all the transaction tables have Foreign key references to the master table? Are you talking about the CASCADE option on foreign keys for update or...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

April 17, 2006 at 8:56 am

#632775
RE: turn time in excel into epoch time for sql server 2000

note that the number of milliseconds will overflow an int value, so you've got to use a bigint datatype:

declare @DateOfInterest datetime,
@EpochDate datetime,
@millisecs bigint
set @DateOfInterest = '12/11/1962'
set @EpochDate = '1/1/1970...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

April 13, 2006 at 8:01 am

#632389
RE: Use sp_MSforeachtable to gen COUNT(*) for each table in MyDBname

how about this?
sp_MSforeachtable @command1="select '?' AS TABLE_NAME,count(*) from ?"
results:
TABLE_NAME
---------------- -----------
[dbo].[SFPORGLM] 0
TABLE_NAME
--------------- -----------
[dbo].[GMHOME1] 426
etc.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

April 7, 2006 at 7:58 am

#631489
RE: Sybase To SQL 200

syntax-wise, it raises no errors in SQL Query Analyzer; the sybase statement needs no conversions to get it to be correct in SQL Server.
without the data, i do not know...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

March 31, 2006 at 10:22 am

#630185
RE: Is there any web based analysers for MSDE

how about:
SQL Server Web Data Administrator
http://www.microsoft.com/downloads/details.aspx?FamilyID=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

March 29, 2006 at 3:06 pm

#629668
RE: How to create a foreign key that points to a table in different database

well i could see that you can add viewnames with the identical table names for each of the 450 lookup tables, and use them in your application, but that would...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

March 29, 2006 at 9:08 am

#629522
RE: Print a report w/o opening

older versions of Adobe reader supported a command line /t, so you could call acrord32.exe with the proper command line parameters in order to print and then kill adobe reader;
this...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

March 29, 2006 at 5:17 am

#629443
RE: How to create a foreign key that points to a table in different database

cross database foreign keys are not possible; the best you can do is create a trigger that performs the logic to make sure the relationship exists that you are trying...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

March 28, 2006 at 10:11 am

#629244
RE: Prompt for User Input to set variable

not directly from TSQL, no; you'd have to write a program that would prompt for input, and then use the input in the sql to be performed;
Oracle (or rather, SQL...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

March 23, 2006 at 3:17 pm

#628475
RE: SQL server alerts when database stops

i learned a bit more myself; if you go to a command prompt and type net start the list of all services will be displayed;
pretty much every service listed will...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

March 22, 2006 at 6:53 am

#628073

RE: SQL server alerts when database stops

hopefully someone else will chip in on how to alert the operators;

all services on a server can be started and stopped with the NET START /NET STOP command:

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

March 21, 2006 at 3:26 pm

#627987