Forum Replies Created
Viewing 15 posts - 2,761 through 2,775 (of 13,459 total)
-
RE: Rename SQL Server not working
renaming a server is a two part process;
one occurs at the operating system; the second is for convenience in SQl server.
You rename the server and then reboot.
AFTER that has occurred,...
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! -
RE: Stored Procedure System Definition
scripting from the GUI, whether create or alter, will contain the same definition, but the GUI adds
this like SET ANSI_NULLS ON and other settings; potentially the USE [database] statement as...
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! -
RE: Composite Primary Key Help...Query
well answers to questions for an Ingres database will hopefully conform closely with TSQL answers you get here.
the question is not really clear to me; when you run your max...
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! -
RE: How to Read tables from Inserted table (trigger)
Minnu (12/17/2013)
Hi,Thank you for Speedy response.
my question is, when i print the values from trigger
print @id
print @name
Print '--'
am getting
1
D
--
but as per my table id's 1 and 2 are updting,...
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! -
RE: unknown user has rights in the db's
i'm thinking that your user is in a windows group that grants them permissions you didn't expect.
this query seems to get all the individual mappings for all the groups i...
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! -
RE: How to Read tables from Inserted table (trigger)
yeah syntax is important here;
you already identified that you know the a trigger should refer to the virtual inserted or deleted tables;
the key is that the original table needs to...
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! -
RE: Is RDP Access Needed for a SQL Server Administrator?
defyant_2004 (12/16/2013)
We really want to protect the server and limit the amount of unnecessary access. Although I am not an expert at DBA work, I have used SSMS in...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! -
RE: SQL Server Express Does Not Provide A Way to Setup Maintenance Plans
defyant_2004 (12/16/2013)
We just installed a couple of SQL Server Express editions with a few standard databases.Our DBAs are insisting that SQL Server Express does NOT provide the necessary tools to...
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! -
RE: Is RDP Access Needed for a SQL Server Administrator?
As a DBA, the #1 reason (for me) I seem to need access to the server itself are for diagnosing ETL issues and managing of SSIS packages;
we have a...
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! -
RE: Need help on improving a where clause, thanks.
I think you'd just extend the WHERE statements in the query to also compare the @RoleId :
how about this?
and g.ID in(Select ID From Groups
...
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! -
RE: DatabaseMail
5.5.1 implies you did not set up your db mail to send the basic authentication to have the username and password:
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! -
RE: Convert Columns to Row in SQL
jeganbenitto.francis (12/16/2013)
Can Anyone please help me in below requirementi have a row as below
1 AAAA BBBB CCCC DDDD EEEE FFFF GGGG HHHH
I...
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! -
RE: Login failure for user 'NT AUTHORITY\ANONYMOUS LOGON'
whoops i cross posted from anotehr post;
can you show us /script out your linked server?
that would help us diagnose the issue for you.
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! -
RE: Login failure for user 'NT AUTHORITY\ANONYMOUS LOGON'
look at the stored procedure in question...i'd bet it is referencing a linked server. the login is failing at the linked server because whoever is calling it doesn't have mapped...
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! -
RE: BCP Out Failure About Login Failure
my first guess is permissions; xp_cmdshell doesn't typically use the network permissions you expect.
run this command, and it can help you see if the user SQL uses for disk access...
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!
Viewing 15 posts - 2,761 through 2,775 (of 13,459 total)