Viewing 15 posts - 5,146 through 5,160 (of 7,429 total)
Take a look at DBCC LOG here http://www.sqlservercentral.com/columnists/achigrik/sqlserver7someusefulundocumenteddbcccommands.asp otherwise you will need a third party tool such as LogExplorer to look at the logs information. DO you have any inadvertant...
July 19, 2002 at 8:53 am
No I meant ISNULL(column1,1) * ISNULL(column2,1)
coalesce is better for multiple evaluations say if i want to output column2 if column1 is null and 0 if column2 is null. I only...
July 19, 2002 at 8:50 am
The error "%1 is not a valid Windows NT application" should have abit more too it. Something similar to this: "DCOM error: %1 is not a valid Windows NT...
July 19, 2002 at 6:17 am
First to save headache you need to have a table or a field that relates Products to Newsletters.
quote:
If a customer purchases a...
July 19, 2002 at 6:14 am
You know I hadn't thought about that, but you might just be right. Without aliasing the tables and qualifying which one it is from it may be the same situation...
July 19, 2002 at 5:54 am
If you run the movement from the Standalone EM not on the SQL Server then the data crosses the machine EM is on. Pulled from Oracle and Pushed to SQL....
July 19, 2002 at 5:47 am
Strange things do happen, glad you found a solution.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
July 19, 2002 at 5:42 am
Sorry brain gas. Try this
SELECT DISTINCT accountno FROM ContSupp oQ WHERE NOT EXISTS (SELECT * FROM ContSupp iQ WHERE rectype = 'E' AND iQ.accountno = oQ.accountno)
Your other code should work...
July 18, 2002 at 6:47 pm
Also why not just do
select distinct accountno from contsupp where rectype != 'E'
which is the same thing.
"Don't roll your eyes at me. I will tape them in place." (Teacher on...
July 18, 2002 at 6:29 pm
That is the only way you will see the SQL login account. A user must be loging in under Windows Authentication for you to see the Windows account domain/name.
"Don't roll...
July 18, 2002 at 6:25 pm
Look at the functions USER, USER_NAME, and CURRENT_USER.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
July 18, 2002 at 6:00 pm
Not sure, you should have it scripted and he should make a script backup of anything it replaces. You should announce a downtime that occurrs after a full back preferred...
July 18, 2002 at 5:53 pm
Roberts right, views do not support variables in any way. You will have to use a Stored Procedure or create a script of code but views are out.
"Don't roll your...
July 18, 2002 at 5:43 pm
That then confrms that it is a COM object DLL that is the issue. The only problem is I am not familiar with InitDimSlices and find no documentation on it...
July 18, 2002 at 1:14 pm
Sorry currently I do not have .NET installed on a mchine as I am working on another project. I was wanting to look at what you have done to see...
July 18, 2002 at 12:05 pm
Viewing 15 posts - 5,146 through 5,160 (of 7,429 total)