Viewing 15 posts - 3,361 through 3,375 (of 9,643 total)
I have not seen this issue. I ran a simple test with a fairly long email from Outlook and could read the body in sysmail_allmailitems.
SQL Server is just storing...
January 29, 2010 at 8:34 am
SQL Express does not include SQL Server Agent so you can't run jobs from it.
I'd suggest creating a batch file that uses sqlcmd to execute the procedures. You could...
January 29, 2010 at 8:08 am
Well, you would use BIDS (Business Intelligence Development Studio) and do a new SSIS project. You'd have at least one DataFlow task that would include a Flat File source...
January 29, 2010 at 8:02 am
Pete,
I think the method you mention is the way to go. One thing to keep in mind is that you don't need to add a column tot he table,...
January 29, 2010 at 7:58 am
CirquedeSQLeil (1/28/2010)
Jack Corbett (1/28/2010)
Alvin Ramard (1/28/2010)
CirquedeSQLeil (1/28/2010)
Today is a Thread Gone Wild day - and I am still catching up.
So will you pay for travel expenses of those denizens that...
January 28, 2010 at 10:34 am
Alvin Ramard (1/28/2010)
CirquedeSQLeil (1/28/2010)
Today is a Thread Gone Wild day - and I am still catching up.
So will you pay for travel expenses of those denizens that are closer (Jack...
January 28, 2010 at 9:44 am
Steve Jones - Editor (1/28/2010)
January 28, 2010 at 8:38 am
Dale,
If the OP uses a logon trigger to block SSMS\Query Analyzer and still uses sa then they have locked themselves out from using that tool as well.
Another issue with using...
January 28, 2010 at 8:05 am
This actually sort of goes along with the SQL Injection theme and the original theme of the thread. Several Threadheads have already chimed in. It's the thread where...
January 28, 2010 at 7:45 am
jcrawf02 (1/28/2010)
GilaMonster (1/28/2010)
jcrawf02 (1/28/2010)
... that I'm still just directly concatenating the user input into my SQL.
No you're not. There's no concatenation anywhere in that piece of code. Concatenation means...
January 28, 2010 at 7:35 am
1. You should NEVER use sa.
2. There is not a simple way to block users from accessing SQL Server using query analyzer or any other application once you...
January 28, 2010 at 7:13 am
You can query sys.dm_exec_requests using the session_id (spid) and cross apply to sys.dm_exec_sql_text using the sql_handle.
January 28, 2010 at 7:08 am
You definitely would need to change your data sources to reference the correct instance. You could also use DNS Aliases as described by Allen Kinsel here.
January 28, 2010 at 7:04 am
How are inserts/updates/deletes being done? Are you using Stored Procedures or Ad Hoc sql in the application? Do you have control over how it is done?
The first thing...
January 28, 2010 at 6:55 am
This procedure takes 3 parameters, is_sysadmin, job_owner, and job_id. After some testing, it appears that you must be sysadmin to run this procedure without the job_id parameter.
January 28, 2010 at 6:50 am
Viewing 15 posts - 3,361 through 3,375 (of 9,643 total)