Viewing 12 posts - 811 through 823 (of 823 total)
Try putting brackets around the database name:
select name from [QA_WSS_Search_NSAB-SS82-SPF-N].dbo.sysfiles;
go
SQL no likey the dash, probably sees it as a minus sign.
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
August 27, 2009 at 12:36 pm
Congrats on the new position, I found myself in similar circumstances. I went thru this book:
http://www.microsoft.com/learning/en/us/book.aspx?ID=9364&locale=en-us
and was able to pass the test on the first try. It took...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
August 17, 2009 at 9:55 am
johnyjj,
Here's a link to get SSMS express installed:
http://msdn.microsoft.com/en-us/library/ms365247.aspx
I'm not sure with the Express edition, but with full installs, if you don't choose to install the "tools, documentation" option, SSMS doesn't...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
August 13, 2009 at 8:49 am
I know this is an old post, but I'm having the same problem. Based on research I've already changed:
allow updates to 0
CPU and I/O affinity set to Automatic
Seems others...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
July 28, 2009 at 3:28 pm
Thanks so much Gail. Do you think my database was backed up properly?
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
July 24, 2009 at 12:39 pm
I guess I shouldn't have asked the question, as it isn't pertinent to the issue. I'm trying to find out why my user is 'broken' now, will post back...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
July 24, 2009 at 10:40 am
Thanks Alvin. But shouldn't the 'Local System' account have enough privileges to run the job?
http://msdn.microsoft.com/en-us/library/ms143504.aspx
I changed the job owner to 'sa' (from my domain account) and it ran correctly....
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
July 24, 2009 at 9:28 am
I found that the email account that I was using to try and send email was not configured properly. Found this out by talking to my email admin. ...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
July 22, 2009 at 9:32 am
Could be a bug:
http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/6f143ca9-d08c-4028-9fef-58ae62ae5fc6
I'm going to follow up with Microsoft.
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
July 16, 2009 at 9:50 am
Thanks Jeff. But as I stated, that area was changed to email me and I've yet to see any email. Also, when I look at the properties of...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
July 16, 2009 at 9:03 am
Found an answer for question number 2:
https://metalink2.oracle.com/metalink/plsql/f?p=130:14:2551972738979005909::::p14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_frame,p14_font:NOT,466228.1,1,0,1,helvetica
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
June 22, 2009 at 2:48 pm
Thanks for the input, Lynn. It doesn't appear to be a problem to mismatch those column definitions, based on some tests I did, though:
create table test_n_id2
(
n_idvarchar(20)
)
----------------------------
insert into test_n_id2
select
national_id
from...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
June 18, 2009 at 2:35 pm
Viewing 12 posts - 811 through 823 (of 823 total)