Viewing 15 posts - 5,341 through 5,355 (of 7,429 total)
Other than that what are the names of the processes and the steps in them. Also what are they doing, replication is an item that works this way. It continues...
June 21, 2002 at 5:37 am
It is the fact you are issuing a READUNCOMMITTED which is equivalent to NOLOCK hint.
From BOL
quote:
Do not issue shared locks and...
June 20, 2002 at 7:31 pm
Check out thread http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=4157&FORUM_ID=49&CAT_ID=1&Topic_Title=Default%20Values%20of%20a%20Stored%20Procedure&Forum_Title=Strategies for more details and a link to a sp that a member posted to help.
"Don't roll your eyes at me. I will tape them in place."...
June 20, 2002 at 7:26 pm
Run again but turn on the text data column it should hold the actually text message. I believe thou you are getting a "timeout waiting for server to answer" and...
June 20, 2002 at 7:23 pm
Also of note is if you do anything in Stored Procedures with sp_executesql or EXEC('sqlstring') they execute out of the scope of the SP owner and rights and under those...
June 20, 2002 at 5:28 pm
Ok first how did you define your connection to Unisql (the linkled server parameters)? Also with Oracle I found sometimes tables do not show up depending on the owner. To...
June 20, 2002 at 5:25 pm
Do you have unicode enabled on PostgreSQL? I don't work with Postgre but I beliueve UTF8 has to be enabled to be able to insert unicode values otherwise ASCII is...
June 20, 2002 at 5:02 pm
Take a look at this thread. http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=2490&FORUM_ID=20&CAT_ID=2&Topic_Title=Accessing%20an%20AS400%20File%20Share%20from%20SQL&Forum_Title=Connecting Ultimately they ended up using Active Scripting to first create the mapped drive then move the files over.
"Don't roll your eyes at me....
June 20, 2002 at 4:48 pm
However delete triggers do not fire if the query is truncate table. This is why I suggest use profiler so it cannot get away and you see the exact query....
June 20, 2002 at 4:42 pm
Timestamp is not a date time value. From BOL.
quote:
Is used to indicate the sequence of SQL Server activity on a row,...
June 20, 2002 at 9:33 am
Views, triggers and check constraints can also be done that way. But to tie the table together you have to look at sysobjects, sysindexes, syscolumns, and a few other places.
"Don't...
June 20, 2002 at 6:09 am
The only thing is you state access database. If this is for an Access DB then a few syntax changes are in order.
SELECT
newsid,
news_cat,
Count(news_cat) AS outputcolumnnamehere
FROM [tablename]
WHERE logdate BETWEEN #18/06/2002#...
June 20, 2002 at 6:05 am
Cool, had never thought of that. Works great.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 20, 2002 at 5:54 am
For logins look at sp_addlogin in BOL. Then GRANT, REVOKE, DENY for tables, views, procedures and many other pieces. Look at the permissions sections of each. I test sp_addlogin and...
June 20, 2002 at 5:45 am
Have not seen any tool that produces the same scripts as EM does, I started work on code to do it but have not finished and don't know when I...
June 20, 2002 at 5:36 am
Viewing 15 posts - 5,341 through 5,355 (of 7,429 total)