Viewing 15 posts - 1,021 through 1,035 (of 2,052 total)
Was there a new snapshot since the reactivation?
July 21, 2008 at 5:28 am
You will have to find why it is timing out. (bad code, bottlenecks, no indexes, ...)
Execute sp_who2 will show you a list of connections and if they are blocked. Sql...
July 15, 2008 at 10:47 am
I haven't much experience with replication. Is it feasible to store the inserts in a seperate table?
July 10, 2008 at 3:03 pm
Can you explain your goal a little further?
1.Redirect a page on the webserver to another (with changepermissions on the server)
2.Using a kind of plugin to generate an identification control (like...
July 10, 2008 at 3:00 pm
pure guess:
A basic knowlegde on Active Directory (add/remove users, trusts between domains, consulting performance counters/event log, security settings) besides some basic pc troubleshooting.
July 10, 2008 at 2:33 pm
When exactly does the script stop from working.
According to the IE error, it is when the "count" variable is introduced.
Any mix in lettercase?
Does a select ownerID FROM callRecord instead of...
June 21, 2008 at 11:09 am
Which field are trying to modify?
* CONSTRAINT [eq_em_id] FOREIGN KEY
(
...
June 20, 2008 at 11:08 am
You could improve the accurary of the report with
DBCC UPDATEUSAGE
( { 'database_name' | 0 }
...
June 20, 2008 at 11:05 am
Hello,
If sql server is started with some trace flags (see the article), it logs detailed information in the sql server log.
Microsoft article about resolving deadlocks in sql server:
June 18, 2008 at 2:56 pm
Same as normal tables I guess. (available storage)
They are only recommended when the expected number of records will be low.
(due limitations like no indexing ...)
June 18, 2008 at 2:46 pm
The actual "start" values are mostly in the RPC starting and SQL Batch starting events.
June 18, 2008 at 2:38 pm
The different computernames can cause issues.
June 18, 2008 at 2:29 pm
Should be visbible in the version number
SELECT @@VERSION
or
execute xp_msver
List of version numbers:
http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx
June 17, 2008 at 11:53 am
My apology for the pause.
Have a look at the end of
http://www.macronimous.com/resources/stored_procedures_for_ASP_and_VB_Programmers.asp
or
http://msdn.microsoft.com/en-us/magazine/cc163987.aspx
A more elaborate version inside the stored procedure:
http://www.novicksoftware.com/coding-in-sql/Vol3/cis-v3-N12-making-stored-procedures-readable.htm
June 17, 2008 at 11:50 am
You're welcome
June 17, 2008 at 12:29 am
Viewing 15 posts - 1,021 through 1,035 (of 2,052 total)